Is it possible to pass the result of a query as a function parameter?

[guiroehe]

Hello,

I wonder if it is possible to pass the result of a query as a parameter in a function call. If so, what is the specification for the variable in the function code? I tried with Table, but the function receives an invalid content.

Also, how one tests if a query is NULL? objectexists(...) does not seem to work.

Thank you.

[jason_lightfoot_adsk · Accepted solution]

You can use a clone of the table result to cast it as an array and pass it as a variant parameter.

[guiroehe]

Hi, @jason_lightfoot_adsk ,

thank you. It worked.

I am implying that this way the query looses its "table" characteristics, correct (column names, indexes, etc.)?

Thank you once more.

[jason_lightfoot_adsk · Accepted solution]

Yes - you lose that information in a array.   You could alternatively create a Map of the table for better referencing and pass that to your function - try mapFromTable() here.

[guiroehe]

Thank you very much!