access rows

[timbo]

Hi,

After executing an SQL query using an OracleQuery I then want to store some of the values as variables. I can do it fine for the first row by using: OracleQuery1->Field("FieldName")
but I can't work out how to get values for the following rows. (The query returns multiple rows).

I'm very new to DOA and Oracle so this probably a stupid question.

thanks,

Tim

 

[F.Hinlopen]

Hello,

Use OracleQuery1->Next(). As a matter of style, call OracleQuery1->Close() when you're all done. The online help suggests otherwise BTW.

Originally posted by timbo:
Hi,

After executing an SQL query using an OracleQuery I then want to store some of the values as variables. I can do it fine for the first row by using: OracleQuery1->Field("FieldName")
but I can't work out how to get values for the following rows. (The query returns multiple rows).

I'm very new to DOA and Oracle so this probably a stupid question.

thanks,

Tim

------------------
Frans

 

[timbo]

thanks a lot,

Tim