LiveCode Forums.

Posted: **Sat Jul 14, 2007 7:46 pm**

i have created a sqlite db, works! then i have created two tables, okay.
when i open the querybuilder i can see the db and the tables, but the tables havent a primarykey??? there is no way to tell the fields in rev which column. the code of stack is

Code: Select all

put "CREATE TABLE lehrer(lehrerID integer primary key, name.....
revExecuteSQL gConID, tSQL
  put the result into tResult

in querybuilder 2 tables are shown, but no primary key

why cant i correct connect, please tell me the right way .

Ralle

Posted: **Mon Jul 16, 2007 10:37 am**

Unfortunately, the Query Builder cannot extract the primary key information from the database - it's there in the database, but the query builder needs your help ; the combobox is there to allow you to select a column as the primary key.
This primary key column information is then used to update the correct record in the database when you modify the data in this record using a database linked control.
Note that the automated database queries aren't built for creating or deleting records from your database. They're best used for displaying and light editing of existing records.

Jan Schenkel.

Posted: **Mon Jul 16, 2007 10:53 am**

thanks for reply, works, but please show on this topic

http://forums.runrev.com/phpBB2/viewtopic.php?t=930

any ideas
Ralle

LiveCode Forums.

sqlite second try

sqlite second try