We are accessing progress 9.1d through php and Merant 3.6 odbc on windows xp 32bit. We are trying to get the next-value sequence. Each time we execute something like...
...the nextval get incremented by the total of all records. Like it is executing nextval for each record which in our case is rougly 300,000 times. Are we doing something wrong with the select statement?
Code:
SELECT pub.orderheadseq.currval FROM PUB.orderhead
...the nextval get incremented by the total of all records. Like it is executing nextval for each record which in our case is rougly 300,000 times. Are we doing something wrong with the select statement?