Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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.
Richard,
Everything looks ok in your statement and yes, you can select from cursors. My first inclination would be to think that the directory Output doesn't exist from where your default is at the time you run the code. Debug just before that point and see what your default path is and that it's what you want it to be.
Renoir
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement