Sorry!! Last piece of code is what I used to solve problem...
In ZDbcSqLiteResultSet.pas
TZSQLiteResultSet.Open
TypeName Always Nill...
Search found 5 matches
- 23.05.2007, 12:57
- Forum: SQLite
- Topic: wrong field casting
- Replies: 9
- Views: 3181
According to the code (ZDbcSqLiteResultSet.pas) it seems impossible to make a difference... which SQLite.dll do you use? Yes... True... Both Tmemo and ADD now do the same thing I was doing something wrong... Now I get both wrong ... After further testing I figured out that SQLite Float is returned ...
- 22.05.2007, 11:04
- Forum: SQLite
- Topic: wrong field casting
- Replies: 9
- Views: 3181
- 22.05.2007, 10:48
- Forum: SQLite
- Topic: wrong field casting
- Replies: 9
- Views: 3181
Hi, I tried using TZsqlmonitor as requested : These are the two queries... TMEMO 2007-05-22 11.39.41 cat: Execute, proto: sqlite-3, msg: Select Max(inscRadius) As tfMaxRadius From objectsdata Where ObjectID = 1 ADD(...) 2007-05-22 11.39.50 cat: Execute, proto: sqlite-3, msg: Select Max(inscRadius) A...
- 20.05.2007, 12:44
- Forum: SQLite
- Topic: wrong field casting
- Replies: 9
- Views: 3181
hi... Read your answer but something strange is happening... Why is it that eg. ZReadOnlyQuery3.SQL.Add('Select Max(inscDiam) As MaxDiam From objects Where ObjectID = 3'); Returns TStringField And ZReadOnlyQuery1.SQL.Add(Memo1.Text); with Memo1.Text beeing Select Max(inscDiam) As MaxDiam From object...