Discussions

Expand all | Collapse all

Can a Quickbase Table be Dropped through QUNECT?

  • 1.  Can a Quickbase Table be Dropped through QUNECT?

     
    Posted 06-19-2017 12:03
    We have a linked server using QUNECT on SQL Server. We are using the QB tables in various stored procedures where the table names are assigned to variables. I know we can delete data from the QB tables, which kind've scares me because if we accidentally use the wrong variable in a delete statement, one that is assigned to a Quickbase table, all our data will be deleted.

    So, my thought is to use a Drop statement instead where the table will be deleted all together because I'm assuming that a drop statement will not work on a QB table through QUNECT, so it will just throw us an error in the event we make a mistake. Am I assuming correctly? I just want to make sure before I modify the stored procedures.


  • 2.  RE: Can a Quickbase Table be Dropped through QUNECT?

    Posted 06-19-2017 16:00
    I believe that drop is a supported syntax with Qunect and will in fact drop your table.  I would test it. . . . . 


  • 3.  RE: Can a Quickbase Table be Dropped through QUNECT?

     
    Posted 06-19-2017 17:23
    Really? I was hoping that it would not. All it takes is referencing the wrong variable and that can wipe everything out.


  • 4.  RE: Can a Quickbase Table be Dropped through QUNECT?

    Posted 06-19-2017 18:06
    The other thing you can probably look at is the user permissions of the role that you are using to execute QUNECT with.  My guess is you are probably using administrators credentials.  You should be able to use credentials from a quickbase user that only allows adding / modifying records etc.  Again, I would test.