Skip to Content
0
Jun 09, 2011 at 04:45 PM

formatted search - syntaxhelp

106 Views

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