Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote Views vs. SQL Pass Thru'
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00165323
Message ID:
00165533
Vues:
11
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform