That seems to work. It is just understanding when to apply, and unapply
the FieldsReadOnly string list and when it was looked at by the Query
was the lacking knowledge.

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
Behalf Of Helen Borrie
Sent: Tuesday, May 03, 2005 9:30 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] How to skip over columns in an IB_GRID

At 07:30 PM 3/05/2005 -0500, you wrote:

>Depending on the current state of a data entry screen, I need to be
>able to skip over some columns within the grid and prevent editing in
>those columns.
>
>1. I have tried the IB_Grid.MoveCol to try and jump over the fields I
>did not want the user to access, but can find now supporting doc on how

>to use this. Can cause some great stack overflows with improper use.

No, it's not what you want. With the IBO native controls, the data
determines the behaviour of controls, not the other way around.

>2. Also tried IB_Query.FieldReadOnly string list setting. I can get
>that to work during an Insert of a record, but if I try to go back and
>put a record into Edit mode, then I get a "Trying to Edit a Read Only
>Field" exception. Is there a way to get around this exception? I do
>want to see the fields within the grid, just don't want them editing
>them.

Are you using this property properly? What you want is

MyDataset.FieldsReadOnly=ThatField=NOEDIT

(No spaces between the elements!!)

Set this property whilst the dataset is in dssBrowse, e.g. in the
BeforeEdit event handler.

Helen

>============================================
>The information transmitted is intended only for the person or entity

to

>which it is addressed and may contain confidential and/or privileged
>material. If the reader of this message is not the intended recipient
>you are hereby notified that you have received this message in error

and

>that any review, dissemination, distribution or copying of this message
>including any attachments is strictly prohibited. If you received this
>in
>error, please contact the sender and delete the material from any
>computer.
>
>Christopher Hart
>Profile Technology Group, LLC
>
>
>
>
>_______________________________________________________________________

____

>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 !
>Yahoo! Groups Links
>
>
>
>

________________________________________________________________________
___
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 !

Yahoo! Groups Links