Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
APPEND FROM [SQL Cursor]
Message
De
22/12/2008 09:59:07
 
 
À
22/12/2008 09:51:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01369081
Message ID:
01369133
Vues:
33
>>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')
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform