On 03/15/2013 04:06 AM, Charl Roux wrote:
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.
Not sure where 'professionEnum' comes into play, it not shown anywhere below. I will assume you mean 'rootCauseEnum'.
1. I create the table as follows: CREATE TABLE IF NOT EXISTS status( statusCode BIGINT PRIMARY KEY, description VARCHAR(50), level SMALLINT, rootCause rootCauseEnum, material VARCHAR(100), actionTaken VARCHAR(50) ) 2. I add an enum type 'rootCauseEnum' as follows: AnsiString SQL; SQL = "CREATE TYPE "; SQL = SQL + edtEnumerationType->Text; // My entry: rootCauseEnum SQL = SQL + " AS ENUM ( "; SQL = SQL + edtEnumerationList->Text; // My entry: 'none','unknown','elec','oil' SQL = SQL + " )"; int errorCode = frmDataModule->eyeConnection->ExecuteDirect(SQL); 3. I add a record to the status table from the command prompt which works fine as follows: eye=# INSERT INTO status VALUES( 100002, 'Running', 0, 'none', 'Not applicable', 'NA'); 4.I add a record to the status table from C++Builder as follows: I have an edit box for every field, as I enter the following all is fine: statusCode=100003 description=Stopped level=0 As I enter any of the following into the rootCause field: rootCause=none rootCause=1 I get the following error: Cannot access field 'rootcause' as type Text.
Are you sure this is not a case sensitivity problem on the field rootCause. In your table definition it is rootCause, in the error message it is rootcause. Postgres will fold down unless the field name is quoted. If the the original table definition quoted the field names then they retain their case and need to be quoted when used. For more detail see:
http://www.postgresql.org/docs/9.2/static/sql-syntax-lexical.html 4.1.1. Identifiers and Key Words
Therefore before I apply the updates to the table, i get the error. The field 'rootCause' is indicated as (Memo) in run-time. This worked fine when I used MySQL. With MySQL I can enter rootCause=none or rootCause=1 Thanks. Charl
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
