Zeoslib Portal

Thanks for the link, Wild_Pointer

Sorry for the late, late response. In essence, I want to better understand how Zeos handles database transactions and how to write failsafe code for users attempting to modify the same item of data. If I understand what Wild Pointer & mdaems have said above, it would be better for me to create a...

Can anyone give me details on how Zeos handles multiuser and transaction support in a network environment? If it is possible to have some working code samples, I'd really appreciate it. I've been Googling for a while now but I'm not really satisfied with the little information that I found. Thanks a...

I need some advice concerning how to use a progressbar while backing up or restoring Firebird databases. I wrote a database application in Lazarus/FreePascal and I currently use the Firebird gbak utility whose output is displayed in a Memo field on a form while backing up or restoring my database. I...

Hi, It might due to the date format, like yyyy/mm/dd or dd/mm/yyyy. The main reason I suggest to use 2001/01/01, is to find out the problem really due to date format or not. The problem is not the date format because I'm using the same date format in zeos queries without problems elsewhere. For exa...

klchin wrote:Hi,

Why not try to use DateToStr( EncodeDate(2001, 01, 01) ) to
find out the format needed by firebird.

I don't understand. I thought I already tried that with the second code snippet I posted above. Can you give me more details please?

Unfortunately, I'm still getting the same error. I took your advice & introduced the EncodeDate function in two seperate tests: a) passing the parameters as dates to a stored procedure with date parameters ParamByName('DEBUT_PERIODE').AsDate := EncodeDate(2009, 04, 01); ParamByName('FIN_PERIODE'...

I have written some pascal code to restrict results retrieved from a Firebird 2.1 table based on a start date and an end date. I am having problems passing string parameters to a Firebird stored procedure that fetches these results using ZeosLib components. The stored procedure with string parameter...