ADO Handling

Martin_Förster
Martin_Förster Member Posts: 55
edited 2005-04-13 in Navision Financials
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!!

Comments

  • ajayjain
    ajayjain Member Posts: 119
    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;
    Ajay Jain
    UK

Categories