Zeoslib Portal

Anyone managed to get Zeos to work with embedded firebird 2.5? From the IDE I'll get "SQL Error: unavailable database. Error code -904. Unsuccessful execution caused by unavailable resource" and from runtime I get Access violation at 00000000 localhost is empty, tried database with relativ...

Why isn't TZConnection (or TZAbstractConnection) inherited from TCustomConnection?
its the same for datasets as well.

TIA

Yep, replaced the ZReadOnlyQuery with ZTable (hopefully data structure wont change) and it now behaves.

Just need to remember to always define field size for SQLite db's in future.

I created a test application from scratch and tried the same db (with field sizes defined) - and it reads the data correctly. The changing field sizes problem must be something to do with my original application and not Zeos. I'll post something in the SQLite section to discuss the 255 being the def...

If you set field size & precision in the sqlite database then ColumnType := ConvertSQLiteTypeToSQLType(TypeName^, FieldPrecision, FieldDecimals); returns the correct fieldtype, size & precision. However during TZAbstractRODataset.InternalOpen which happens later on, those values get changed ...

Thanks for the tip, I thought I would get it sorted when I looked at TZSQLiteResultSet.Open at first, but the problem looks to be a lot deeper in the code :S I've found that 1- zeos defaults to 255 chars for fields with undefined field size (in sqlite) 2- replacing that with sqlite default field siz...

SQLite 3.7.4
Zeos 6.6.6 stable
Windows 7
Delphi 7

Using other software I can see that there is more than 255 characters in the database, but using ZTable or ZQuery only gives the first 255 characters.

How do I get to see all my data?

I tried SQLite mailing list first, and they suggested

SELECT
typeof(Orders.Total/100),
typeof((Orders.Total/100)*Mixes.Percentage),
typeof(count(Orders))
FROM
Orders, Mixes

which doesn't work in zeos (think it doesn't like typeof()), but in sqlite express all 3 return integer.

Hi, I think ZeosLib might be returning fields with incorrect datatypes. count(1) and cast(count(1) as integer) gives a text result? more to the point, cast(((myfloatfield*myotherfloatfield)/100) as real) gives a text result! For example SELECT Orders.ID AS OrderID, Mixes.ID AS MixID, Mixes.Percentag...

worked around it thanks to delphi.about.com
you can double-click the TZTable or TZQuery to bring up the FieldDefs editor

perhaps FieldDefs should be added to the published section of TZTable & TZQuery?

- V

TTable has FieldDefs TZTable seems to have FieldDefs but they aren't avilable at design-time, and they don't appear to work at run-time either. unless I'm doing somethjing wrong:- ztable1.FieldDefs.AddFieldDef.Attributes:=[fahiddencol]; ztable1.active:=true; the dbgrid stills shows the first column....