In a .qvw I created a QV table inside a condition statement.
Opening binary the above one in another .qvw file, I need to check if the QV table has been created.
Is there a way to check if a QV table exists before calling a drop table statement ?
Thanks in advance.
There is a system field called $Table which stores all actually loaded tables, so checking this field (with peek(), for exmple) for that table value should work for you.
Hope that helps.
Other way is to set the errormode variable appropriately so in case of error, it skips it and not terminate. Something like:
Set ErrorMode = 0; //Set it to skip error
DROP Table xyz;
Set ErrorMode = 1; //Set it back to standard
Here you are another one, maybe more practical, using system function TableName()
If (len(TableName('YourTable')) > 0) Then Drop Table YourTable; End If