Jan van Hout
|
| Posted: 05/23/2003, 2:05 AM |
|
Alexei,
With Codecharge Studio 2.0 (currently evaluating);
Is there a way to change the 'default' "LEFT JOIN" statement into "LEFT OUTER JOIN". My faircom ODBC doesn't understand "LEFT JOIN" just "LEFT OUTER". Is there an XML file where this can be changed?
Regards,
Jan
|
|
|
 |
RonB
|
| Posted: 05/24/2003, 8:03 AM |
|
Here's what i do if the standard sql generated by CCS fails me. I create the query using query builder. When i'm satisfied I change it from table to sql. CCS will gernerate the sql from the builder and you can change it as you like.
Ron
|
|
|
|
Jan
|
| Posted: 05/26/2003, 11:41 AM |
|
Mmmmhm,
Why isn't it possible to edit the query result from the query builder? I click on "SQL" after connecting and defining the relations. But the only thing I can do is "view" the sql...
How can I edit the SQL string?
Jan
|
|
|
|
glerma
|
| Posted: 05/26/2003, 7:23 PM |
|
Jan. You can edit the "Codecharge Generated" SQL String by doing this:
1. Select your datasource from the record properties.
2. At the top left of the Data Source Window there is a drop-down selection called "Data Source Type". Select "SQL" from the input.
This will bring up the SQL code for your joined-table select statement. You can then manually modify this to your needs.
Hope this helps.
George
|
|
|
|
