topic Re: syntax error in table in Application Development and Automation Discussions

syntax error in table

Former Member — Mon, 23 Jun 2008 06:15:41 GMT

I have created table Z1YCHSTATUS_D.

when i activate this table i got syntax error.

Errorr is

Check table Z1YCHSTATUS_D is also foreign key table

Anyone pls advise me

Re: syntax error in table

Former Member — Mon, 23 Jun 2008 06:20:42 GMT

Hi Kumar,

Check table always contain one record corresponding to the key.

Where are the Foreign key is related to the check table .

&**************Reward Point if helpful***************&

Re: syntax error in table

Former Member — Mon, 23 Jun 2008 06:21:42 GMT

You might have given the foreign key relationship with the same table Z1YCHSTATUS_D itself.

The table itself was specified as check table. Only those values which already exist in the table are therefore possible. For this reason no values could be entered in the table.

Delete the foreign key to the field or remove the flag for the key field.

Regards

Kannaaiah