Dear All,
i want to create a very simple formatted search, which updates the unitprice-field in sales order when itemcode changes.
With the actual cardcode number and itemcode of the sales order (before saving) i want to check my udt (specialprice) for a fitting entry and want to return a price out of this udt.
My FS:
SELECT
T0.U_SpecialPrice AS [Specialprice]
FROM
[@XXX_SPECIALPRICE] T0
WHERE (T0.U_CardCode = $[$4.0.0] AND T0.U_ItemCode = $[$38.1.0])
If i replace the $-Codes with a test-value the fs works. The udf's have the necessary types and digits.
The error-message can't help me: incorrect syntax near '$4.0.0'
Thank you for your answers...
GB