[Firebird-net-provider] [FB-Tracker] Created: (DNET-594) In DDEX "|" is not recognized.

[Anton V. (JIRA) <tr...@fi...>]

In DDEX "|" is not recognized.
------------------------------

                 Key: DNET-594
                 URL: http://tracker.firebirdsql.org/browse/DNET-594
             Project: .NET Data provider
          Issue Type: Bug
          Components: DDEX Provider
    Affects Versions: 4.6.1.0
         Environment: Windows 7
Firebird 2.5
VS 2013 ultimate

            Reporter: Anton Veretennikov
            Assignee: Jiri Cincura


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"

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira