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.
