Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Cursor not being created
Versions des environnements
Hi:
I have the following problem. I have an SQL statement something like this:
cSelectStat = "select "+lcfields +;
" FROM a "+;
" left Join b On b.fieldpk = a.fieldfk "+;
" left Join c On c.fieldpk = b.fieldpk "+;
" left Join d On d.fieldpk = c.fieldpk "+;
" left Join e On e.fieldpk = d.fieldpk "+;
" left Join f On f.fieldid = e.fieldpk "+;
&cSelectStat into cursor curtemp readwrite
select curtemp
And it returns me an error like this after executing the last statement: File ‘curtemp.dbf’ does not exist.
Is this a setting in FoxPro that I’m missing or something? Are there any instances it will fail to create a cursor? From what I understand that even the records set return no records that cursor still exist.
Please advise.
Thanks,
Jan
Suivant
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