At 10:23 PM 07-11-02 +0000, you wrote:

>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.

Set the column's COMPUTED ColumnAttribute to True.

Helen