Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Hugo Santos 4 posts 44 karma points
    Dec 09, 2019 @ 13:20
    Hugo Santos
    0

    Can I have a Auto Incremental ID value on my imported entries?

    Basically I don't want to define an imported value as ID/PrimaryKey.

    I'd like to have some kind of auto incremental value (1, 2, 3, 4, etc) on my ID column and then use it as the primary key.

    Is this even possible?

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Dec 09, 2019 @ 13:24
    Richard Soeteman
    0

    HI Hugo,

    Yes just add those in a column. As long as they are unique it will always work.

    Copy Link
  • Hugo Santos 4 posts 44 karma points
    Dec 09, 2019 @ 13:34
    Hugo Santos
    0

    Thanks Richard,

    But I don't think I was clear enough, sorry,

    I don't have any column with those values.

    What I'd like to have is an auto incremented generated value such as the IDENTITY columns on SQL Server.

    What do you think?

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Dec 09, 2019 @ 13:38
    Richard Soeteman
    100

    That's not possible at the moment. And will not work when you want to update data in a later stage since the key can be anything in that case.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft