Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

A novice question

I have a blob column in a data window, OLEdatabaseBLOB, that enables me to retrieve, update, and store an MS Word doc.  If I hard code the key value in the key clause, works fine.  If I switch to a variable (e.g., :job_id), it doesn't resolve.  The SQL shows the key value as "?", null.  So here's the dumb question, how do I pass a value to the variable in the key clause?  I've tried doing it several ways through the data window arguments but to no avail.

James

Former Member
replied

Hi Chris,

thanks for your helpful guidance through this.

After trying out I realized (you marked it with very important), that the retrieval argument has to have the same name than the primary key.

In your example for the key clause id = :id this is shown.

If you name the retrieval argument e.g. 'isid', then retrieving the BLOB (with where clause id = :isid) brought me up an error. Seems not to be logical for me, but worked only in this way.

Regards

Bernhard

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question