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.
