It all depends on why and how you are using it. Basically in a grid no field is acessible unless used in the grid.
The rest is simply not retrieved. I made the same assumption at first. That also explaines why it does work after performing your own query to the database.
>>> Not always True, but I've seen the problem occur here also.
Second..... from the sparse example you give a simple question arises.....wich record in the set are you trying to retrieve? If the recordset has 30 records, each containing the field "debit", wich one are you expecting to be displayed?
You may have a point here - most likely, things will work as expected
after executing the select statement based on the condition to select
one record.
Thankyou.
