Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL read/write
Message
De
06/11/1996 21:23:45
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL read/write
Divers
Thread ID:
00011646
Message ID:
00011646
Vues:
77
Here's another virtual pizza for Arnon.

It is related to the tip in VFUG about having a SQL read/write. I've been using it for a while now and also shared this tip with other people who needed that as well. Thanks again Arnon.

Here's an example:
SELECT NOCLIENT AS NOCLIENT FROM CLIENT WHERE NOCLIENT<100 INTO CURSOR TEMP2
USE DBF('TEMP2') IN 0 AGAIN ALIAS TEMP
SELECT TEMP
BROWSE
Just make sure you have at least one field defined with "as" so you will avoid the filter which will not work in this case.

You may now modify the cursor.


Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform