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++Builder6 enum

2013-03-18 Thread Charl Roux
there is no need for me to add quotes to all names? Date: Fri, 15 Mar 2013 07:05:11 -0700 From: adrian.kla...@gmail.com To: charl.r...@hotmail.com CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] C++Builder6 enum On 03/15/2013 04:06 AM, Charl Roux wrote: Hi, I am using C

[GENERAL] C++Builder6 enum

2013-03-15 Thread Charl Roux
Hi, I am using C++Builder6 on WinXPSP3, with Devart's dbExpress driver. I declared a enumeration type called 'professionEnum', which is used by my variable 'profession'. I get an error: 'Cannot access field 'rootcause' as type Text', if I try and enter a value into the enum field. 1. I

[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 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 =