How to create auto-generate for ID? For example, the ID for new transaction page automatic generated.

Questions by orkedII

Showing Answers 1 - 1 of 1 Answers


  • May 23rd, 2011

You can use 'NEXT' for auto generating the IDs. Otherwise you can write your own coding as follows.

SQLEXEC("get the max value from the table",&count)


SQLEXEC("inserts the new count value to the database");

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions