Zeoslib Portal

Since Microsoft decided to turn it on, always, it would not make much sense to stay with the trimming code lines. However, they offer session properties to check if this is turned on of off:

http://msdn.microsoft.com/en-us/library/ms175001.aspx

Perhaps you may start of at this link?

http://msdn.microsoft.com/en-us/library/ms187403.aspx

ANSI_PADDING regulates the trailing spaces in varchar fields. For this reason the older code may have needed these lines, but nowadays most dbms's support some kind of ANSI_PADDING control. The driver should not perform this without any developer support for turning it off. I love the Zeos stuff, bu...

After inserting varchar values into the database tables, where values contained trailing spaces, the values were always trimmed when returned. Even if the trailing spaces were in the database table. Even when ANSI_PADDING was set for Sql Server. After much debugging, I found the reason why. It's an ...

Ah, found it. Great (feel silly though)... Found it looking through sources for 'modified':

Equivalent to the TDbConnection I'm missing a small helper method, which I've reimplemented as a single function. procedure TZConnection_ApplyUpdates(aConn: TZConnection; DataSets: array of TZAbstractDataset); var I: Integer; DS: TZAbstractDataset; begin aConn.StartTransaction; try for I := 0 to Hig...

The BDE also supported the CachedUpdate mechanism. It also allowed the developer to set a filter based upon the row state, being unmodified, inserted, updated etc.

This filter was set by using the UpdateRecordTypes.

Is there an equivalent in ZeosLib somehow?

Thanks.