Hopefully, this will be a very quick one.
We have a query built in VB. It reads something like this (not the actual code :
"Select aName from ThisTable where aName = 'Fred'"
When run in Query Analyzer, it returns one record (as expected). When run in code, if returns no records (EOF and BOF are true).
When we run a similar query ("....where aName = 'Jonesy'"), it correctly returns the one record in code and in Query Analyzer. Note that this query is built in the same area as the original (except for the change of the value).
Any thoughts????
Allan