Check table validation

[Former Member]

Hi all,

I have created a customized table. In one field I have assigned check table and foreign key checkbox is checked. But when this table is updated through a program it goes on creating any entry. Entry is not restricted to the check table values only. It goed on creatting values which are not in the check table.

How to avoid it?

Regards,

Jeetu

[Former Member]

Programattically it'll never goto check table. U'll have to write logic in your program itself to avoid this

Cheers

Ravish.

[Former Member]

Hello,

INSERT, UPDATE are open SQL commands and you cannot restrict the entries in the custom table thru the program. Only thing you can do is to validate the fields againt the Check Tables before creating a record, and that has to be done.

Hope it helps.

Thanks,

Jayant

[Former Member]

This message was moderated.

[Former Member]

Hey Matt,

My 10 points was deducted when I had previously asked for points same as Ankesh.

Just wanted to know what in cases like this ;-).

Believe post by Ankesh has been removed by Moderator.

Cheers,

Jayant

Edited by: Jayant Sahu on Dec 4, 2008 4:22 PM