Zeoslib Portal

Hello IbeDBob,

I don't know if Zeos Datasets do have this special ability. But you could always save the record count into some kind of a variable or in the Tag property in the AfterOpen event, before filtering the records.

Best regards,

Jan

Hello Densetsu7,

to me this seems to be some kind of character set conversion problem. Which IDE do you use? (Delphi version / Lazarus)? And what is the setting for TZConnection.ClientCodePage?

Best regards,

Jan

Hello IbeDBob, I am not sure, wether it is a good Idea to directly manipulate the IndexFieldNames property. Maybe it is better to use the SortedFields property. To make a long story short: AFAIK it should be possible to do as you describe because these indices are normally only used by Zeos to sort ...

Hello IbeDBob, I found this on Stackoverflow: http://stackoverflow.com/questions/3839669/dll-file-for-windows-7-64bit According to this answer it is possible to compile SQLite with 64 Bits. So if you want to compile it yourself, you can stay with Lazarus x64. Otherwise you will have to change your a...

Hello bukem, the convertion error normally is something that is created by Firebird. The first thing, I see is that you did no define a primary key for your table. Did you just forget to copy this part here this or did you really not do it in your database? Also I have some additional questions: Wha...

Hello Beri75,

Zeos 6.6 simply doesn't work with the client library of Firebird 2.5. If you need to stay with BCB6 and thus with Zeos 6.6 you can use an FB 2.1 client library for connecting to a 2.5 server too.
Best regards,

Jan

Hello mafro_cz, What is the message of the -501 error, you get? These SQL-Codes tend to be quite ambigous. This applies to the -501 error too - it has at least two possible meanings. If you need an immediate solution and it works, I can only suggest to use firebird_2.1 now and use the LibraryLocatio...

Hello IbeDBob,

why would you want to do that? Why not simply do ? Normally Zeos should update all internal structures on its own and SQLite will update its indices on its own too?
Best regards,

Jan

Hello bukem, it seems that in your use case you don't need to use the ZUpdateSQL. ZUpdateSQL is meant to be used, if you want to do special things like updating read-only data, that is gathered by a non-updateable view or by a join, where you might want to update more than one table. In the normal u...

Hello AndreasAtMBS, Delphi is doing the typecast and so the conversion in both cases. The first time it issues a warning because you do an implicit conversion and conversions from unicode to ansi might cause data loss. The second time it doesn't issue a warning because you do en explicit typecast an...

Hello IbeDBob,

I don't know nothing about Zeos 6 and SQLite 3. But if you have this many problems, maybe you should consider using Firebird embedded or something like this?
For Firebird I know that it works well up to Version 2.1 with Zeos 6 and Delphi 6.

Best regards,

Jan

Hello Zeos Team, for me it seems like I found the bug. In ZDbcStatemant.pas there is a function TZAbstractStatement.GetEncodedSQL. In that function there is a line ttWord, ttQuotedIdentifier, ttKeyword: Just add ttComment to it. For me this fixes the problem. A diff -uN is included in this post. Bes...

Hello The_Immortal,

maybe this is because newer Delphi versions create subfolders for every build configuration like win32/debug and win32/release in your project folder? This way the executables probably don't get placed in the same folder as your library?
Best regards,

Jan

Hello Michael, it seems to only happen in comments. my current Script looks like this: insert into testtable (ID, TEXT) values (1, 'this is a test for umlauts äöüß') ^ create procedure testproc as begin insert into testtable (ID, TEXT) values (1, 'this is a second test for umlauts äöüß'); /* this is...

Hello Zeos Team, I had some problems when trying to create procedures in a Firebird database. I put the following code in a TZSqlProcessor: create procedure testproc as begin /* this is a test for umlauts äöüß */ end ^ If the ClientCodepage of the TZConnection is set o UTF8, then only the part up to...