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

SQL query with no result set but inserting possible ?

From: Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de>
To: <pgsql-odbc(at)postgresql(dot)org> <pgsql-odbc(at)postgresql(dot)org>
Subject: SQL query with no result set but inserting possible ?
Date: 2005-08-27 05:32:13
Message-ID: db7dca1226370403b65bf9ba4e3cc6e9@lollisoft.de (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

I have the circumstance that a SQL query returns no result set, because 
the table is empty or the where clause reduces the result
to nothing.

Is it possible to add new data anyhow without creating a insert query 
with the related columns ?

Thanks

Lothar

--
Lothar Behrens	|	Rapid Prototyping ...
Rosmarinstr 3		|	
40235 Düsseldorf  	|	www.lollisoft.de


pgsql-odbc by date

Next:From: Dave PageDate: 2005-08-27 08:26:52
Subject: Re: Four part names
Previous:From: Timothy ReedDate: 2005-08-26 21:02:30
Subject: Re: MS Access 2000 w/ PGSQL 8.0.x

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