On 12/12/2017 13:38, Gabor Boros wrote:
>> What is "change the ORDER BY ASC/DESC in a query and close/open it"?
>
>
> Meanwhile I realized the sort order is not count.
>
>
>> Is it same statement handle?
>
>
> I use FPC/Lazarus and IBX for connection.
> The test code is:
>
> procedure Proc_Query(in_Query:TIBQuery);
> begin
> in_Query.Close;
>
> in_Query.SQL.Clear;
>
> in_Query.SQL.Add('SELECT * FROM TABLE1 ORDER BY
> (CAST(SUBSTRING(TABLE1.TEXT_BLOB_FIELD FROM 1 FOR 40) AS VARCHAR(40)))');
>
> in_Query.Open;
> end;
>
Can you make this leaks using only ISQL?
1) Running the SELECT statement one after another
or
2) Creating a EXECUTE BLOCK with a CURSOR
Adriano
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
