on 01-26-2009 6:51 PM
Hi SAP,
I would like to know what the proper syntax is when using SQL Expressions in Crystal 11. I keep getting the same error message in Crystal when saving that states there is incorrect syntax near the keyword select.
Also, is there some documentation that briefly explains when it's a good idea to use SQL Expressions?
Thanks in advance,
- Zack H
Put everything in brackets.
(select whatever from whereever)
It embeds that SQL expression in the parent SQL statement, so it needs to be in brackets.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Raghavendra.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SELECT employee_lastname
FROM employee
WHERE employee_id={?Employee ID}
I never really used SQL expressions and would like to understand how this feature works in Crystal 11.
Any help would be much appreciated.
Thanks,
Zack H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please place your syntax here, makes it much easier to help you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.