RETRIEVE METHOD

[informer2009]

Have not programmed in this language in a long time. Trying to pass a value from a dataobject to a datawindow. Dataobject is called dw_report and window is w_audit. My SQL has a retrieval argument to pass this value. This is the code that I have so far.

string as_parameter_value

dw_report.SetTransObject(SQLCA)
dw_report.InsertRow(0)

dw_report.Retrieve(as_parameter_value)

When debugging, the value is never passed.

Please help!

 

[Mariaszek]

Do you set any value to as_parameter_value variable?

Do you use retrieval argument in SELECT of DataWindow Object?

Tomek

 

[informer2009]

Having difficulty setting value. This value is a field from a table. Tried as_parameter_value = ("parameter_parameter_value") but receive the error "Can not convert a char value to money..." I do have the retrieval argument set in the SELECT statement of my datawindow object.

 

[Mariaszek]

What is datatype of DataWindow parameter (what is declared datatype)? Is that the same as as_parameter_value variable?
If not, try to convert variable value to proper type.

For test, try to assign proper value to as_parameter_value variable and retrieve data.

Tomek

 

[informer2009]

Thanks for your assistance Mariaszek. I was able to finally get the value but encountered another issue. If there is no data retrieved, I receive an application execution error (R0006) - Invalid DataWindow row/column specified at line ... I modify the data so that there is a retrieval and I am able to populate the report with the value. Format the data back to what it was and still able to populate the report with the value. Hopefully I did not lose you in my explanation.