Skip to Content
0

Formatted Search Query for DocCur in ORDR

Jan 05, 2017 at 10:16 AM

16

avatar image
Former Member

Hello,

i need help with a query for a formatted Search.

During adding a new Order:

If CardCode = '20015' THEN 'USD'

my Query only works as FMS, but not during adding a new Order:

Select CASE
When $[$4.0.0] = '20015' THEN 'USD'
ELSE $[$63.0.0] END


....

SELECT 'DocCur'=
CASE 
WHEN $[ORDR.CardCode] = '20015' THEN 'USD'
ELSE $[ORDR.DocCur] END

1). [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'ORDR.DocCur'.

Where is my mistake ?

Thanx

Markus

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers