A database record pointer
Posted on 2011-10-31
I haven't seen anything that's the equivalent of a file pointer for databases and I seem to need such a thing.
I will be selling barcode numbers, which have been purchased in bulk and will now be sold off one at a time. My thought was to fill a "barcode table" with, say, 10,000 new bar codes. Other columns in the table would hold the buyer's information, to be filled in when the barcode was sold. So after PayPal approved payment, the next unsold barcode would be pulled from the barcode table and issued to the buyer, and the buyer's information would be filled into the information fields of that barcode's record in the table. A table pointer would then be incremented to point to the next unsold barcode in the table. So for each sale I need something that gets the row in the barcode table of the next unsold bar code, i.e., reads the table pointer. Is there an accepted way of doing this?
Thanks for any ideas.