>Trying to define a table using code. Get a syntax error for "add foreign key" line of code.
>
>

>	add table (gcPLANHOME+lcCHTABLE)
>		
>	use (gcPLANHOME+lcCHTABLE) in 0 excl
>	select (lcCHTABLE)
>	*remove plan table fields from new ch table
>	alter table (gcPLANHOME+lcCHTABLE) drop column inid
>	alter table (gcPLANHOME+lcCHTABLE) drop column indatetime
>	alter table (gcPLANHOME+lcCHTABLE) drop column chid
>	*keep chdatetime
>
>	ALTER TABLE (gcPLANHOME+lcCHTABLE) ADD COLUMN logid I
>	ALTER TABLE (gcPLANHOME+lcCHTABLE) ADD COLUMN uwapprvl C(2)
>
>	alter table (gcPLANHOME+lcCHTABLE) add foreign key planid tag planid  && gets "syntax error"
>	alter table (gcPLANHOME+lcCHTABLE) add foreign key logid tag logid
>	alter table (gcPLANHOME+lcCHTABLE) add foreign key chdatetime tag chdatetime
>

>
>Where is code wrong? Thanks.

Your syntax is wrong. See Re: Where is the Syntax Error Thread #1287604 Message #1287608 You need to check the exact syntax of this command in Help.