relational generators -- Oracle sequences

[Peter Bateman]

Brian:

If I had to move this code to Oracle. I would try to create an Oracle 
sequence
for each unique value of item.

You access a sequence in a manner similiar to accessing a table. If 
PowerHouse
gives you trouble you could put the access in an Oracle  view.

This saves having to programming lock the record and incrementing the 
counter.

You should test that the counter is not nearing the maximum value.



Regards,
Peter Bateman

_________________________________________________________________
Free yourself from those irritating pop-up ads with MSn Premium. Get 2months 
FREE*  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines