key is temporary

[tobenschain 0]

using FireDAC i am creating a table at runtime with a primary key. how do i make the key permanent ?

[Lajos Juhász 293]

You can simply achieve that by changing that option and then recompile your source.

 

Seriously you believe we can see your monitor and to read what you're doing?! You should give enough information. We don't know which database you're using and what you're doing. In SQL there is no concept of temporary primary key. You have only two options when you create a database table. The table has a key or it doesn’t (you can also create a primary key and later drop it).

 

[tobenschain 0]

thanks 

 

i was calling CreateTable before defining index

[Lajos Juhász 293]

You have to define the primary key in create table statement. Index on query component will not add a PK on database.