topic Re: database updates... in Application Development and Automation Discussions

database updates...

Former Member — Wed, 06 Aug 2008 17:52:32 GMT

hi,

A quick question on the best way to handle the data input in the table control on screen.

assume i have a table control in which user enters 5 records and chooses to save. these 5 records are INSERTED in the custom table.

next time he chooses to delete 2 of them modify 2 of them, leave one unchanged and add 2 more.

so whats the best way to update the custom table based on these changes ??

Simply delete the earlier 5 from custom table and then based on what is available in the TC , insert into the table ??

update the table with the 2 that were modified,

insert the new ones

delete the ones that were removed from the TC

any suggestions ??

thks

Re: database updates...

Former Member — Wed, 06 Aug 2008 18:03:22 GMT

>update the table with the 2 that were modified,

>insert the new ones

>delete the ones that were removed from the TC

this is the approach.

standard transactions also do the same thing.

Re: database updates...

Former Member — Wed, 06 Aug 2008 19:12:29 GMT

Hi,

Use Delete statement to delete the records from custom table.

Use modify statement to update the rest. Modify statement will update all the records in custom table by comparing the key fileds. If the entry is already existing it will update fields other then key fields, which is equivalent to update statement.

If the key fields are not present, it will create a new entry in the custom table.

To reduce the no:of statements in the program u can go with

Modify and delete, which will suffice your requirement.

- Krishnan