Zeoslib Portal

well, that's a nice metafor, Mark.
Guido

i think that when you set the filter progammatically, you have to put two single quotes to represent a single quote inside the string;
(Two sequential apostrophes in a quoted string denote a single character, namely an apostrophe.)
guido

Put a TZQuery on your form, fill in the zconnection and the sql and open it.
If you add a TDatasource and TDBGrid, you see the result in designtime.
guido

There are two ways to explore this:
ZConnection.Pingserver looks for the server or
in Zconnection.properties you can add 'timeout=120' (but i don't know for sure if that is the right way)...
guido

maybe you find something in this thread:
http://zeos.firmos.at/viewtopic.php?t=2049
Guido

rename the parameter :Case to something else ?
Guido

you can only filter on fields in the resultset, so add A.field3 to your select ;
or add a WHERE clause to your sql
Guido

:D up and running! (thanks to Mark, naturally): -installed 'full' firebird (to be sure) -created an empty database for firebird, in the \packages\lazarus\build\data map -had to put the full path to this database in the test.properties file -first commented out 'rebuild=yes', and got the GUI (great!)...

got to the next step: found \database\test.properties uncommented all mysql items put in firebird21 settings now the zeoslib.gdb cannot be found (reasonable, it isn't there) I will spend some time trying to find out where to create it, or how to modify the \database\install\install_firebird.bat. (th...

meta.ColumnDisplaySize

Guido

select * from table_name where field_name = 'field_value' use single quotes, and if a single quote should be incorporated in a string, it must be two consecutive single quotes (not a double qoute): 'select * from table_name where field_name = ''field_value''' double quotes are indeed used to referen...

As I said, I downloaded snapshot ZEOSLIB_TRUNK_REV803.zip and did some carefull reading of the \documentation\fundamentals\docs. Installed wincvs and, following the Getting-started-doc, issued the command cvs –d:pserver:anonymous@cvs.sourceforge.net/cvsroot/zeoslib co zeosdbo_rework That got me an o...

I think you can change these properties dynamically after creating the components. var i: integer; with TZTable.create do begin Connection := 'YourZConnection'; TableName := 'YourTable'; open; for i := 0 to FieldCount-1 do begin if Fields .FieldKind = fkData then if Fields .DataType =ftFloat then TF...

change the displayformat property of the numeric field
for example : TFloatField.DisplayFormat := '0000.00'

Guido

with winXP, in lazarus and with zeos6.6.5, I get all three labels showing the string.
Guido