topic Re: Check table validation in Application Development and Automation Discussions

Check table validation

Former Member — Thu, 04 Dec 2008 13:14:34 GMT

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

Re: Check table validation

Former Member — Thu, 04 Dec 2008 13:17:41 GMT

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

Cheers

Ravish.

Re: Check table validation

Former Member — Thu, 04 Dec 2008 13:23:44 GMT

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

Re: Check table validation

Former Member — Thu, 04 Dec 2008 14:00:27 GMT

This message was moderated.

Re: Check table validation

Former Member — Thu, 04 Dec 2008 15:19:50 GMT

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