Subject | EIB_Dataset Error: XXX is readonly |
---|---|
Author | Eric Handbury |
Post date | 2002-11-07T22:23:37Z |
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.
(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.