How do I set the DW_1 to Display Only

[John Jemerson]

Hi

I would like to set on a click event a dw_1 on the Edit tab the Display Only
to TRUE.

Having trouble finding out.

Have to be something like this:

dw_1.object.name.edit.DisplayOnly = TRUE

Please let me know.

Thanks

[DT]

Look up the readonly property for the datawindow.

"John Jemerson" <inter...@hotmail.com> wrote in message
news:403a636b$1@forums-1-dub...

[DT]

sorry, spoke too soon. i guess it depends on what you're trying to do.
if you're trying to not allow them to change things in the datawindow itself,
readonly isn;t it. If you don't have to scroll, you
can disable the datawindow (dw_1.Enabled = FALSE). This disables all the
datawindow events as well.

if you want events to fire, but not get focus, you can set the tab order to 0.

if you don't want anything updated back to the database, use readonly (like
setting the update property on the datawindow object to not updatable).
however, the datawindow events still fire and the datawindow can have focus.

"DT" <david....@integritycompanies.com> wrote in message
news:403a6511$1@forums-1-dub...

[John Jemerson]

Not really what I was looking. The user must click in order to scroll down
therefore the suggestions you mention will not work. What I really want is
to set the check mark on the datawindow object d_#### and on the Edit tab of
the field column Display Only property and later uncheck that property.

Example:

dw_1.column.edit.Displayonly = true or 1

Get the picture.

Thanks

"DT" <david....@integritycompanies.com> wrote in message

news:403a68bd@forums-1-dub...

[John Jemerson]

Ok.

I found out how to do it. Here is:

dw_1.object.description.edit.displayonly = TRUE

description is the column name.

Thanks all

"John Jemerson" <inter...@hotmail.com> wrote in message
news:403a636b$1@forums-1-dub...

[Michael]

You can create a function on u_dw that will protect all
columns. That way it's available everywhere you need it.
Code as follows:

long ll_cols
long ll_col
long ll_row
string ls_describe
long ll_protect
boolean lb_modifiable[]

ll_cols = long(this.describe('Datawindow.Column.Count'))

for ll_col = 1 to ll_cols
if ab_switch = true then
ls_describe = '#' + string(ll_col) + '.protect'
if this.describe(ls_describe) = '1' then
lb_modifiable[ll_col] = false
else
lb_modifiable[ll_col] = true
end if
ls_describe += " = 1"
this.modify (ls_describe)
else
if upperbound(lb_modifiable[]) = 0 then
return 0
else
if lb_modifiable[ll_col] = true then
ll_protect = 0
else
ll_protect = 1
end if
ls_describe = "#" + string(ll_col) + ".protect = " +
string(ll_protect)
this.modify(ls_describe)
end if
end if
next

just pass in true or false, scrolling will still be
available, but the user won't be able to click on any
columns.
>

[Bill Green[TeamSybase]]

BTW, if you do FILE | NEW and go to the TOOLS tab, there's a utility
built-in called dwSyntax which will help you determine the syntax for
changing datawindow properties.

--
Bill Green[TeamSybase]
VP-Power3
www.power3.com
-----------------------------------------------------------------

www.pb9books.com
PB9 Advanced Client-Server
PB9 Distributed Application Development
-----------------------------------------------------------------

"John Jemerson" <inter...@hotmail.com> wrote in message

news:403aa1bd@forums-1-dub...

[Jerry Siegel]

Here's the command for a custom toolbar button:
wizard:?action=runonly&entry=k60_dwsyntax_sheet

"Bill Green[TeamSybase]" <bill....@teamsybase.com> wrote in message
news:403c20e0@forums-1-dub...

[Bill Green[TeamSybase]]

Spoken like a veteran that has figured out which utilities are
important...<g>

--
Bill Green[TeamSybase]
VP-Power3
www.power3.com
-----------------------------------------------------------------

www.pb9books.com
PB9 Advanced Client-Server
PB9 Distributed Application Development
-----------------------------------------------------------------

"Jerry Siegel" <jer...@data-sci.com.nospam> wrote in message
news:403ccb3e$1@forums-2-dub...

[Jerry Siegel]

I've only been using PB since 3.0a - a few more years and I'll have all the
attributes memorized <G>.

"Bill Green[TeamSybase]" <bill....@teamsybase.com> wrote in message

news:403d638b$1@forums-2-dub...