CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Left Outer Join (Visual query builder)?

Print topic Send  topic

Author Message
Jan van Hout
Posted: 11/13/2002, 4:56 AM

Hi,

My Faircom ODBC driver doesn't use "LEFT JOIN" but "LEFT OUTER JOIN". So
everytime a query is build, an error rises from my Faircom ODBC driver.
After manually changing the SQL string everything is fine but is there a
possibility to change, for instance, the "LEFT JOIN" string in a template
(xml?) file?

Regards,


Jan

Alexey Alexapolsky
Posted: 11/14/2002, 6:11 AM

You can modify SQL generated by CCS in Data Source property.

--

Alex,
Support Engineer
CodeCharge Team


"Jan van Hout" <Janjr.vanHout@van-Hout.com> wrote in message
news:aqti6k$rh$1@news.codecharge.com...
> Hi,
>
> My Faircom ODBC driver doesn't use "LEFT JOIN" but "LEFT OUTER JOIN". So
> everytime a query is build, an error rises from my Faircom ODBC driver.
> After manually changing the SQL string everything is fine but is there a
> possibility to change, for instance, the "LEFT JOIN" string in a template
> (xml?) file?
>
> Regards,
>
>
> Jan
>
>

Jan van Hout
Posted: 11/15/2002, 4:22 AM

Alexey,

You mean change the generated code by hand? (in the code page?)
Thanks in advance

Jan


"Alexey Alexapolsky" <alexa@codecharge.com> schreef in bericht
news:ar0auq$ubc$2@news.codecharge.com...
> You can modify SQL generated by CCS in Data Source property.
>
> --
>
> Alex,
> Support Engineer
> CodeCharge Team
>
>
> "Jan van Hout" <Janjr.vanHout@van-Hout.com> wrote in message
>news:aqti6k$rh$1@news.codecharge.com...
> > Hi,
> >
> > My Faircom ODBC driver doesn't use "LEFT JOIN" but "LEFT OUTER JOIN". So
> > everytime a query is build, an error rises from my Faircom ODBC driver.
> > After manually changing the SQL string everything is fine but is there a
> > possibility to change, for instance, the "LEFT JOIN" string in a
template
> > (xml?) file?
> >
> > Regards,
> >
> >
> > Jan
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.