Auto-Generate

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

Questions by orkedII

Showing Answers 1 - 3 of 3 Answers

Terrastar

  • 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)

&count=&count+1;

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