Search found 2 matches

by npage
22.12.2012, 19:00
Forum: ZeosLib 7.0 Beta Forum
Topic: [solved] empty string fields from sqlite being ret. as nulls
Replies: 4
Views: 4904

Thanks for the help guys! @EgonHugeist: DbQuery.FieldByName('value').AsString does resolve the problem. Using DbQuery['value'] returned the correct value (when not null) so I figured it was a valid way to access it. When I tried DbQuery['value'].AsSting, it ran fine, but gave the error noted in my o...
by npage
21.12.2012, 18:39
Forum: ZeosLib 7.0 Beta Forum
Topic: [solved] empty string fields from sqlite being ret. as nulls
Replies: 4
Views: 4904

[solved] empty string fields from sqlite being ret. as nulls

New to lazarus and zeoslib, so please be gentle :) 7.0.2 revision 2078 When retrieving data from an sqlite database fields that contain empty strings (not NULL values) are being returned as nulls and causing errors. Database: CREATE TABLE settings ( category VARCHAR(40) NULL, name VARCHAR(40) NULL, ...