-----Original Message----- From: Claudine Robbins Sent: Wednesday, August 11, 2010 12:23 PM To: Adriana Montano Subject: Question to RBASE List
Can you please forward this message to the list? Apparently, it no longer works with this email address: Good morning list, I have a problem with generating unique primary keys. The first routine, found in an RBTI sample, would pick the next value in the PK column of the table, then would check and make sure the key was not in use before saving the record or would pick the last + 1 value. I had many header/detail records end up mixed so I switched to the following routine: Put all the numbers available in a single table with a Y/N flag and have each user pick the next number from the table by locking the table, grabbing the number, changing the flag to Y, and unlocking the table. All data entry is done through temporary header and detail tables so it baffles me that I have crossovers and someone's detail records still end up tacked unto someone else's records. Obviously, the unique header number can be picked by two users... Any ideas to fix this will be greatly appreciated. TIA, Claudine Robbins --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
