Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL read/write
Message
From
06/11/1996 21:23:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL read/write
Miscellaneous
Thread ID:
00011646
Message ID:
00011646
Views:
69
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
Next
Reply
Map
View

Click here to load this message in the networking platform