Bonjour,
I'm testing the Driver - quite successfully I must say - on Win2000.
What I'm failing to do is to create a record with an autoIncremental Primary
Key from OpenOffice (Datasource view or Writer form).
The frustrating thing is that from MS Access (2000), it is working properly,
just with the 'INTEGER PRIMARY KEY' autoincremental type of SqLite.
Actually, the record is well sent to the source DB, as I can check
afterwards from DbManager. This is OK for typing ONE record at a time.
Problem is that, in OpenOffice app, trying to commit the record (I mean :
leave the record for going to new/next record) leaves the visible row with
the PKey BLANK, and an Odbc Error MSG is issued : '[Microsoft][ODBC Driver
MAnager]Invalid cursor state - SQL status : 24000'.
I tried to type explicitely 'NULL' in the field, but this is immediately
converted to 0, which happens to be NOT unique.
QUESTIONS :
1. Is there a limitation in the ODBC Driver features I shoud know about
(triggering, probably) ?
2.What sould I do ?
2.1. At OpenOffice level, I must admit that some options in ODBC settings
for the concerned datasource are unclear to me (despite looking into the
doc, which is silent on this issue) :
In Dialog 'Datasource Administration'/Tab 'ODBC', we find a checkbox
'Retrieve generated values', offering 2 more textboxes :
- Auto-increment statement
- Query of generated values
Is there something helping there ? Compatible with the typed field 'INTEGER
PRIMARY KEY', or to be used with a 'NUMERIC PRIMARY KEY'
2.2. At SqLite level
Can I do something at Table definition level ?
Can I make use of the typed field 'INTEGER PRIMARY KEY', or should I
abandon this possibility ?
3. Are there other people somewhere working on OpenOffice + SqLite
Thanks on forward
___________________________________________________
P-Y Delens, Manager
LIENTERFACES - PY Delens, sprl
Avenue Dolez, 243 - 1180 Bruxelles
phone : 32 2 375 55 62
fax : 32 2 374 75 74
mail : [EMAIL PROTECTED]
web : www.lienterfaces.be
___________________________________________________
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
