Subject Re: [firebird-support] DBExpress driver...
Author Marcos Vinicius Dufloth
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,

--

*__________________________________________________________________*
*Marcos Vinicius Dufloth*
*Diretor de Tecnologia
**Cyber Informática Empresarial**

marvin@...* <mailto:marvin@...>
*http://www.tecnocyber.com.br* <http://www.tecnocyber.com.br/>
*__________________________________________________________________*


Martijn Tonies escreveu:

>Hi Marcos,
>
>
>
>>Hi. The Delphi 7 dbx interbase driver don't work with firebird? In
>>deplhi 6, stored procedures runs ok, but with delphi 7 I get Operation
>>not Supported error. Then, I trying with upscene InterXPress (a trial
>>version) but I get Unable to execute query error when trying open an
>>query... Anyone are using delphi 7 with firebird 1.5 and dbexpress???
>>
>>
>
>Can you show the query?
>
>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
>Server.
>Upscene Productions
>http://www.upscene.com
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>




[Non-text portions of this message have been removed]