This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I have tried both SQLLite and SLQ Server Compact. No matter what the NULL setting of fields are, lightspeed sets all fields to not nullable. I downloaded the latest build (as of 4/24/2010) and it still exibits this issue. I have completely deleted the DB from the designer, rebuilt the databases and have had no luck, the only way i can get LightSpeed to work is to set every field to a value regardless of the database settings. |
|
|
|
|
Ok my mistake, only happens with SQLLite3 Forgot to change connection string, SQLServerCe returns the following (i added the KeyTable) The column name is not valid. [ Node name (if any) = ,Column name = Id ] |
|
|
|
|
ok, got Ce working, didn't realize i also needed to create a column called Id in the table i was updating. Still would like to use SQLLite3 though. Thanks |
|
|
|
|
We have not been able to reproduce the SQLite issue. Could you provide us with a copy of your SQLite database so we can investigate please? Thanks! |
|
|
|
