Gregory,
have seen all those CDX() - DBF() problems.
try
USE ..
INDEX ... TAG T1
REQUERY([...])
INDEX ... TAG T1
?dbf()
?cdx(1)
?cdx(2)
Or use debugger - its easyer to read. <s>
Let's say I run into erratic problems
I do testing on command window no matter if in VFP7.0 SP1 or VFP6.0 SP5.
Doing code like you suggest to
USE ..
INDEX ... TAG T1
do this do that
REQUERY([...])
DELETE TAG ALL
INDEX ... TAG T1
INDEX ... TAG T2
BEGIN TRANSACTION
may run if. May not. I change a little bit
USE ..
INDEX ... TAG T1
INDEX ... TAG T2
do this do that
REQUERY([...])
DELETE TAG ALL
INDEX ... TAG T1
INDEX ... TAG T2
INDEX ... TAG T3
BEGIN TRANSACTION
it fails.
If I immediate repeate
CLEAR ALL
...
SUCCESS!
Now I clean up each and everything (QUIT?)
...
success
Now I start playing in number of tags.
Sometimes it fails, but I can never repeat error.
Except one:
Allways in SortIt <~@#€#!>
I can't close my view's ...
It's like running in circles.
Could be some cache?
Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]