Zeoslib Portal

Zeos Version: SVN/testing I have a table that contains FLOAT fields. These fields contains values like '4.85'. The MySQL server returns '4.85' but the result set puts this string into a single precision data type that cannot hold the information. So I get something like 4.84999990463 what is not 4....

MissingConsts: I missed two functions in ZMySQLUtils. Inlining: BDS 2006 requires the "Windows"-Unit to be included in the uses statement. I've IFDEF'ed the inclusion. SilentException: While working with a "select * from (select * from mytab, ... where ...) tab where tab..." I ex...

These files are affected (at least my tool reports and fixes them): component\ZAbstractRODataset.pas component\ZConnection.pas component\ZQuerySQLEditor.pas component\ZROSqlEditor.pas component\ZSqlTestForm.pas dbc\ZDbcASAUtils.pas dbc\ZDbcIntfs.pas These files are in Unix format (only LF, no CRLF)....

ZDbcConnection.pas contains two wrong line breaks that cause the compiler to generate wrong line information for the debugger.

It can be easily fixed by opening the file in WordPad and saving it.

If I specify this SQL select: there is no problem in editing the records.

But if I use the quotation chars for the table name: I get the error message "Cannot update this query type".

svn branch/testing (MySQL)

This patch is against branch/testing (rev 42).
It adds the "const" modifier for ref-counted parameter types and it also replaces some Utils functions by faster equivalents.

If you call ZSysUtils.EndsWith with two empty strings, the function returns True. But Delphi's AnsiEndsStr and StrUtils.EndsStr returns False in that case. uses StrUtils, ZSysUtils; Assert( EndsWidth('', '') = EndsStr('', '') ); // => fails Is this intended or is it a bug? BTW: I'm optimizing the fu...

There are lots of functions in Zeos that can be improved in speed. I'm currently introducing thousands of "const" key words for string, Variant, TZVariant and dyn. array parameters what eliminates the compiler magic's reference counting-try/finally blocks. But that meight still take days o...

It would be nice if you could go on modifying the other units, not yet changed.

I'll do it. But I don't know when. Maybe today, monday or sometimes next week.

BTW: There is a CVS directory in the "artwork" directory. I think this one shouldn't be there.

The code is compatible from Delphi 5 to BDS 2006.

And I tested the "property bla[const Index: string]..." with FPC 2.0.0 [2005/05/08]. So this is also no problem.

Here is the first patch (against SVN revision 32). It does not patch the ZDbc units at the moment (because that is a lot more work than I needed the other packages).


Not tested against FPC. Maybe FPC does not like the

property Bla[const Index: string]: TBlabla read...;

The Delphi Compiler will generate faster code if you use the "const" modifier in parameters of the types "string", "variant" and dynamic/open arrays. Also records with such fields can be optimized with a simple "const". (best example: TZVariant) Example: funct...