Query-Help formatted Search in Document lines during acquisition

[markus_schaefer242]

Hello,
I need help with a query for a formatted Search in which a value from a column (POR1.Text = ItemDetails)
is written to an UDF - even before it is saved.

Query:

SELECT $[$38.256.0] FROM POR1 T0  
INNER JOIN OPOR T1 ON T0.[DocEntry] = T1.[DocEntry] 
WHERE T1.[DocNum] = $[$8.0.0] and T0.[VisOrder] = $[$38.0.0]

Can you find my error in this case ?

Thanks for your help.

Greetings
Markus

[LoHa]

Hi Markus,

I don't really understand, what you expect.

Where is the UDF (Lines/Header), you want to fill, and where is the Information you want to get (Lines/Header). You are mixing the value/variables in your query in a strange way.

e.g.

SELECT $[$38.256.0] (from Lines) FROM POR1 T0  
INNER JOIN OPOR T1 ON T0.[DocEntry] = T1.[DocEntry] 
WHERE T1.[DocNum] = $[$8.0.0] (from Header) and T0.[VisOrder] = $[$38.0.0] (from Lines)

If you'd like to test your query, open the Form where the magic should happen. And then open the FMS via Menu
Tools->Queries->UserQueries ---choose FMS

The variabels will be filled the with the values it could get from the Form

regards

Lothar