>Hi
>
>If I read the documentation correctly I should be able to create an index on an expression using Alter Table but when I try the following command I get a syntax error. Can someone tell me what is wrong or whether this is possible? I have tried a number of variations without success.
>
>
> Alter Table UPSystem Add Foreign Key Upper(Module+Name) Tag Name
>
>
>Thanks,
>Simon
Use just the regular INDEX ON command to create an index. You then will be able to turn it into FK using ALTER TABLE command.
If it's not broken, fix it until it is.
My Blog