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 4054 posts 12927 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 4054 posts 12927 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.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies