Subject | Re: [firebird-support] DBExpress driver... |
---|---|
Author | Marcos Vinicius Dufloth |
Post date | 2004-08-23T12:04:15Z |
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:
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,[Non-text portions of this message have been removed]
>
>
>
>>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
>
>
>
>
>
>
>
>
>