>With vfp6 you could create a rule for a field on a table:
>ALTER TABLE (lcfilename) ALTER COLUMN &lcFieldName SET CHECK &lcFieldCheck
>followed by an index command:
>ALTER TABLE (lcfilename) ALTER COLUMN &lcFieldAndDataType UNIQUE
>
>With vfp7 you must make the index first or you will lose the rule? Anyone else notice this?
Yes,
Right you lose it. This works however :
ALTER TABLE (lcfilename) ;
ALTER COLUMN &lcFieldAndDataType ;
CHECK &lcFieldCheck ;
UNIQUE
Cetin