You need to mark it as COMPUTED in the ColumnAttributes.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Eric Handbury" <ehandbury@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, November 07, 2002 3:23 PM
Subject: [IBO] EIB_Dataset Error: XXX is readonly


> Hello,
>
> (BCB6-SP2, IBO4_2Hg, FB-1.0-796, Enh2.1.3)
>
> I have a selectable SP as follows:
> select USERKEY,MASTERKEY,FIRMNAME,... from SP_USERQUERY(...)
>
> The InsertSQL string is:
> EXEC PROC SP_USERADD(:USERKEY,:MASTERKEY,...)
>
> (The FIRMNAME field is just a Display Field from a inline select
> in the SP_USERQUERY SP, so the SP_USERADD SP doesn't need to include
> it in the InsertSQL parameters)
>
> When I do a Post on an Insert, I get the following exception:
> EIB_DatasetError: SP_USERQUERY.FIRMNAME is readonly
>
> But I know its readonly... and I have specified 'FIRMNAME=TRUE' in
> the FieldsReadOnly property. It's just a Display Field.
> I don't know why IBO would be concerned about FIRMNAME when its
> not in the InsertSQL/EditSQL strings.
>
> The call-stack is:
>
> 77E73887 C:\WINDOWS\system32\kernel32.dll
> 0055A72C Ib_components::TIB_Dataset::SysBeforeFieldDataChange
> 00574790 Ib_components::TIB_Row::DoBeforeModify
> 00576C23 Ib_components::TIB_Column::SetIsNull
> 00574DC4 Ib_components::TIB_Row::SetColumnValue
> 0055C562 Ib_components::TIB_Dataset::KeyToChildAction
> 00563B31 Ib_components::TIB_BDataset::CalculateFields
> 0055D8A9 Ib_components::TIB_Dataset::SysPost
> 00561EC7 Ib_components::TIB_BDataset::SysPost
> 00547D47 Ib_components::TIB_Transaction::SysPostAll
> 0054777E Ib_components::TIB_Transaction::SysCommitRetaining
> 00546635 Ib_components::TIB_Transaction::CommitRetaining
> 004025E3 TUserForm::CloseBtnClick(this=:019B1A50, Sender=:019B35D4)
>
> Any ideas? Thanks in advance. Eric.