Hi Marcos,

Interesting - nothing looks "wrong".

Can you send a simple-as-can-be testcase to my
e-mail address ( m.tonies @ upscene.com ) ?

A simple Delphi project with a single form, the required
SQL components on them and a button to reproduce the
issue? I'll take a look at it as soon as possible.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

> Of course I can... the query is very simple:
>
> select * from ABASTECIMENTO
> where RECEBIMENTO = 'T'
> and STATUS = 'A'
> and TAREFAOID is null
> order by DATA
>
> Here my .ini conf file:
>
> GetDriverFunc=getSQLDriverFB
> LibraryName=dbxup_fb.dll
> VendorLib=fbclient.DLL
> DriverName=Firebird
> Database=192.168.0.245:e:\databases\mgl.fdb
> RoleName=
> USER_NAME=sysdba
> PASSWORD=masterkey
> ServerCharSet=
> SQLDialect=3
> CommitRetain=False
> WaitOnLocks=True
> InterXpress for Firebird TransIsolation=ReadCommited
>
> Here my StartTransaction procedure that execute before query open:
>
> TransDesc.TransactionID := 1;
> TransDesc.IsolationLevel := xilREPEATABLEREAD;
> sqlConn.StartTransaction(TransDesc);
>
>
>
> TIA,