D3 and mvBase

 View Only

  • 1.  OpenDB and SQL Tables with only a Primary Key column

    ROCKETEER
    Posted 11-18-2021 19:25
    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.  RE: OpenDB and SQL Tables with only a Primary Key column

    PARTNER
    Posted 11-19-2021 08:16
    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
    ------------------------------

    Original Message


  • 3.  RE: OpenDB and SQL Tables with only a Primary Key column

    Posted 11-24-2021 02:36
    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
    ------------------------------

    Original Message