Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transactions & Remote Views w/o Shared Connection
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01191670
Message ID:
01192134
Views:
26
>Another quick question, with respect to locking in SQL Server.
>
>The SET REPROCESS command determines how long to wait for a lock in VFP. Does this same command effect how long to wait for a lock when using a remote view against a SQL Server backend?

What lock?
You can't LOCK the record in SQL Server. RVs create only LOCAL representation of the recordset you want from SQL Server. Every usir works with His/Her cursor and nobody knows what records other users handle.
That means SET REPROCESS wouldn't work on RV.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform