General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Deleting view: blocking the system
Hi,
I work with remote views and SQL Server.
Im my reconstruction routine, i delete the remote view, delete the table at SQL Server, create the same table (with new fields, etc), and... need to create the remote view for that new table.
The problem is VFP blocks the system when i'm doing the CREATE SQL VIEW ... REMOTE CONNNECTION ...
I've read VFP's help; here is one thing i've found at DELETE VIEW's remarks: If a SQL view is opened and then deleted, the cursors containing the SQL view results are not closed.
I don't know if this is the problem. Any ideias???
Thanks,
Ricardo
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only