Transbase is a specialized database system manufactured by Transaction Software GmbH
Questions tagged [transbase]
6 questions
2
votes
2 answers
How to limit rows in SELECT with TRANSBASE
I'm working with huge records amount in one table and i need to SELECT them in 50000 pages. Is it possible somehow to limit these pages so the query would be faster and row count will be limited and offsetted?
I'm using ODBC with php like this:
…
Petr Velký
- 371
- 2
- 5
- 16
2
votes
1 answer
OFFSET in Transbase
I am working with Transbase DB and stuck on selection of specific range of rows. In MySQL I can do it as folows:
SELECT * FROM table LIMIT 2,3;
I know about FIRST() in Transbase, but how about OFFSET?
Thank you very much in advance.
MarDeS
- 41
- 7
2
votes
1 answer
TransBase, Select all tables containing a given column
I need to query statement to list all tables from a database containing a given column name
in TransBase.
Thank you very much in advance.
Redi
- 163
- 1
- 10
0
votes
1 answer
Connect to Transbase via Spring Boot
I'm currently looking for the most convenient way to connect to a Transbase DB with Spring Boot.
Is it even possible with Spring JDBC? Do I need additional drivers? And what do I need to configure in my application.properties? I couldn't make it…
luck2y
- 13
- 3
0
votes
1 answer
I need to convert SQL to Transbase
I need to convert SQL to transbase because when I use the below script in Transbase I get a pretty ugly error.
My script:
SELECT STR_ID, TEX_TEXT AS STR_DES_TEXT, IF( EXISTS( SELECT * FROM tof_SEARCH_TREE AS SEARCH_TREE2
WHERE…
Andreea Becker
- 1
- 3
0
votes
2 answers
How to change export to mysql to file in php?
Now i have such method:
function exportFromTransbase($table_name) {
$odbc_query = "SELECT * FROM " . $table_name;
$data = odbc_exec($this->odbc_id, $odbc_query);
odbc_longreadlen($data, 10485760);
while($row = odbc_fetch_array($data))
{
…
byCoder
- 3,462
- 6
- 28
- 49