DB Tools List Tables does not return current information

[CherieM]

I am using the Database Connectivity Toolkit with Labview 7.1 and Microsoft SQL Server.  When I use "DB Tools List Tables.vi" after deleting a table, the table is still listed.  Is there a way to get the table list to refresh or return the latest data?

Thanks,

Cherie

[Travis_M.]

Hello,

There is a known issue with the VI (read about it here), but I do not believe that this is what is causing your problem.  How is it that you are deleting the table from the database?  If possible, you could post a screen-shot (press <ctrl>+<alt>+<Print Screen> and paste in a picture editor to save the picture?  It is possible that something else might be to blame for the return of a table.

Regards,

[CherieM]

Thanks Travis.  I just read about the known issue and I think that is exactly my problem.  I was using Drop Table to delete all the tables and then List Tables to test for the existance of each table.  Because the list still contained all the table names, the test was succeeding when it should have failed.  I have since come up with another work-around to test for the existance of each table.

Thanks for your help,

Cherie

[Travis_M.]

Hello,

Glad to hear its running!  This problem should be fixed in the next version of LabVIEW.

Thanks for posting.

Regards,