How to definie an Unique key for a field? And how to auto increase an unique key?
How to definie an Unique key for a field? And how to auto increase an unique key?
Where to define an Unique key for a non-numeric field or a combination of fields?
in vfp you would define an index of type candidate. Lokking through Lianja docs on "index",
candidate is not mentioned yet and errors in current refresh,
but Unique and Set unique on/off are metnioned in the docs on index.
Or try through standard SQL language or documented Recital SQL
with the Alter table command. Currently no time to play myself ;-)
HTH
thomas
Just use the INDEX ON command and the UNIQUE keyword, e.g. in the Console:
open database southwind
use employees
index on trim(lastname)+" "+firstname unique tag fullname
Or in SQL, specify the UNIQUE keyword in the CREATE INDEX command, e.g. in the Console:
create unique index sqlfullname on employees (trim(lastname)+" "+firstname)
Bookmarks