What do you think about this Primary Key situation

[Das Goravani]

The default behavior of primary keys in SQLite is good enough for me.. I just couldn’t get them to return a value, but then one person said on the SQLite forum that the inserted value has to be NULL in order for it to return a value.. AHA !  Since the fields WERE RSN’s that were still set to sequence as the field type in my file classes.. so I set the sequence field to be a 32 bit integer which COULD pass NULL to the INSERT and VOILA.. I got back a value.. so I have to change all my sequence fields to 32 bit integers and then VOILA I get what I expect.. 

So that’s the ticket with SQLite and RSN fields.. you need to switch them to a field type that can be NULL and voila..