ADO Handling

Martin_Förster

Hallo

I have some questions to ADO!!
maybe someone can help me!

How can I get a spezific field value from a recordset wich I create in the same moment???

At the moment I create the recordset with recordset.open(sqlstring,.....)
and after that i send a SELECT String to the DB!!

Is there another way to get the Data???

Thanks
MF

Sorry for my english!!

ajayjain

Try this

field := recordset.fields.Item(FieldNo);

IF field.ActualSize <> 0 THEN
IF field.Type <> 8 THEN
FieldVal := FORMAT(field.Value)
ELSE
FieldVal := field.Value;