CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 queries and unions

Print topic Send  topic

Author Message
Deborah Herman
Posted: 01/19/2003, 8:26 AM

I'm using CodeCharge with MS Access. I find that when I try to select some
queries as the record source Code Charge returns the error Database
Connection Error. They are usually the more complex queries. Also Code
Charge won't even allow me to select union queries. Would appreciate any
input. Thanks
Deb



Shawn Mason
Posted: 01/19/2003, 1:29 PM

Don't use Access but if I had to guess, a UNION type query is not supported
by the driver. Since this is happening with complex queries you are
probably blowing the driver away.

--
Kindest Regards,

Shawn Mason,CCD,MCP
I.S. Software Design Associates

"Deborah Herman" <debsails@pacbell.net> wrote in message
news:b0ejjd$umm$1@news.codecharge.com...
> I'm using CodeCharge with MS Access. I find that when I try to select
some
> queries as the record source Code Charge returns the error Database
> Connection Error. They are usually the more complex queries. Also Code
> Charge won't even allow me to select union queries. Would appreciate any
> input. Thanks
> Deb
>
>
>
>

DAVID
Posted: 01/20/2003, 4:21 AM

Production MYSQL does not support union operations.


"Shawn Mason" <shawn@issda.com> wrote in message
news:b0f5bb$v9o$1@news.codecharge.com...
> Don't use Access but if I had to guess, a UNION type query is not
supported
> by the driver. Since this is happening with complex queries you are
> probably blowing the driver away.
>
> --
> Kindest Regards,
>
> Shawn Mason,CCD,MCP
> I.S. Software Design Associates
>
> "Deborah Herman" <debsails@pacbell.net> wrote in message
>news:b0ejjd$umm$1@news.codecharge.com...
> > I'm using CodeCharge with MS Access. I find that when I try to select
> some
> > queries as the record source Code Charge returns the error Database
> > Connection Error. They are usually the more complex queries. Also Code
> > Charge won't even allow me to select union queries. Would appreciate any
> > input. Thanks
> > Deb
> >
> >
> >
> >
>
>

Deborah Herman
Posted: 01/21/2003, 11:37 PM

Thanks. I found the problem with some of the queries. If the query name had
spaces then Code Charge would show the name in the drop list of available
tables/views but as soon as I selected it, I got "Database Connection
Error".

As far as the Union queries, I found interesting results. If I used the DSN
for my connection rather than a custom connection string, the Union Queries
do show in the available tables. They don't work but they do show. With
the Custom connection string the Union Queries don't even show at all.

I did test with the MSOracle ODBC driver and Union Queries seem to work.
Since Oracle is my final destination, I'll just have to move the project to
Oracle sooner than I thought. Of course I am using an older version of
Access (97). Maybe Access 2000 is different ???


"Shawn Mason" <shawn@issda.com> wrote in message
news:b0f5bb$v9o$1@news.codecharge.com...
> Don't use Access but if I had to guess, a UNION type query is not
supported
> by the driver. Since this is happening with complex queries you are
> probably blowing the driver away.
>
> --
> Kindest Regards,
>
> Shawn Mason,CCD,MCP
> I.S. Software Design Associates
>
> "Deborah Herman" <debsails@pacbell.net> wrote in message
>news:b0ejjd$umm$1@news.codecharge.com...
> > I'm using CodeCharge with MS Access. I find that when I try to select
> some
> > queries as the record source Code Charge returns the error Database
> > Connection Error. They are usually the more complex queries. Also Code
> > Charge won't even allow me to select union queries. Would appreciate any
> > input. Thanks
> > Deb
> >
> >
> >
> >
>
>

Raxip
Posted: 01/28/2003, 3:42 PM

I have a silly question ... are union queries when you use 2 tables out of a
databse?

"Deborah Herman" <debsails@pacbell.net> wrote in message
news:b0lhn5$446$1@news.codecharge.com...
> Thanks. I found the problem with some of the queries. If the query name
had
> spaces then Code Charge would show the name in the drop list of available
> tables/views but as soon as I selected it, I got "Database Connection
> Error".
>
> As far as the Union queries, I found interesting results. If I used the
DSN
> for my connection rather than a custom connection string, the Union
Queries
> do show in the available tables. They don't work but they do show. With
> the Custom connection string the Union Queries don't even show at all.
>
> I did test with the MSOracle ODBC driver and Union Queries seem to work.
> Since Oracle is my final destination, I'll just have to move the project
to
> Oracle sooner than I thought. Of course I am using an older version of
> Access (97). Maybe Access 2000 is different ???
>
>
> "Shawn Mason" <shawn@issda.com> wrote in message
>news:b0f5bb$v9o$1@news.codecharge.com...
> > Don't use Access but if I had to guess, a UNION type query is not
> supported
> > by the driver. Since this is happening with complex queries you are
> > probably blowing the driver away.
> >
> > --
> > Kindest Regards,
> >
> > Shawn Mason,CCD,MCP
> > I.S. Software Design Associates
> >
> > "Deborah Herman" <debsails@pacbell.net> wrote in message
> >news:b0ejjd$umm$1@news.codecharge.com...
> > > I'm using CodeCharge with MS Access. I find that when I try to select
> > some
> > > queries as the record source Code Charge returns the error Database
> > > Connection Error. They are usually the more complex queries. Also
Code
> > > Charge won't even allow me to select union queries. Would appreciate
any
> > > input. Thanks
> > > Deb
> > >
> > >
> > >
> > >
> >
> >
>
>

Rick Neal
Posted: 01/28/2003, 4:32 PM

Here is what it says in the mySQL manual:

UNION Syntax



SELECT ....
UNION [ALL]
SELECT ....
[UNION
SELECT ...]

UNION is implemented in MySQL 4.0.0.

UNION is used to combine the result from many SELECT statements into one
result set.

The SELECT commands are normal select commands, but with the following
restrictions:


· Only the last SELECT command can have INTO OUTFILE.

· Only the last SELECT command can have ORDER BY.

If you don't use the keyword ALL for the UNION, all returned rows will be
unique, like if you had done a DISTINCT for the total result set. If you
specify ALL, then you will get all matching rows from all the used SELECT
statements.


"Raxip" <raxip@accesscomm.ca> wrote in message
news:b174gf$q7h$1@news.codecharge.com...
> I have a silly question ... are union queries when you use 2 tables out of
a
> databse?
>
> "Deborah Herman" <debsails@pacbell.net> wrote in message
>news:b0lhn5$446$1@news.codecharge.com...
> > Thanks. I found the problem with some of the queries. If the query name
> had
> > spaces then Code Charge would show the name in the drop list of
available
> > tables/views but as soon as I selected it, I got "Database Connection
> > Error".
> >
> > As far as the Union queries, I found interesting results. If I used the
> DSN
> > for my connection rather than a custom connection string, the Union
> Queries
> > do show in the available tables. They don't work but they do show.
With
> > the Custom connection string the Union Queries don't even show at all.
> >
> > I did test with the MSOracle ODBC driver and Union Queries seem to work.
> > Since Oracle is my final destination, I'll just have to move the project
> to
> > Oracle sooner than I thought. Of course I am using an older version of
> > Access (97). Maybe Access 2000 is different ???
> >
> >
> > "Shawn Mason" <shawn@issda.com> wrote in message
> >news:b0f5bb$v9o$1@news.codecharge.com...
> > > Don't use Access but if I had to guess, a UNION type query is not
> > supported
> > > by the driver. Since this is happening with complex queries you are
> > > probably blowing the driver away.
> > >
> > > --
> > > Kindest Regards,
> > >
> > > Shawn Mason,CCD,MCP
> > > I.S. Software Design Associates
> > >
> > > "Deborah Herman" <debsails@pacbell.net> wrote in message
> > >news:b0ejjd$umm$1@news.codecharge.com...
> > > > I'm using CodeCharge with MS Access. I find that when I try to
select
> > > some
> > > > queries as the record source Code Charge returns the error Database
> > > > Connection Error. They are usually the more complex queries. Also
> Code
> > > > Charge won't even allow me to select union queries. Would appreciate
> any
> > > > input. Thanks
> > > > Deb
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


   


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

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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