How the F5 key works in Order Entry

[mlbechard]

I will have to create an INSERT SQL transaction to create a new order in the oeordhdr_sql/oeordlin_sql tables directly. In Macola, to have a new order number auto-generated, we have to press the F5 key. I would like to know how it works internaly because I will need to generate a new order number before executing the INSERT SQL statement.

I can't get the highest order number from oeordhdr_sql or oehdrhst_sql and add 1 to it. This won't work because in reality, 2 persons could press F5 at the same time in their own Order Entry screen on their computer and they won't have the same number.

Is it store in a particular table?

Can someone help me on this?

Thanks for your help

 

[dgillz]

The is stored in the oectlfil_sql table.

I really, really wish you would tell us what you are trying to do.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html