Skip site navigation (1) Skip section navigation (2)

RE: select statement

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Joseph'" <lters(at)mrtc(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: RE: select statement
Date: 2001-06-21 11:45:05
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2C75@woody.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

> -----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.

Responses

pgsql-odbc by date

Next:From: Johann ZuschlagDate: 2001-06-21 17:54:56
Subject: RE: slow performance postgres 7.0.3 and odbc
Previous:From: JosephDate: 2001-06-21 10:54:23
Subject: select statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group