posted 16 years ago
Sure,
My client application has been written to work with a number of different databases. As such I have avoided the use of proprietary methods like sequences or stored procedures to generate unique numbers. My specific application only needs to generate a pallet number and it will suffice for each workstation to have it's own range. I intend to have a table containing client worktation names and when a number is required the applciation will read/increment and store the next number against the record correspodning to its client name. This will avoid and possibility however slight that two workstations will get the same number.
Thanks
Dave