Use VBA to read query results

[chogben]

I'm new to business objects. I've been playing with VBA for over four years.

The data I've got doesn't lend itself well to one small task, which would be easier to do using VBA - the difficulty is in examining the data returned by a query, and using this to create another table.

Building the provider doesn't look to be a problem, it's just reading the data from the query. Can anyone help?

Some sample code to modify would be great.

 

[Guest_imported]

try referncing the dataprovider class
then assign the value to an array

Dim docVar As busobj.DocumentVariable
Dim arrBlob

For ctr = 1 To ThisDocument.DocumentVariables.Count
If ThisDocument.DocumentVariables(ctr).Name = "obj1???" Then

Set docVar = ThisDocument.DocumentVariables(ctr)
arrBlob = docVar.Values(Bo41Behavior)
End If
Next ctr

#this should give you access to the value of the of the variable
#try to create a oc variable and assign the formula ppty whats ever calc/measur you want#
#try to forcecompute to print out the data
#ThisDocument.Reports(2).ForceCompute