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 fo
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
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 wrote:
> > --_51d77859-0e03-4afa-bde6-853bee
On 2013-03-13, Charl Roux 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 TfrmMain::FormCreat
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 )"
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 = frmDataModule->eyeConnection->ExecuteDir
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
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
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,
els
