Parsing DBQuery Array

[ueberyak]

I am successfully running DBConnect and DBQuery. I am struggling to return the values out of the array, however. I pretty much copied what was in the Help section under DBQuery but to no avail. What am I missing?

Here's my code, minus the DBConnect and Let>SQL= bits. (But again, I know I'm returning the data.) There is only one field in the SQL.

Code: Select all

DBQuery>dbH,SQL,rsProdOrders,NumRecs,NumFields,1

Let>r=0
Repeat>r
  Let>r=r+1
  Let>f=0
  Repeat>f
    Let>f=f+1
    Let>this_field=rsProdOrders_%r%_%f%
    Message>this_field
    Wait>.3
  Until>f=NumFields
Until>r=NumRecs

DBClose>dbH

[ueberyak]

I changed

Code: Select all

DBQuery>dbH,SQL,rsProdOrders,NumRecs,NumFields,1

to

Code: Select all

DBQuery>dbH,SQL,rsProdOrders,NumRecs,NumFields,0

and now it works.