there is no need for me to add quotes to all names?
To: pgsql-general@postgresql.org
From: ja...@xnet.co.nz
Subject: Re: [GENERAL] C++Builder table exist
Date: Sat, 16 Mar 2013 06:16:33 +
On 2013-03-13, Charl Roux charl.r...@hotmail.com wrote:
--_51d77859-0e03-4afa-bde6-853bee9c0a11_
Charl Roux wrote:
Is there any way of getting PostgreSQL to work according to the SQL standard
(The folding of unquoted
names to lower case in PostgreSQL is incompatible with the SQL standard,
which says that unquoted
names should be folded to upper case.), so there is no need for me to add
On 03/18/2013 03:25 AM, Charl Roux wrote:
Thanks. Case-folding was my problem.
Is there any way of getting PostgreSQL to work according to the SQL
standard (The folding of unquoted names to lower case in PostgreSQL is
incompatible with the SQL standard, which says that unquoted names
should be
On 2013-03-13, Charl Roux charl.r...@hotmail.com wrote:
--_51d77859-0e03-4afa-bde6-853bee9c0a11_
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
appologies for the formatting, gmane did something to your email that
SLRN didn't like.
void __fastcall
Hi,
I have migrated from MySQL to PostgreSQL. I am running on WindowsXP SP3,
C++Builder6, PostgreSQL9.2, pgExpress4.6(database driver)
I have the following scenarion. If my applications starts up, it will test if a
certain table exists within the database. If not, it will create the table,
On 13/03/2013 10:59, Charl Roux wrote:
Hi,
I have migrated from MySQL to PostgreSQL. I am running on WindowsXP SP3,
C++Builder6, PostgreSQL9.2, pgExpress4.6(database driver)
I have the following scenarion. If my applications starts up, it will
test if a certain table exists within the
On 13/03/2013 11:46, Charl Roux wrote:
Thanks for the response.
1.
I have used the following line to determine if the table does exist in
the database:
if( tableList-IndexOf(queryBackup) 0 )
errorCode = frmDataModule-eyeConnection-ExecuteDirect(SQL);
Please don't top-post: it makes
Hi Ray,
Thanks for all the help. It works perfectly.
void __fastcall TfrmMain::FormCreate(TObject *Sender)
{
unsigned int errorCode;
AnsiString SQL = CREATE TABLE IF NOT EXISTS queryBackup( queryName text
PRIMARY KEY, query text );
errorCode =
On 13/03/2013 13:19, Charl Roux wrote:
Hi Ray,
Thanks for all the help. It works perfectly.
void __fastcall TfrmMain::FormCreate(TObject *Sender)
{
unsigned int errorCode;
AnsiString SQL = CREATE TABLE IF NOT EXISTS queryBackup( queryName
text PRIMARY KEY, query text );