Zeoslib Portal

One, partial, solution.

When I don't need the value as a Variant and want only to test it against Null, I can use the field's IsNull property. This method doesn't generate an error.

Thanks again.

- I'm using Zeos 6.6.5 stable. Will test on SVN if needed.
- I'm using Delphi 5 and it may be the catch (it doesn't support Variant type vtInt64; VT_DECIMAL (=14) used in ZVariant unit works but it creates an unusable Variant ("Unknown type 14")).
- QHl is TZQuery

The table is declared in Czech, the declaration is very long and I doubt it's of any use.

Hi seawolf, thank you very much for your efforts but it didn't work for me. Do I need to recompile Zeos after the changes? I added your recommendations and recompiled the Zdbc and ZComponent packages but still no change. Maybe another code point is still causing variant type 14 to appear as that big...

Hi all, I encounter the following error using ZeosLib (v. 6.6.4 and 6.6.5). In my code: if DMCis.QHl.FieldByName('CF').Value<>Null then the Value returned is shown in Delphi as "Unknown Type: 14" . An error is raised saying "Invalid variant type conversion" . The undelying data f...

I have a simple question.
How do I get to and start a transaction in non-autocommit mode without an error?
(AutoCommit := False; StartTransaction => "Cannot start a transaction in autocommit mode")

I wrote "today" but still didn't have the time. Now I'm on my holiday so maybe as I return to work. My apologies.

OK, Sandeep, I still have a question about SQLite, I'll write you a private message (pm).

It looks like Zeos is going to work on WinCE. I'll look at the recent snapshot and try it, maybe today.

A bit off-topic but hopefully still in its place:
Is the SQLite server placed on your mobile device or out of it - on a PC?
I don't know much about SQLite; we'd like to access a database storage offline that would be installed directly on the device and then copy the data to a PC DB server.

We changed our attention to the Lazarus' ODBC component. Alas, it fails to load data from a Sybase ASA9 query on WinCE. By now, we still don't have a working database access. Maybe we shall return to Zeos or write our own lightweight driver. Still it seems to be the easiest way to correct or rework ...

Hello folks, our company is very interested in using Zeos on PocketPCs. If it was possible and I was successfull, I would post a patch to the Zeos code to bring it to work on WinCE. Still no success but there are some steps already made. 1) Concerning the assembler instruction . I don't know if it's...