Suneido

Integrated Application Platform

  • Home
  • Learning
    • Suneido Manual
    • Beginners
      • Inside Suneido
      • The Suneido Programming Language
      • The Suneido Database
      • Installing Suneido
      • Building Suneido
      • IDE Go To Tour
      • Upgrading To A New Release
    • Advanced
      • Canvas Control
      • DrawControl Part 1
      • DrawControl Part 2
      • DrawControl Part 3
      • SAX Like XML Processing
      • A Plug-In Architecture
      • A Simple Wizard Framework
      • An HTML Include Facility
      • An RSS 2 Feed Creator
      • MIME Generation
      • A New Add-on Facility
      • Workspace Improvement Hack
    • Mockito for Suneido
    • The Suneido Task Scheduler
    • Contributing To Suneido
    • Contributor Assignment of Copyright
    • Language Translation
    • Future Directions
    • Interview With Andrew Mckinlay
  • Forum
    • Announcements
    • Internals & Enhancements
    • Cookbook
    • General
  • FAQ
  • Screenshots
  • Downloads
  • Links

Newbie Question #2

Integrated Application Platform › Forums › General › Newbie Question #2

  • This topic has 1 reply, 2 voices, and was last updated 5 years, 8 months ago by amckinlay.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • May 27, 2017 at 4:02 pm #1298
    dvenus
    Participant

    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

    May 28, 2017 at 9:23 am #1305
    amckinlay
    Keymaster

    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.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Log In

Search Forums

Log In
Welcome to the new Suneido Web Site and Forum.
Register
Lost Password
users of the previous PHPBB Forum should be able to log in with their previous username and password.

Recent Topics

  • Alpha copy of gSuneido to play with
  • how to start jsuneido ?
  • Problem Starting Suneido…
  • Dialog not showing buttons
  • New link for Suneidojo

Contact Us | Legal Statement | Privacy Statement | SiteMap

Copyright © 2023 Axon® Development Corporation. All Rights Reserved. - Open Source Integrated Database and Programming Language