I'm running a straight forward SelectCmd in a cursoradapter:
SELECT [field list]
FROM [Remote table]
WHERE [filter expr]
It runs, returns 1 record, but then still shows the shared connection as busy. I'm not able to use this shared connection for a subsequent query. MaxRecords set to 10, FetchAsNeeded = .T.
If I debug and then BROWSE the cursor, it changes to .F.
What would cause the CA to continue to show a busy connection? How can I release it?
TIA
Duty is ours, the results are God's - John Quincy Adams