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?

  • Richard Soeteman 4045 posts 12898 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.

  • 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?

  • Richard Soeteman 4045 posts 12898 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.

Please Sign in or register to post replies

Write your reply to:

Draft