validate from list?
From: idranoel <idranoel_at_hotmail.com>
Date: 18 Oct 2004 05:09:52 -0700
Message-ID: <9358aa89.0410180409.591d4863_at_posting.google.com>
[Quoted] I have in form a data(not DB) from a lov with a validate from list....for the zip code....this code is not the primary key from table city.
it's good...when the client insert the zip code and it's are more with the same code, will appear the lov....
the problem is when I load a client int the post-query trigger I try to take the zip code and insert him in the field...but if there are more with the same code...it will appear the lov.... I would like that the lov appear when the client insert the zip, but not when I inswert it from pl/sql (post-query trigger).... I try to set from plSQL the validate from list to false and then insert the zip code... and after reset it to true....but the problem is there too....
any suggestion?
thanks Received on Mon Oct 18 2004 - 14:09:52 CEST
Date: 18 Oct 2004 05:09:52 -0700
Message-ID: <9358aa89.0410180409.591d4863_at_posting.google.com>
[Quoted] I have in form a data(not DB) from a lov with a validate from list....for the zip code....this code is not the primary key from table city.
it's good...when the client insert the zip code and it's are more with the same code, will appear the lov....
the problem is when I load a client int the post-query trigger I try to take the zip code and insert him in the field...but if there are more with the same code...it will appear the lov.... I would like that the lov appear when the client insert the zip, but not when I inswert it from pl/sql (post-query trigger).... I try to set from plSQL the validate from list to false and then insert the zip code... and after reset it to true....but the problem is there too....
any suggestion?
thanks Received on Mon Oct 18 2004 - 14:09:52 CEST