Zeoslib Portal

@ guidoaerts, Here is the code : DBPath := 'C:\MYFB_DB.FDB'; MyUserId := 'SYSDBA'; myPw := 'masterkey'; Connect_DB.User:= MyUserId; Connect_DB.Password:= myPw; Connect_DB.Database:= DBPath; Connect_DB.Protocol := 'firebird-2.0'; Connect_DB.Properties.Clear; ZConnection.ExecuteDirect('CreateNewDataba...

In the link, ExecuteDirect is used with mySql. With firebird, 'properties' is used for the work. Perhaps this statement does'nt work with firebird.
Is there any one to confirm or not .

My problem still not solved !

Tahnks.

I tried ZConnection.ExecuteDirect but had a compilation error : Not declared Id - ExecuteDirect !



XP, D7, FB2.0, Zeos 664

Thanks,

ExecuteDirect ? Never used it !

Can you give me more details about the use of this statement.

Where the script must be ? In the Properties proporty ??


Thanks for your reponse

Thanks,

ExecuteDirect ? Never used it !

Can you give me more details about this statement.

Where the script must be ? In the Properties proporty ??


Thanks for your reponse

Hi, I tried to create a stored proc at runtime with an TZSQLProcessor component which has its DelimiterType set to dtSetTerm but when I execute the script I had this message : Invalid Request BLR at at offset 208 invalid parameter number XP, D7, FB2.0, Zeos 664 Here is the code : SET TERM ^ ; CREATE...

Hi,

How to know when a new user is connected to the DB ?

Yes, I can do that by creating or managing something but, if possible, I want it to be done by the server.

Thanks.

D7, FB2.0, Zeos 664

Thanks for all of you,

I found the solution .

Sorry, I don' t seen that of Zeos palette ! I tried that of Interbase palette !
Sorry again.

I tried it but nothing happen's !
I don't understand its behaviour !

An example ???

TIBEventalerter needs IB (GDS.DLL) installation.
I wann't to deal with IB. Just Firebird.

thanks

Hi, How to know when a table is updated by a user in the network. Is there an event on the DB which is fired at the update action ? My idea is to put a timer on the form and perform a refresh action on the table periodically, but I had to perform a Close/Open to get my table refreshed because of the...

Perhaps because your field 'count' is a reserved word ??

RETURNING is setted in the head of the SP !

Thanks a lot for your responses ! Sorry for my lateness ! Have you set ? FProcessor.DelimiterType := dtSetTerm; Have you set paramCheck = true? Yes ! Unfortunately your code cannot be replicated because of missing definition of bud_p,bud_s,bud_R,virement I can send the entire DB. **------------ PS :...

SQL ???

The sql script is sent with the post. The single SQL remained is : sqProc.Script.execute !

Other details ??

Merci.