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:

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 wrote: > > --_51d77859-0e03-4afa-bde6-853bee

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

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 = frmDataModule->eyeConnection->ExecuteDir

[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, els