Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views vs. SQL Pass Thru'
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00165323
Message ID:
00165533
Views:
19
>You can use SPT and use CURSORSETPROP to set the buffering and sendupdates to make it act like a Remote View where you can issue a TABLEUPDATE(). Tom DeMay is going to have an article on this in FPA next year.

I've done this before. It works pretty well and everything's in code so you don't have to deal with the limitations of the view designer, which are significant.

>
>>>
>>>Another point: Does SPT have and advantages over views when it comes to transactions/multi-user updates? I doubt it but opinions are welcome.
>>>
>>
>>I can't think of any. You can still set a view's connection for manual transactions.
>
>Usually remote views are easier for data entry since all you have to do is issue the TABLEUPDATE(). See my note above.
>DLC

Agreed. That's why I generally use views for anything that will be updated and SPT for everything else.
Previous
Reply
Map
View

Click here to load this message in the networking platform