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
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
