Look up value based on XObjectKey and Column Name

Hi Dan,

There is a sample for this in the SDK, Modules\QBM\dvd\AddOn\SDK\ScriptSamples\02 Database connection\GetSingleValue.vb

You can use this to load a single value based on a table name and an XObjectkey value.

Regards

Hanno

I was hoping to run it as a query in a view so was hoping for a SQL function. In any case, I managed to use CASE WHEN THEN statements to grab the right object from the right table using the xobjectkey.

I was hoping to run it as a query in a view so was hoping for a SQL function. In any case, I managed to use CASE WHEN THEN statements to grab the right object from the right table using the xobjectkey.

Hi Dan,

Would you mind posting your query here. I am in that same situation. :-)