Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting view: blocking the system
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Deleting view: blocking the system
Miscellaneous
Thread ID:
00344082
Message ID:
00344082
Views:
59
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
Map
View

Click here to load this message in the networking platform