Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL SELECT on Cursors
Message
De
10/09/2001 08:43:33
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
10/09/2001 08:08:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00554562
Message ID:
00554577
Vues:
13
I have not had any problem SELECTing data from a CURSOR into another CURSOR or table until I tried
INTO DBF SomeFolderWhichDoesntExist\MyTable
Also, I notice that you've used "/" instead of "\" to separate your directory and table name. I tried both and both worked but they may not with all systems.

>Hi guys,
>Can you use SELECT SQL statement on cursors? I have a cursor called tempcur and I had this satement :
>
SELECT tempcur.clerk, tempcur.rates;
    FROM tempcur;
    GROUP BY clerk;
    ORDER BY clerk;
    INTO DBF output/entries
>
>
>I get an error message "Invalid path or file name" when I run the form. What's wron with this? I would be glad of any help from you guys.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform