Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TimeStamp Reprise
Message
From
14/12/1999 12:35:13
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00302651
Message ID:
00303443
Views:
19
>Yep, I bet this it is. When working with Remote Views, VFP must do the work to render something like this in the Where Clause...
>
>Where timetamp = @timestamp...

Yes - it does - I just can't figure out why it doesn't do the same for SPT cursors


>Because you are using an update proc, you will need to do this manually. It is no big deal. Just pass the timestamp to your update proc. Don't however, attempt to update the timestamp field itself. SQL will do this for you. Rather, use it in the where clause of your update proc:

But I'm not using an Update proc - I just call TableUpdate() in both cases - it is VFP that is evidently making the decision to use the SQL Server Stored procedure sp_executesql on the cursor and to issue a straight UPDATE ... on the view

Thanks ... I'm just about to call it an "undocumented feature" and go back to a wheretype of 3 ... sigh ...

Ken
Ken B. Matson
GCom2 Solutions
Previous
Reply
Map
View

Click here to load this message in the networking platform