Skip to main content

OpenDB and SQL Tables with only a Primary Key column

  • November 18, 2021
  • 2 replies
  • 0 views
Brian Cram
Forum|alt.badge.img+3
We found an issue in OpenDB in which an attempt to manipulate an SQL table that only has a primary key and no additional columns fails. A known-issues post will be made in the Rocket Community OpenDB Downloads section as follows:

Known Issues:
OpenDB cannot be used against an SQL table that contains only a primary key and no other columns as this causes an error in the WHERE clause of the SELECT statement.

This has only happened to one customer who worked around the issue by adding a dummy column to the table. I've never seen this before and seriously doubt I ever will again.

One must ask one's self: "Why the heck would one have an SQL table with a primary key and no data?" If anyone has a good answer for that one, please post a reply herein.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------

    2 replies

    Chris Wolcz
    Forum|alt.badge.img
    • Chris Wolcz
    • Participating Frequently
    • November 19, 2021
    We found an issue in OpenDB in which an attempt to manipulate an SQL table that only has a primary key and no additional columns fails. A known-issues post will be made in the Rocket Community OpenDB Downloads section as follows:

    Known Issues:
    OpenDB cannot be used against an SQL table that contains only a primary key and no other columns as this causes an error in the WHERE clause of the SELECT statement.

    This has only happened to one customer who worked around the issue by adding a dummy column to the table. I've never seen this before and seriously doubt I ever will again.

    One must ask one's self: "Why the heck would one have an SQL table with a primary key and no data?" If anyone has a good answer for that one, please post a reply herein.

    ------------------------------
    Brian S. Cram
    Principal Technical Support Engineer
    Rocket Software
    ------------------------------
    Someone could use it to validate user input. You may expect that it would come with a description column but maybe it was not necessary.

    ------------------------------
    Chris Wolcz
    Senior Software Developer
    Execontrol Global Solutions
    Clifton Park NY US
    ------------------------------
    W
    • William Moffa
    • New Participant
    • November 24, 2021
    Someone could use it to validate user input. You may expect that it would come with a description column but maybe it was not necessary.

    ------------------------------
    Chris Wolcz
    Senior Software Developer
    Execontrol Global Solutions
    Clifton Park NY US
    ------------------------------
    One reason might be that they need to convert a pick file that has only  controlling/dependant multivalue attributes that they want to spin off into separate sql secondary tables - they don't need the parent, just  the kids

    ------------------------------
    William Moffa
    Software Developer
    Self Registered
    Old Bridge NJ US
    ------------------------------
    Steve Vanarsdale

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement