Table Creation Problem.

[damodharan]

Dear All,

i created a table like this ,
i need primary key for both column -- id,FNumber

ret = query.exec("create table FilterNumTable "
               "(id integer,"
               "FNumber varchar(20),"
               "Enable varchar(30),"
               "Disable varchar(30),"
               "PRIMARY KEY (FNumber , id))");

ret = query.exec("create table FilterNumTable "
               "(id integer,"
               "FNumber varchar(20),"
               "Enable varchar(30),"
               "Disable varchar(30),"
               "PRIMARY KEY (FNumber , id))");

To copy to clipboard, switch view to plain text mode 

Table itself not creating>any one have idea in QT to how to creata a table with two
primary column.

[tbscope]

Be careful with the queries themselves. There are various SQL dialects. Which database are you using?

[numbat]

What does:

query.lastError().text()

query.lastError().text()

To copy to clipboard, switch view to plain text mode 

return? What database are you using?

[damodharan]

Be careful with the queries themselves. There are various SQL dialects. Which database are you using?

so how to create with two primay keys

[damodharan]

thx to all,
issue resolved.