if you use your own editSQL, just remove the fields from the update
statement. Any attempts to update is met with "dead" controls. That's what I
do with IB_ controls anyway.
I do this for different roles. If the role is e.g. equirer, then
onPrepareSQL will clear and add a different update statement into EditSQP
property.
Alan

> -----Original Message-----
> From: tickerboo2002 [mailto:support@...]
> Sent: Thursday, 29 May 2003 7:56 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Dataset ReadOnly=true, controls throw exceptions
>
>
> When I display a dialog, I sometimes want the dataset to be read
> only. Only one row is displayed for which I use a transaction, query
> & datasource. I set the following:
>
> tn->ReadOnly = true;
> ds->AutoEdit = false;
> qry->ReadOnly = true;
> qry->PreventEditing = true;
>
> but this still allows the user to enter a control and when attempting
> to change the data an exception is thrown. Is there anyway to
> prevent this apart from changing all the bound controls to
> ReadOnly=true?
>
> TIA
>
> David
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>