We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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"
The text was updated successfully, but these errors were encountered:
Commented by: @cincuranet
That's expected. The TableAdapter is validating the query according to T-SQL "rules".
Sorry, something went wrong.
status: Open [ 1 ] => Closed [ 6 ]
resolution: Won't Fix [ 2 ]
cincuranet
No branches or pull requests
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"
The text was updated successfully, but these errors were encountered: