Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to: Create an temp update cursor (V6s5)
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00812227
Message ID:
00812658
Views:
12
>In VFP7/8 you can just add READWRITE clause to the query. In VFP6 and earlier
SELECT iItemID, iSecUnitID, SUM(yQty - yClrQty) AS yQty, iSID ;
>  FROM TempLKuInqQuotUnClr ;
>  WHERE (yQty - yClrQty) # 0 ;
>  GROUP BY iItemID, iSecUnitID, iSID ;
>  INTO CURSOR temp NOFILTER
>USE ( DBF("temp" ) AGAIN IN 0 ALIAS LKuInqQuotUnClrList
>USE IN temp
>
I use 6. Thanks Sergey.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform