haha, I think I just remove that USE command!!! Thanks all the same ;-)
Have a great day.:smileyhappy:
Alice
It's likely that your statement is not returning any results and therefore the recordset is closed.
You should be safe to remove oRecSet.MoveFirst as the recordset will already be at the first record when it's first returned.
You'll then want to check the .EOF (end of file) while iterating the returned recordset.
Something like so:
While Not oRecSet.EOF 'do stuff with record oRecSet.MoveNext() Wend
Actually I copied the query to run in the sql server, it returns results.
The problem is USE TableA, if I prefix the database to the table , it's working fine. eg. TableA.dbo.location.
Any idea on this issue?
Thanks
:robotindifferent:
haha, I think I just remove that USE command!!! Thanks all the same ;-)
Have a great day.:smileyhappy:
Alice
