[Kexi] Problems with primary key

[Karsten Schwager]

Hallo Jaroslaw and Martin,

I tested a little bit more. Every time when I try to insert the 
data into the fields I got the error message and I have to abort 
the action. But when I closed and reopened the database I find 
the data stored in the fields twice or more. It depends how 
often I tried to insert the datas. Quit currious I think!

I atached the database file with the email. I hope I got no 
complains for sending it to the mailing list but it's quit 
small.


Thanks

Karsten



Am Donnerstag Februar 2 2006 15:30 schrieb Jarosław Staniek:
> Martin Ellis said the following, On 2006-02-02 14:50:
> > On Thursday 02 February 2006 11:55, Jarosław Staniek wrote:
> >>>Message from server:
> >>>near "index": syntax error
> >>>SQL statement:
> >>>SELECT "index" FROM table1 WHERE
> >>> "index"=18446744073709551615 LIMIT 1
> >
> > IIRC, in general, we need to specify table names where a
> > column name is quoted, e.g. table1."index"
>
> Other thing is surprising to me - the index value:
>
> 18446744073709551615 == 0xFFFFFFFFFFFFFFFF
>
> Well, I can say something after looking at the database.

-- 
- "Pardon me for living, I'm sure."
- NO-ONE GETS PARDONED FOR LIVING.
(Mort)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Test_Database.kexi
Type: application/x-kexiproject-sqlite3
Size: 10240 bytes
Desc: not available
Url : http://mail.kde.org/pipermail/kexi/attachments/20060202/6bf97d81/attachment.bin