Copied to clipboard

Flag this post as spam?

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

  • Andrew McDonald 8 posts 31 karma points
    Jun 11, 2017 @ 13:42
    Andrew McDonald

    Throws Invalid column name 'ID' error if the id column not being named Id

    I'm trying to use UI-O-Matic with an external Sql Server database

    Unfortunately the primary key for the table I'm accessing is named something other than 'Id' and thus throws an error

    I can't change the name in the table as the people who use the database have lots of code depending on me not changing the db structure

    I'm on version 2.0.3 of UI-O-Matic, so am stumped what's causing this ????

    Anyone else come across this and fixed it ?????

  • Andrew McDonald 8 posts 31 karma points
    Jun 11, 2017 @ 13:55
    Andrew McDonald

    Fixed it myself

    If anyone start working external databases add the following into the code using UI-O-Matic


    • Just change 'PrimaryKeyName' to your actual PrimaryKeyName and bingo it works

    Hope this stops someone else scratching their head ;)

Please Sign in or register to post replies

Write your reply to: