Blair,
Sorry if my message was not clear. I know how to use ADO. I was trying
to find the correct method to access or update a field in a recordset
in Dolphin's ADODB classes. Looking through the methods I could not
find anything specifc other than a method called #fields. But this
returns a collection of field objects and their values which means I
have to write my own method to access a particular field's data.
In VB for example you would just simply say something like (provided I
created the recordset)
amt=myRecordset.Field("amount") ' retrieve data
myRecordset.Field("amount")=amt ' set data.
I am looking for a similar method in Dolphin. E.g.
myRecordset field: 'amount'
or
myRecordset field: 'amount' value: 123
Costas