Zeoslib Portal

I've just looked at your question again and it looks like you need to use a TZupdateSQL component. See TUpdateSQL in the Delphi help.

Regards,

Ben

If you look at the help page for Locate I think you'll find that it's supposed to use indexes. I'm not sure if this is true of zeos but I've never had problems with using it.

Changing from file based databases to RDBMS you will have to change the way you work slightly.

Regards,

Ben

I've never used setkey or findkey but I think Locate will give you similar fuctionality.

Regards,

Ben

The patches are on the sourceforge site. See http://www.sourceforge.net/projects/zeoslib

And no I don't think there is a mailing list. This forum is the best place to get information relating to Zeoslib.

Regards,

Ben

I think this works (from memory):

Remove the Not Null restrictions from the delphi field objects in question. Then if you post the record with these fields set as null PostgreSql uses it's default values. You will have to refetch the row in question to see the row values.

Regards,

Ben

There is an TZQuery.IsEmpty property which may be what you need.

Regards,

Ben

I doubt it. If you really need to reduce the size of your application then you could try just using ZDBC. See the knowledge base.

Ben

I've looked at this previously and come to the conclusion that transaction control for Postgresql in zeos is quite broken. Currently I'm using TransactionIsolationLevel = tiNone and doing my own transactions calling BEGIN, ROLLBACK and COMMIT when needed. When I have time I'd like to see if I could ...

If you are talking about exe compression progs. See here for a discussion and a useful utility: http://www.jrsoftware.org/striprlc.php

Regards,

Ben

You need to use a TZUpdateSQL component. See the docs for TUpdateSQL.

Regards,

Ben

If you see the documentation for TBDEDataSet you'll see: "Call ApplyUpdates to write a dataset’s pending cached updates to a database." I assume zeoslib uses ApplyUpdates in the same way. Also I've been using Zeos now for some years against PostgreSQL and never had to call ApplyUpdates. Re...

If you log in you should be able to download it. It's attached to his post.

Ben

A bit more complicated than I thought!

I think the Types unit was mostly extracted from some other units in Delphi 6 (To allow for Kylix compatibility) but Delphi 6 also overhauled lots of stuff to do with Variants so I think this may be a struggle.

Anyone else have any ideas?

Ben

That should only be true if you have CachedUpdates = True on your dataset. Otherwise there's a problem there.

Ben

It seems to me that the only file you need to change to get this working is ZDbcMySqlStatement.pas. Replace function TZMySQLPreparedStatement.PrepareSQLParam(ParamIndex: Integer): string; var Value: TZVariant; TempBytes: TByteDynArray; TempBlob: IZBlob; AYear, AMonth, ADay, AHour, AMinute, ASecond, ...