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 program lock the record and increment the counter.

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



Regards,
Peter Bateman

_________________________________________________________________
Add photos to your messages with MSN Premium. Get 2 months FREE*  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines