Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem with writeable cursors
Dear All,
I found the following syntax to make a cursor writeable:
USE DBF("cMyCursor") IN 0 AGAIN ALIAS cAnotherCursor
But if I use the following :
select anyfield from MyTable into cursor cMyCursor
then DBF() gives back the path of the original table, but I don't want to write into the original table.
After some reasonong, I have tried using the following:
select anyfield from MyTable into cursor cMyCursor nofilter
then DBF() gives a really temporary filepath.
According to the VFP documentation, neither of the previous syntax creates phisical files. But practically, the second syntax still produces one.
Is it sure, that the second syntax always produces a temporary file, and thus, is safe to write into the cursor after making it writeable?
P.S.: I know, that
select anyfield, .t. from MyTable into cursor cMyCursor
does the job, but I would like to understand the theoretical background.
TIA
bb
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