[yunqa.de] Re: Autoincrement

  • From: Delphi Inspiration <delphi@xxxxxxxx>
  • To: yunqa@xxxxxxxxxxxxx
  • Date: Thu, 05 Feb 2009 09:26:16 +0100

Hello Token PBX,

>I just loaded The ClientDataset_Grid project in Delphi 2009, and changed the 
>table create command as you suggested. I also added the "ID" field in the 
>select stament. So the situation now is:
>
>CREATE:
>
>    DISQLite3Database.Execute(
>      'CREATE TABLE IF NOT EXISTS Products(' +
>      '"ID" INTEGER PRIMARY KEY AUTOINCREMENT,' +
>      '"Name" TEXT)');
>
>SELECT:
>
>  DISQLite3UniDirQuery.SelectSQL := 'SELECT ID, Name FROM Products';
>
>And the problem is still present.

Works fine here as tested with D7 and D2009. Please send your full project 
sources so I can see the actually problem instead of just its description.

Ralf 

_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa



Other related posts: