Re: [GENERAL] C++Builder table exist

2013-03-18 Thread Charl Roux
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_

Re: [GENERAL] C++Builder table exist

2013-03-18 Thread Albe Laurenz
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

Re: [GENERAL] C++Builder table exist

2013-03-18 Thread Adrian Klaver
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

Re: [GENERAL] C++Builder table exist

2013-03-16 Thread Jasen Betts
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

[GENERAL] C++Builder table exist

2013-03-13 Thread Charl Roux
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,

Re: [GENERAL] C++Builder table exist

2013-03-13 Thread Raymond O'Donnell
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

Re: [GENERAL] C++Builder table exist

2013-03-13 Thread Raymond O'Donnell
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

Re: [GENERAL] C++Builder table exist

2013-03-13 Thread Charl Roux
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 =

Re: [GENERAL] C++Builder table exist

2013-03-13 Thread Raymond O'Donnell
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 );