Gary, You can use text for auto-number columns, you just have to use the proper syntax. In my application I have several tables that use a text format for the auto number using a format like this: [16-]00000 This will generated a number like 16-00001 and so on. The number format is reset the first time any user accessed the system for the first time very year to reflect the current year. This approach makes it very easy to do selections by year and when looking at a particular record, you immediately known in which year it was created. Of course the system has utilities to reset the format to previous years if necessary and it will then reset back to the current year. FWIW, I understand that once upon a time there might have been issues with the auto columns properly incrementing or getting corrupted, but I have not really run into one in a long, long time…at least 20 years. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Gary Randall Sent: Saturday, May 21, 2016 11:40 PM To: [email protected] Subject: Re: Re[2]: [RBASE-L] - Autonumbering Not Working 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" < <mailto:[email protected]> [email protected]> To: <mailto:[email protected]> [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 <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> 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 <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> 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.
