Zeoslib Portal

I did some hacking and made a patch to TZTokenizer.TokenizeStreamToList that joins two tokens if the first is a ttInteger and the next a ttWord. I'm testing it and it looks like it works in my environment. Index: ZTokenizer.pas =================================================================== --- ...

Hi, I have a lot of troubles while working with TZQuery objects that use tables with names that start with a number, ie. 01TabName. Trying to debug the code I noticed that a query like: "SELECT * FROM 01TabName" gets tokenized wrongly and the table name becomes only "TabName", le...

Thanks, I'll check out the testing branch and use it during my conversions from delphi components to zeos. About the key problems, having some experience with data access layers ut no experience with zeoslib I can't say much, but as there is a metadata access layer I would use it to always recover p...

I tried this instead of the if/else block: Result.UpdateBooleanByName('WRITABLE', (Flags and (DBCOLUMNFLAGS_WRITE or DBCOLUMNFLAGS_WRITEUNKNOWN) <> 0)); The row gets update correctly, but the sql generated is wrong, because it doesn't contain primary key in the WHERE clause. For example, given this ...

Uncommenting the code, along with definition of Flags local variable does not work. In this code: if (Flags and (DBCOLUMNFLAGS_WRITE or DBCOLUMNFLAGS_WRITEUNKNOWN)) = 0 then Result.UpdateBooleanByName('WRITABLE', False) else Result.UpdateNullByName('WRITABLE'); it always executes the 'else' part, le...

I think I've found where the problem could be: the method is TZAdoDatabaseMetadata.GetColumns where there are some commented lines, including the ones that should set the Writable flag. I don't have the necessary knowledge of the library (and the time to study it) , but if i put this line: Result.Up...

At first in TZAdoResultSet.Open() the property Writable is true, then it is already false in TZCachedResultSet.Open, in fact adding this row in TZCachedResultSet.Open: Writable := FResultSet.GetMetadata.IsWritable(I); Writable is already false. If you can give me some other hints I can inspect again...

While trying to update a TZQuery with Post() method the rows don't get updated. I'm using ado on a MsAccess .mdb database A Simple test case would be: qr := TZQuery.Create(nil); qr.Connection := Conn; qr.ReadOnly := false; qr.SQL.Add('SELECT fldname FROM tbl'); qr.Open(); qr.First(); qr.Edit(); qr.F...