Thank you Albert & Bruce I appreciate your assistance. Gary > On May 21, 2016, at 11:01 PM, Albert <[email protected]> wrote: > > I'm with Bruce. > ContactID INTEGER NOT NULL PRIMARY KEY > > SET VAR vNext INTEGER > SELECT (MAX(ContactID +1)) INTO vNext FROM Contacts > AUTONUM ContactID in Contacts USING .vNext,1 > > The above is my standard system to restarting the autonumbers when an index > fouls up -- an increasingly rare situation, by the way. > > I actually have a stored procedure that will look for autonumbered columns > and reset the numbers as shown above. > > Albert > >> On 2016-05-21 11:05 PM, Bruce Chitiea wrote: >> Gary: >> >> Happy to help. >> >> I highly recommend an R:BASE web resource: >> >> www.rsyntax.com/rbgX >> >> ... for rapid reference on most things R:BASE. The section on AUTONUM does >> say: >> >> "The following types of columns can be autonumbered: ... Columns with >> DOUBLE, INTEGER, NUMERIC, REAL, or TEXT data types." >> >> ... and shows the syntax for concatenating text and sequential numbering: >> >> [MX]9999 or [xx]0000 >> >> But I leave it to others to extol the virtue of TEXT autonumbers, for I'm >> exclusively an INTEGER-autonumber guy. >> >> My philosophy is this: an autonumber has no repeat no meaning beyond being a >> unique "serial number" for a row of data. No meaning (such as PO, SO, INV, >> SN etc.) is embedded or implied by the number. It is a number, nothing more, >> existing solely to allow a PK to be an effective and unambiguous "anchor" >> for an FK. >> >> Because rows can be deleted, I do not assume perfect 1+1+1 sequence to the >> PK values in the rows I'm running through a loop, which would be wrongly >> (and perhaps fatally) assigning "sequentiality" as a meaning. >> >> There's a cheap and cheerful method for "walking" a list of non-sequential >> PK values. A subject for another day. >> >> Yours, >> >> Bruce Chitiea >> SafeSectors, Inc. >> 909.238.9012 Mobile >> >> >> >> >> >> ------ Original Message ------ >> Sent: 5/21/2016 9:39:52 PM >> Subject: Re: Re[2]: [RBASE-L] - Autonumbering Not Working >> From: "Gary Randall" <[email protected]> >> To: [email protected] >> Cc: >> >> Bruce, >> I had the data type as text I changed it to integer and now it works >> correctly! >> >> I thought the data type could be text maybe it's changed? >> >> Thank you for helping me. >> Gary >> >> >> On May 21, 2016, at 9:24 PM, Bruce Chitiea <[email protected]> wrote: >> >>> Gary: >>> >>> Nor have I. I take from your response that the PK has not yet been applied. >>> >>> More clarity needed. At the R>, if you LIST <TableNameHere>, do you get: >>> >>> 1 WannaBePKColumn Type : INTEGER NOT NULL AUTONUMBER >>> >>> >>> Bruce >>> >>> ------ Original Message ------ >>> Sent: 5/21/2016 8:44:13 PM >>> Subject: RE: [RBASE-L] - Autonumbering Not Working >>> From: "Gary Randall" <[email protected]> >>> To: [email protected] >>> Cc: >>> >>> I am using RBase X, I have a very basic database design at this point. I >>> created an autonumbering column using the Data Designer with the intention >>> of using this column as a Primary Key. I tried entering some test data and >>> noticed the autonumbering column was not being inserted when the row is >>> added. If I had the PK assigned, I would get the error msg telling me that >>> a Null value was not allowed. If the PK was removed the row would be loaded >>> but the autonumber column would be NULL. I’ve never seen this before. >>> >>> >>> >>> Thank you >>> >>> Gary Randall >>> >>> >>> >>> From: [email protected] [mailto:[email protected]] On Behalf >>> Of Bruce Chitiea >>> Sent: Saturday, May 21, 2016 8:32 PM >>> To: [email protected] >>> Subject: Re: [RBASE-L] - Autonumbering Not Working >>> >>> >>> >>> Gary: >>> >>> >>> >>> Would you kindly explain what "not working" means? Several questions: >>> >>> >>> >>> - Which version of R:BASE? >>> >>> - Are you setting the autonumber within the data designer? With the AUTONUM >>> command in code? >>> >>> - Problem manifests while INSERTing in code or running against an existing >>> table in EDIT mode? >>> >>> >>> >>> Thanks >>> >>> >>> >>> Bruce Chitiea >>> >>> SafeSectors, Inc. >>> >>> 909.238.9012 Mobile >>> >>> >>> >>> ------ Original Message ------ >>> >>> Sent: 5/21/2016 8:23:04 PM >>> >>> Subject: [RBASE-L] - Autonumbering Not Working >>> >>> From: "Gary Randall" <[email protected]> >>> >>> To: [email protected] >>> >>> Cc: >>> >>> >>> >>> Hello All, >>> >>> I am creating a new database and during testing I found the column >>> autonumbering function is not working. Is there a setting I need to change >>> to get RBase to auto number when a new row is added? >>> >>> Thank you >>> >>> Gary Randall >>> >>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "RBASE-L" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "RBASE-L" group. >>> To unsubscribe from this group and stop receiving emails >>> from it, send an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "RBASE-L" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "RBASE-L" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >> -- >> You received this message because you are subscribed to the Google Groups >> "RBASE-L" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> -- >> You received this message because you are subscribed to the Google Groups >> "RBASE-L" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout.
-- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
