topic Re: Insert in Application Development and Automation Discussions

Insert

Former Member — Wed, 06 Feb 2008 13:26:45 GMT

hi all

In my Function module,

i m testing my FM ,In a perform i m doing insertion in a database table

now the insertion goes fine but when i run the FM with the same parameters it creates a duplicate entry

beacuse of this insertion

any idea how i can handle this?

Former Member — Wed, 06 Feb 2008 13:28:39 GMT

Hi,

Instead of INSERT use MODIFY statement.

If a record with the same key already exists, then it will modify that record in the DB table, else it will insert a new record.

Cheers,

Aditya

Edited by: Aditya Laud on Feb 6, 2008 8:29 AM

Former Member — Wed, 06 Feb 2008 13:29:18 GMT

before inserting into the table in the FM write a select to

check if the entry already exists .. if no then only insert into

the table ...

Former Member — Wed, 06 Feb 2008 13:29:37 GMT

Can You paste Your FM code?

Former Member — Wed, 06 Feb 2008 13:30:07 GMT

May be in u r database tabel u are not set the Key fieldds.

other possible way is check the insert command containes the statement ALLOW DUPLICATES.

Former Member — Wed, 06 Feb 2008 14:24:31 GMT

hello gurnam

i guess ur idea can help me

but wht kinda select?