Passing a parameter to an embedded query

Hi:
I have a table with an embedded query, which uses a parameter. I would need to pass the value for this parameter from another table (a field from this table).
The problem is I don't have a way to access the embedded query from the second table...
I mean, I tried tu use HExecuteQuery but it doesn't recognize the embedded query,


Thanks;
Michael

Michael
This seems to be the major issue with these queries - work where they are but invisible to evrything else.
It can be done but passing params to an embedded query requires a special type of (undocumented) syntax.

I did receive this from PCS free support but unfortunately cannot find it at the moment.

It will be somewhere in the old forum archive but I would suggest you contact the technical support people.

HTH

DerekT

Hi Michael...

I would suggest that you UNembedd the query in question... It will
become much more manageable, and as your table can still be linked to
the query in question, you will not loose any functionality

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on [www.fabriceharari.com]


Michael wrote:
> Hi:
> I have a table with an embedded query, which uses a parameter. I would need to pass the value for this parameter from another table (a field from this table).
> The problem is I don't have a way to access the embedded query from the second table...
> I mean, I tried tu use HExecuteQuery but it doesn't recognize the embedded query,
>
> Thanks;
> Michael
>
Message forwarded from pcsoft.us.windev