Zeoslib Portal

I would like to know how TZSQLProcessor works internaly. Is there any way of getting which was the script block that has the error ? Does the TZSQLProcessor has a block count property ? I have Oracle components that identifies the block id which has raised the exception. I guess TZSQLProcessor keeps...

I think I have answered your post at http://zeos.firmos.at/viewtopic.php?p=17231#17231.

Best regards,

Hello marsupilami, Thank you for answering me. As a matter of fact I am not using UTF8Enceode yet. The problem I am facing is that SQLite stores data using UTF8 and, if use SQLite Expert in UTF8 mode to insert text like "coração" in the database tables I am not able the get the text on the...

Hello, As you have broken with the deprecated compilers, could you please help me to improve version 6.6.6, adding charset conversion features to it ? I am not familiar with Delphi (Object Pascal) and I do not know where to start. SQLite stores data in UTF8 charset and if I use the UTF8Encode method...

Can version 7 stable be installed on C Builder 6.0 ? Can you help me some how?

Best regards

I am using Zeos 6.6 stable on C++Builder 6.0 on Professional edition. The SQLite database has charset UTF8. When I run queries using SQLite Expert I can retrieve correct Portuguese charactars. The TZQuery is retrieving data with ANSI characters and "ç" is being retrieved as "ç"....

I was getting the error "[C++ Error] oledb.h(2920): E2015 Ambiguity between 'DBROWCOUNT' and 'Zplaindblibdriver::DBROWCOUNT'". The only solution that worked was to remove the unit which has CBuilder ADO components.

I think Zeos do not get along with Borland's ADO components.

Best regards.

Probably you have ADO components on your application. I think Zeos do not get along with ADO components.

Best regards.

I apologize for not knowing which is the compiler executable ? Can you please tell me its file name ?

I have never used C++Builder in command line.

Best regards.

Hi,

Does the 7.0 stable version have support for C++Builder 6.0 ?

Is it possible to install on C++Builder 6.0 Professional Edition ?

Thanks very much.

Kind regards.

Looking to the error code list ( 29 different codes ) I have found the SQLITE_CONSTRAINT error, which I think may be used to catch attempts to insert rows with the same key value because it will result in a constraint violation, a primary key or unique constraint. Thank you very much for point me to...

Thank you very much.

The application can survive without the error discretization, although it could be better if I it would be possible.

Kind regards.

Is there a way of checking if the SQL error is a duplicate key error ?

Thank you very much.

Hi,

The problem was the code to get the network user using Windows API GetUserName function which returns a buffer ended by a '\0' character.

I have cut the '\0' when present and the application is working fine.

Thank you very much.

Kind regards.

I have made a simple C++Builder application using the same SQLite table structure which I have failed on perform a SQL select to perform user login to the application. When testing the application I saw it was working perfectly. The diferences are : 1. I have said it works at design time. The SQL pa...