Skip to Content
0
Former Member
Apr 08, 2013 at 07:21 AM

Problem in Table Maintainence generator event

30 Views

Dear Gurus,

We have a table wherein there is a key field which will be generated internally by incrementing the previous highest value in table(ie, say 10 is my last number in table, the number will be automatically incremented to 11).

The problem here is, whenever we enter a single record as a new entry, system generates next number (ie, say 10 is my last number in table, the number will be automatically incremented to 11).

But incase we copy paste multiple entries, system throws error saying duplicate records cannot be proccessed.(ie, these multiple records entered has not been saved into the database, hence the system increments the same number (ie, 10 to 11 say) again and again.

Is there any EVENT in table maintainence generator for this scenario? Is there a EVENT for ENTER in TMG?

How can we get rid of this problem once for all.

Waiting for your replies.

With Regards,

Jagan