flattesterik
Posts: 10
|
| Posted: 11/23/2009, 6:48 AM |
|
Hi,
i'm trying to accomplish the following:
how can i add a "SQL Parameter" when using the Visual Query Builder in "Table"-mode? i don't want to lose the functionality of the "Table"-mode but i also want to use the SQL Parameter functionality which is only available in "SQL"-mode of the VQB.
The user interface won't let me do that, so any other ideas?
|
 |
 |
datadoit
|
| Posted: 11/24/2009, 10:36 AM |
|
Parameters can be specified in table view. See the lower right box of
the VQB where all parameters are set.
|
|
|
|
flattesterik
Posts: 10
|
| Posted: 11/25/2009, 1:26 AM |
|
thanks for the reply. Is that in CCS 4 or CCS 3? I do notice the "SQL Parameters"-button but it's only in "SQL"-mode, and not in "Table"-mode.
|
|
|
|
datadoit
|
| Posted: 11/25/2009, 10:57 AM |
|
flattesterik wrote:
> thanks for the reply. Is that in CCS 4 or CCS 3? I do notice the "SQL
> Parameters"-button but it's only in "SQL"-mode, and not in "Table"-mode.
> ---------------------------------------
Yes, you are correct. Looks like it must be in SQL mode.
A little method that we use: Use Navicat for MySQL to build all of your
SQL. It allows 'hot-swapping' between a query builder view and SQL
view. Test, confirm results, then copy and paste your SQL into CCS's
SQL view.
|
|
|
|
flattesterik
Posts: 10
|
| Posted: 11/25/2009, 11:56 PM |
|
funny, a colleague of mine just said exactly the same.
i filed a request at CCS to make it available in "Table"-mode.
|
|
|
|
|
