[Kexi] Problems with primary key

[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.

-- 
regards / pozdrawiam,
  Jaroslaw Staniek / OpenOffice Polska

  Kexi Developer:      http://www.kexi-project.org | http://koffice.org/kexi
  Kexi Support:        http://www.kexi-project.org/support.html
  Kexi For MS Windows: http://kexi.pl/wiki/index.php/Kexi_for_MS_Windows
  KDE3, KDE4 Libraries For Developing MS Windows Applications:
                       http://www.kdelibs.com/wiki