Skip to main content
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
------------------------------
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
------------------------------
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
------------------------------
Terms & ConditionsAccessibility statement