Zeoslib Portal

Hello aducom, I might be wrong but in your second example I don't see where the parameter f is set. If you never set it to any value it might be null and any comparison with null will fail. As a conseqnece to this the Query ZQ might be empty and in that case the Field v will return null if you Call ...

Hello tocibacsi, I had a similar problem when I tried to use PostgreSQL. ZEOS currently is case sensitive when it comes to table names for PostgreSQL. PostgreSQL usually stores all table names in lower case in its system tables. The only exception is when you quote the table name when creating the t...

Hello amarildolacerda,

which version of Zeos and Delphi do you use? Is it possible for you to provide a test case to reproduce the problem?
Best regards,

Jan

Hello amarildolacerda, I seem to remember that Firebird needs a separate connection per thread. Also only one thread is allowed to connect / disconnect at the same time. Have a look at this thread: http://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/122401 For Zeos I would say t...

Hello rvargas17,

did you also set the DelimiterType property of ZSQLProcessor1 to dtSetTerm? I do this with firebird and it works.
Best regards,

Jan

Hello Marco, are you sure, the exception doesn't happen when you start your program outside of the IDE? Possibly the exception isn't caught by the LCL anymore and you only get messages at the console window - if there is one? Do you see anything if you start your program from the command line? Best ...

Hello SS Prano, I am not sure, wether this scenario is supported by Zeos at all. But if the database is on the same computer as your program you could simply try to delete the file. But if you want to, you could take a look at the database creation code in Zeos 6 and do soemthing similar for droppin...

Hello IbeDBob,

just a wild guess: Did you try to use to most up to date SQLite libraries (Version 3.7.17)?
Best regards,

Jan

Hello doidopb,

first issue - upgrade to 7.0 if you can, as Michael suggests. If you can not upgrade, upgrade to Zeos 6.6.6. Also please post the error message because these contain valuable information at most times...
Best regards,

Jan

Hello EgonHugeist,

I unexpectedly had some time to do the patch for Zeos 7.0. I think 7.0 should be modified too because otherwise it will not easily be possible to migrate from 6.6 to 7.0 if anybody chooses to do so.
Best regards,

Jan

Hello jjeffman, If I have a several DML commands which has to be commited or rolled back together, I must to call StartTransaction before the first one and call Commit after having executed the last one and call Rollback inside the catch exception block. This is exactly what you should do when you h...

Hello jjeffman, could you maybe provide some example code and mark the places where you want transactions to start and to end? Maybe then I can provide this code in two fashions - one for AutoCommit = true and one for AutoCommit = false? The example code should have more than one transaction and at ...

Hello eelias, you could do this by simply installing Firebird 2.1 on the client machine, for example. Or you could use the embedded Firebird server, which is also a client library. Simply download the zip file, extract the contents to your aplication directory and rename fbembed.dll to fbclient.dll ...

Hello EgonHugeist, the patch cannot be directly applied to 7.1. But I will supply a similar patch for 7.1 in the upcoming week :-) I have an Idea on how to support this kind of parameters in a more generic way but it will take some more time to work this out in a way that I can present here ;o) Best...

Hello IbeDBob,

what kind of database do you use? Could you post some sourcecode on how you try to do it? Normally something like this should work: Best regards,

Jan