Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using cross tab queries
Message
De
11/08/1999 07:52:03
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Using cross tab queries
Divers
Thread ID:
00252411
Message ID:
00252411
Vues:
49
I am trying to use a cross tab query in a report. I have the following code in a method on a form.

SELECT bt_bankacc,yearmo,bt_amt1 ;
FROM cBanks;
GROUP BY bt_bankacc, yearmo ;
ORDER BY bt_bankacc, yearmo ;
INTO CURSOR SYS(2015)
DO (_GENXTAB) WITH 'xBanktemp'

This works fine in development mode but when I compile and run the executable, I get 'File does not exist' message at the line staerting with DO. How can I use a cross tab query for a report?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform