>I have been trying to use the ALTER TABLE command to create a new non-primary index on a table contained in a database container. I followed the example from the Help screen and the Developer's Guide, but every time I try to code the command in a PRG and try to save it (with the Compile option upon Save) I get a Syntax Error so I can't even save the PRG file.
> Am I missing something? Does anyone have input that could help me get past this problem? Any feedback would be greatly appreciated.
>
> Rudy Nieves
> FOCUS Computer Management & Consulting

Rudy,

For a non-primary index, just use INDEX ON .... TAG ....

If you really need to use the ALTER TABLE syntax, then run GENDBC on your DBC and look at the code generated. It will give you the exact syntax.

Warning: Move the code generated by GENDBC very far away from your data tables. If you run it by accident (double-clicking in Explorer, for example) you will empty ALL your data tables!

Barbara (who just finished restoring from a backup after double-clicking a GENDBC file)