Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Not the 'copy file' command, just the 'copy'. See my previous post. Using the 'with cdx' clause in a copy file statement does not produce an error, but there is no cdx copied. If the cdx files are there in the directory already (say from your previous code), then opening the table will use the existing cdx, but without issuing the proper copy command 'with cdx', it won't necessarily be the cdx you really want.
When you then reindex, yes, everything will be ok.
Alan
>That didn't work. This time I did not copy the cdx files separately, ans issued the COPY file command with cdx.
>
>After the files are copied, I just try running queries in the command window. When it doesn't work, I open the table exclusively and issue the 'REINDEX' command. Then everything seems to be fine.
>
>Ria
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