Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL to VFP cursors, as opposed to Remote Views
Message
De
24/06/2007 17:21:31
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
23/06/2007 18:50:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01235175
Message ID:
01235263
Vues:
18
>>SPT cursors have Record buffering enabled. You can ussue TABLEUPDATE() after APPEND BLANK.
>>
>>APPEND BLANK
>>TABLEUPDATE()
>>SELECT * FROM ...
>>
>>
>>>I can SELECT from one, except if I have an empty set, do an APPEND BLANK and then try to Select. I'll try the new setting to see if this does it.
>
>Weird... I never think of it as an actual cursor, because I don't (can't?) use it to update. You're right, a TABLEUPDATE() does it. Doesn't seem like I can set it to buffering = 1, even if I wanted to (i get an error telling me it HAS to be Optimistic).
>
>Anyway, this seems to be the best workaround. Thanks again Sergey!

No it is not. No need to tableupdate to select from. Tableupdate would send the updates with an updatable SPT.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform