I want the Firebird backup tool gbak to write its output to a Delphi stream (with no intermediate file). There is a command line parameter to write to stdout rather than a file. I then use the Exec...

In the following query, I want the equivalent for GROUP_CONCAT(ctAncestors.ancestor ORDER BY ctAncestors.depth DESC) AS breadcrumbs_id in Firebird. So far I got LIST(ctAncestors.ancestor, ',') AS...

I have a query that I use on a MySQL database that orders the result, casting a char database field to integer when possible (when the char string is numeric), so for example the ORDER BY clause th...

I have a one line query: DECLARE VARIABLE var_SecondsOfTime INTEGER; But after running the query I am getting this message: Engine Error (code = 335544569): Dynamic SQL Error. SQL error code...