Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPEND FROM [SQL Cursor]
Message
From
22/12/2008 09:59:07
 
 
To
22/12/2008 09:51:08
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01369081
Message ID:
01369133
Views:
29
>>Are you absolutely, 110% sure that you really use the NOFILTER clause?
>
>Yes. Here is my exact code:
> SELECT;
> iEmp,;
> MAX(UPPER(cNameLast + cNameFrst + cNameMI));
> AS cNameSort,;
> MAX(cNameLast) AS cNameLast,;
> MAX(cNameFrst) AS cNameFrst,;
> MAX(cNameMI) AS cNameMI,;
> SUM(yDeduct) AS yDeduct,;
> MAX("1") AS cAggType;
> FROM CuDed1EmpGLA;
> GROUP BY 1;
> INTO CURSOR CuDed1Emp NOFILTER READWRITE
>
>Best regards, Chaim

I am cluesless. I do the same all the time, but I always start with a blank cursor. What happens if you do the same?
Create cursor myCursor1 .........
Select ... into cursor temp1 readwrite && Your first select statement
Select myCursor1
Append from dbf('temp1')
Select ... into cursor temp1 readwrite && Your second select statement
Select myCursor1
Append from dbf('temp1')
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform