- This topic has 1 reply, 2 voices, and was last updated 6 years ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.
Integrated Application Platform
Integrated Application Platform › Forums › General › Newbie Question #2
Hi!
What is the best way to import into a table so that the first column is a auto-incremented number? I have looked at seq, sequence, and triggers… This was mentioned in some old, old forum posts (mingodad?) as something you might include in Suneido. I would also want this column to be the key.
Thanks,
Dave
Suneido doesn’t have auto incremented numeric keys.
We use Timestamp() to get automatic unique keys. Our usual approach is to use a rule to set the timestamp.
Timestamps have the side benefit of giving you the creation date/time of each record.
You can also have an _TS field that is automatically set to the last modified date/time.