I found the problem and have a workaround now. The problem is caused by a selection field, which is a text field, that might be null. This field can either be - null - empty string (don't know if this is different from null) -'0' - 0 (don't know if this is different from the string '0')
I'ld consider this as a bug, but I'm not sure who's to blame ;-), SQLite or the Delphi wrapper or my own program I'll study the datatype page again: http://www.sqlite.org/datatype3.html Thank you all for your suggestions, which finally solved my problem, cheers, Stef Mientki Kamer van Koophandel - handelsregister 41055629 / Netherlands Chamber of Commerce - trade register 41055629 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------