In DDEX "|" is not recognized. [DNET594]

[firebird-automations]

Submitted by: Anton Veretennikov (trueboroda)

I try to create TableAdapter with select comand for fill.

SQL for Select comand:

SELECT FIRM.FIRM_NAME, FIRM.FIRM_ADRESS, FIRM.PHONE, FIRM.FAX, FIRM.EMAIL, list(f.FORM_INCORPORATION | | ' ' | | lp.LEGAL_PERSON) AS LEGAL_PERSONS_LIST FROM FIRM LEFT OUTER JOIN LEGAL_PERSON lp ON FIRM.ID_FIRM = lp.ID_FIRM INNER JOIN FORM_INCORPORATION f ON lp.ID_FORM_INCORPORATION = f.ID_FORM_INCORPORATION WHERE (lower(trim(FIRM.FIRM_NAME)) LIKE '%' | | @name | | '%') GROUP BY FIRM.FIRM_NAME, FIRM.FIRM_ADRESS, FIRM.PHONE, FIRM.FAX, FIRM.EMAIL

I get next error message. Query Builder throws exception. It`s translated from russian text by me

"Error in functions arguments list: "|" is not recognized. Unable to parse query text"

[firebird-automations]

Commented by: @cincuranet

That's expected. The TableAdapter is validating the query according to T-SQL "rules".

[firebird-automations]

Modified by: @cincuranet

status: Open \[ 1 \] =\> Closed \[ 6 \] resolution: Won't Fix \[ 2 \]