RE: select statement

On Thu, 21 Jun 2001, Dave Page wrote:
>
> > -----Original Message-----
> > From: Joseph [mailto:lters(at)mrtc(dot)com]
> > Sent: 21 June 2001 11:54
> > To: pgsql-odbc(at)postgresql(dot)org
> > Subject: [ODBC] select statement
> >
> >
> > Why does the odbc driver sometimes put a
> >
> > 'select * from'
> >
> > in front of select statments?
> >
> > It seems to only do it sometimes...
> >
> > respectfully,
> > Joseph
>
> This is often done by Microsoft DAO or ADO when you specify commandtype =
> Table on a datacontrol or similar. If you specify commandtype = Text this
> will not happen.
>
> HTH, regards, Dave.

I've noticed this with Access. Seems that if Access gets an error from
the backend, eg. from invalid SQL, it will add 'select * from' in front of
the SQL and try again (most of the time this will fail also.. As far as I
can see, this is so that you can use just a table name instead of a SQL
statement for a datasource (like you can with Access/Jet) and it will
work.

-Cedar