Strange query result

[rogertrigell]

Running a query on a single table in VFP 7 misses a record meeting conditions but adding a browse on the queried table prior to the query and the missing record is found.

Explanation please!

 

[rogertrigell]

Tried re-indexing the file but this made no difference.

 

[crewchiefpro6]

When you reindexed the file did you just issue a REINDEX command or did you DELETE TAG ALL then Index on <<yourfield>> tag <<yourtagname>> additive

Sounds like an index problem to me also.



Don Higgins

http://www.crewchiefpro.com

 

[Mike Lewis]

Roger,

Is the table in question row-buffered? Are there any outstanding records in the buffer?

If so, that would explain the behaviour you are seeing. The query doesn't see the buffered records, but the browse will move the record pointer, thus causing the updates to be committed.

The solution in that case would be to do a TABLEUPDATE() or TABLEREVERT() before you do the query.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[rogertrigell]

Thanks Mike

The Tableupdate solved the problem.

Roger