Navigating on records . [message #84728] |
Wed, 21 April 2004 05:52 |
NooBEmu
Messages: 11 Registered: March 2004
|
Junior Member |
|
|
I there..
the problem is the following:
Ive got some table with the fields code, code2, description
when i insert code2 on the form and press Return, i want to serach on the other records is there is any record that has a equal code2 and if it is true i want to delete the original and copy code and description to this new record..
its possible to do that??
|
|
|
Re: Navigating on records . [message #84758 is a reply to message #84728] |
Thu, 22 April 2004 06:19 |
Jeslie
Messages: 26 Registered: April 2003
|
Junior Member |
|
|
Hi
Eventhough I don't understand your need to delete the existing record instead of updating it.....
It is Possible and u need to do this in the PRE-INSERT Trigger of the Particular Block.
1. Check whether record is available using a Selcect count(*) into .....
2. If Yes, Select code,description into some variables.
3. Write an Insert Statement
Insert into .... values (variable_code,:block.code2,variable_Description)
Try this and Let me know
Thanks
|
|
|
Re: Navigating on records . [message #84786 is a reply to message #84758] |
Mon, 26 April 2004 09:52 |
NooBEmu
Messages: 11 Registered: March 2004
|
Junior Member |
|
|
the problem is that my block its not a database block..
i populate items with a cursor..
with the records populated, i want to search and navigate on these items and delete de ones that are equal to the new code i insert..
its resolved now.. :)
Thanks..
|
|
|