Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Writeable Cursors?
Message
 
 
À
16/12/1997 07:45:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00066144
Message ID:
00066336
Vues:
33
>sele my_cursor
>use(dbf([my_cursor]) in 0 again alias RWmy_cursor
>
>Probably, updatable view more than reliable way to do what you want.
>
>>How do you make a SQL Cursor writeable ?
>>Select * from my_file into cursor my_cursor

Hi Vladimir,
This probably belongs in another thread, but a cursor created via SQL SELECT would seem to have several advantages over a view:
1.) It does not have to be stored in a DBC
2.) It is dynamic, changing the select statement changes the generated cursor. More flexible than updatable view
The cursor created via use again is bufferable, so the only issue appears to be updating a target table(s).

What's your take on this?

Ned
Ned

Reality is.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform