>I've tried the trick to have a writable cursor:
>
>SELECT ... FROM MESSAGE WHERE ...condition INTO CURSOR TEMP1
>if used('temp2')
> select temp2
> use in
>endif
>use dbf("temp1") in 0 again alias temp2
>
>but then, temp2 is a copy of MESSAGE table instead of TEMP1 ???
>
>What am I doing wrong?
>Claude
Use the NOFILTER clause with your select statement. For speed purposes, when it can, VFP dresses up a copy of the base table with a filter to give you your result set. The NOFILTER clause ensures that the result set has a real disk presence, instead of being the base table in disguise.Erik Moore
Clientelligence