Search found 12 matches

by vannus
25.08.2011, 19:20
Forum: Firebird
Topic: Embedded FB2.5 errors
Replies: 1
Views: 557

Embedded FB2.5 errors

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...
by vannus
30.03.2011, 18:05
Forum: 6.6 - stable
Topic: TZConnection not a TCustomConnection :?:
Replies: 1
Views: 148

TZConnection not a TCustomConnection :?:

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

TIA
by vannus
11.02.2011, 03:49
Forum: 6.6 - stable
Topic: Zeos truncates data
Replies: 12
Views: 649

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.
by vannus
10.02.2011, 14:19
Forum: 6.6 - stable
Topic: Zeos truncates data
Replies: 12
Views: 649

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...
by vannus
10.02.2011, 10:04
Forum: 6.6 - stable
Topic: Zeos truncates data
Replies: 12
Views: 649

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 ...
by vannus
10.02.2011, 00:34
Forum: 6.6 - stable
Topic: Zeos truncates data
Replies: 12
Views: 649

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...
by vannus
06.02.2011, 16:13
Forum: 6.6 - stable
Topic: Zeos truncates data
Replies: 12
Views: 649

SQLite 3.7.4
Zeos 6.6.6 stable
Windows 7
Delphi 7
by vannus
05.02.2011, 10:18
Forum: 6.6 - stable
Topic: Zeos truncates data
Replies: 12
Views: 649

Zeos truncates data

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?
by vannus
13.01.2011, 22:20
Forum: SQLite
Topic: calculated fields always string datatype
Replies: 3
Views: 581

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.
by vannus
07.01.2011, 23:01
Forum: SQLite
Topic: calculated fields always string datatype
Replies: 3
Views: 581

calculated fields always string datatype

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...
by vannus
26.10.2010, 22:27
Forum: 6.6 - stable
Topic: FieldDefs
Replies: 2
Views: 225

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
by vannus
26.10.2010, 22:11
Forum: 6.6 - stable
Topic: FieldDefs
Replies: 2
Views: 225

FieldDefs

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....

Go to advanced search