Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Dynamic Datawindow Background Color

6 posts in DataWindow Last posting was on 2008-08-18 20:24:10.0Z
meb.tucson Posted on 2008-08-18 17:44:18.0Z
From: meb.tucson@gmail.com
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Dynamic Datawindow Background Color
Date: Mon, 18 Aug 2008 10:44:18 -0700 (PDT)
Organization: http://groups.google.com
Lines: 28
Message-ID: <5c899d1c-bdb3-4e99-8264-6889557be7eb@b30g2000prf.googlegroups.com>
NNTP-Posting-Host: 199.46.245.231
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1219081458 12808 127.0.0.1 (18 Aug 2008 17:44:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 18 Aug 2008 17:44:18 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b30g2000prf.googlegroups.com; posting-host=199.46.245.231; posting-account=IN7E2goAAAAtEaBcY2ZAIdDzm2Ko8_wX
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 webwasher (Webwasher 6.7.6.3649)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!b30g2000prf.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87574
Article PK: 416830

How can I modify a datawindow object to change a column record's
background.color value using an "if" statement?

In the datawindow painter I can add the following "if" statement to
the background.color.

if ( isNull(#1), 12648384, 16777215)

This will make the background color white for column 1 if the value is
not null and light green if the value is null. If I look at the
Datawindow Syntax for column 1 I see the following.

background.color="16777215~tif ( isNull(#1), 12648384, 16777215)"

How can an "if" statement like the above be created using the
datawindow Modify function rather than the datawindow painter? I have
tried the following but none of them work.

dw_details.Modify("#1.Background.Color='16777215~tif ( isNull(#1),
12648384, 16777215)'")
dw_details.Modify("#1.Background.Color='16777215~~tif ( isNull(#1),
12648384, 16777215)'")
dw_details.Modify("#1.Background.Color='16777215~~~tif ( isNull(#1),
12648384, 16777215)'")
dw_details.Modify("#1.Background.Color='16777215~~~~tif ( isNull(#1),
12648384, 16777215)'")

Any help would be greatly appreciated. Thank you!


"Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_ Posted on 2008-08-18 18:54:28.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_@_teamsybase.com>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Datawindow Background Color
References: <5c899d1c-bdb3-4e99-8264-6889557be7eb@b30g2000prf.googlegroups.com>
In-Reply-To: <5c899d1c-bdb3-4e99-8264-6889557be7eb@b30g2000prf.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48a9c564$1@forums-1-dub>
Date: 18 Aug 2008 11:54:28 -0700
X-Trace: forums-1-dub 1219085668 10.22.241.152 (18 Aug 2008 11:54:28 -0700)
X-Original-Trace: 18 Aug 2008 11:54:28 -0700, vip152.sybase.com
Lines: 48
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87575
Article PK: 416831

I seem to be having all kinds of quirkiness with it. Apparently, you
can't set background properties for invisible controls (columns that you
"delete" off of the datawindow"). I also can't seem to modify a
background property using a column number.

Try this:
String ls_name, ls_valid
Long i

FOR i = Long (dw_1.Describe ("datawindow.column.count")) TO 1 STEP -1
ls_name = dw_1.Describe ("#" + String (i) + ".Name")
ls_valid = dw_1.Describe (ls_name + ".background.mode")
IF ls_Valid <> '!' THEN
dw_1.Modify (ls_name + ".Background.Mode='0'")
dw_1.Modify (ls_name + ".Background.Color='16777215~tif(isnull(" +
ls_name + "), 12648384, 16777215)'")
END IF
NEXT

meb.tucson@gmail.com wrote:
> How can I modify a datawindow object to change a column record's
> background.color value using an "if" statement?
>
> In the datawindow painter I can add the following "if" statement to
> the background.color.
>
> if ( isNull(#1), 12648384, 16777215)
>
> This will make the background color white for column 1 if the value is
> not null and light green if the value is null. If I look at the
> Datawindow Syntax for column 1 I see the following.
>
> background.color="16777215~tif ( isNull(#1), 12648384, 16777215)"
>
> How can an "if" statement like the above be created using the
> datawindow Modify function rather than the datawindow painter? I have
> tried the following but none of them work.
>
> dw_details.Modify("#1.Background.Color='16777215~tif ( isNull(#1),
> 12648384, 16777215)'")
> dw_details.Modify("#1.Background.Color='16777215~~tif ( isNull(#1),
> 12648384, 16777215)'")
> dw_details.Modify("#1.Background.Color='16777215~~~tif ( isNull(#1),
> 12648384, 16777215)'")
> dw_details.Modify("#1.Background.Color='16777215~~~~tif ( isNull(#1),
> 12648384, 16777215)'")
>
> Any help would be greatly appreciated. Thank you!


meb.tucson Posted on 2008-08-18 19:28:38.0Z
From: meb.tucson@gmail.com
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Datawindow Background Color
Date: Mon, 18 Aug 2008 12:28:38 -0700 (PDT)
Organization: http://groups.google.com
Lines: 73
Message-ID: <380aae25-9cec-47e1-81b0-a0b3dcc44b2f@n33g2000pri.googlegroups.com>
References: <5c899d1c-bdb3-4e99-8264-6889557be7eb@b30g2000prf.googlegroups.com> <48a9c564$1@forums-1-dub>
NNTP-Posting-Host: 199.46.245.231
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1219087718 32550 127.0.0.1 (18 Aug 2008 19:28:38 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 18 Aug 2008 19:28:38 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: n33g2000pri.googlegroups.com; posting-host=199.46.245.231; posting-account=IN7E2goAAAAtEaBcY2ZAIdDzm2Ko8_wX
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 webwasher (Webwasher 6.7.6.3649)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newspeer1.nac.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!n33g2000pri.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87576
Article PK: 416834

On Aug 18, 11:54 am, "Jason 'Bug' Fenter [TeamSybase]"

<NO_SPAMMING_jason.fenter_@_teamsybase.com> wrote:
> I seem to be having all kinds of quirkiness with it. Apparently, you
> can't set background properties for invisible controls (columns that you
> "delete" off of the datawindow"). I also can't seem to modify a
> background property using a column number.
>
> Try this:
> String ls_name, ls_valid
> Long i
>
> FOR i = Long (dw_1.Describe ("datawindow.column.count")) TO 1 STEP -1
>         ls_name = dw_1.Describe ("#" + String (i) + ".Name")
>         ls_valid = dw_1.Describe (ls_name + ".background.mode")
>         IF ls_Valid <> '!' THEN
>                 dw_1.Modify (ls_name + ".Background.Mode='0'")
>                 dw_1.Modify (ls_name + ".Background.Color='16777215~tif(isnull(" +
> ls_name + "), 12648384, 16777215)'")
>         END IF
> NEXT
>
>
>
> meb.tuc...@gmail.com wrote:
> > How can I modify a datawindow object to change a column record's
> > background.color value using an "if" statement?
>
> > In the datawindow painter I can add the following "if" statement to
> > the background.color.
>
> > if ( isNull(#1), 12648384, 16777215)
>
> > This will make the background color white for column 1 if the value is
> > not null and light green if the value is null.  If I look at the
> > Datawindow Syntax for column 1 I see the following.
>
> > background.color="16777215~tif ( isNull(#1), 12648384, 16777215)"
>
> > How can an "if" statement like the above be created using the
> > datawindow Modify function rather than the datawindow painter?  I have
> > tried the following but none of them work.
>
> > dw_details.Modify("#1.Background.Color='16777215~tif ( isNull(#1),
> > 12648384, 16777215)'")
> > dw_details.Modify("#1.Background.Color='16777215~~tif ( isNull(#1),
> > 12648384, 16777215)'")
> > dw_details.Modify("#1.Background.Color='16777215~~~tif ( isNull(#1),
> > 12648384, 16777215)'")
> > dw_details.Modify("#1.Background.Color='16777215~~~~tif ( isNull(#1),
> > 12648384, 16777215)'")
>
> > Any help would be greatly appreciated.  Thank you!- Hide quoted text -
>
> - Show quoted text -

I added your recommendation to my code and then added the statement
below.

ls_attributes = dw_1.Describe("DataWindow.syntax")

The "~t" in your statement "dw_1.Modify (ls_name +
".Background.Color='16777215~tif(isnull(" +
ls_name + "), 12648384, 16777215)'")" appears as below in
ls_attributes for each of my columns. (The "~t" is interpreted as a
tab.)

background.color="16777215 if(isnull(eiacodxa), 12648384, 16777215)"

How can I keep the Modify function from interpreting "~t" as a tab?


Dean Jones Posted on 2008-08-18 20:24:10.0Z
From: "Dean Jones" <dean_dot_jones_at_powerobjects_dot_com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <5c899d1c-bdb3-4e99-8264-6889557be7eb@b30g2000prf.googlegroups.com> <48a9c564$1@forums-1-dub> <380aae25-9cec-47e1-81b0-a0b3dcc44b2f@n33g2000pri.googlegroups.com>
Subject: Re: Dynamic Datawindow Background Color
Lines: 88
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48a9da6a@forums-1-dub>
Date: 18 Aug 2008 13:24:10 -0700
X-Trace: forums-1-dub 1219091050 10.22.241.152 (18 Aug 2008 13:24:10 -0700)
X-Original-Trace: 18 Aug 2008 13:24:10 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87578
Article PK: 416832

Defaultvalue is a value that can be converted to the appropriate datatype
for the property. It is followed by a tab (~t).


--
Dean Jones
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 Ext. 112

TeamSybase
* * Think Sybase * *


<meb.tucson@gmail.com> wrote in message
news:380aae25-9cec-47e1-81b0-a0b3dcc44b2f@n33g2000pri.googlegroups.com...
On Aug 18, 11:54 am, "Jason 'Bug' Fenter [TeamSybase]"

<NO_SPAMMING_jason.fenter_@_teamsybase.com> wrote:
> I seem to be having all kinds of quirkiness with it. Apparently, you
> can't set background properties for invisible controls (columns that you
> "delete" off of the datawindow"). I also can't seem to modify a
> background property using a column number.
>
> Try this:
> String ls_name, ls_valid
> Long i
>
> FOR i = Long (dw_1.Describe ("datawindow.column.count")) TO 1 STEP -1
> ls_name = dw_1.Describe ("#" + String (i) + ".Name")
> ls_valid = dw_1.Describe (ls_name + ".background.mode")
> IF ls_Valid <> '!' THEN
> dw_1.Modify (ls_name + ".Background.Mode='0'")
> dw_1.Modify (ls_name + ".Background.Color='16777215~tif(isnull(" +
> ls_name + "), 12648384, 16777215)'")
> END IF
> NEXT
>
>
>
> meb.tuc...@gmail.com wrote:
> > How can I modify a datawindow object to change a column record's
> > background.color value using an "if" statement?
>
> > In the datawindow painter I can add the following "if" statement to
> > the background.color.
>
> > if ( isNull(#1), 12648384, 16777215)
>
> > This will make the background color white for column 1 if the value is
> > not null and light green if the value is null. If I look at the
> > Datawindow Syntax for column 1 I see the following.
>
> > background.color="16777215~tif ( isNull(#1), 12648384, 16777215)"
>
> > How can an "if" statement like the above be created using the
> > datawindow Modify function rather than the datawindow painter? I have
> > tried the following but none of them work.
>
> > dw_details.Modify("#1.Background.Color='16777215~tif ( isNull(#1),
> > 12648384, 16777215)'")
> > dw_details.Modify("#1.Background.Color='16777215~~tif ( isNull(#1),
> > 12648384, 16777215)'")
> > dw_details.Modify("#1.Background.Color='16777215~~~tif ( isNull(#1),
> > 12648384, 16777215)'")
> > dw_details.Modify("#1.Background.Color='16777215~~~~tif ( isNull(#1),
> > 12648384, 16777215)'")
>
> > Any help would be greatly appreciated. Thank you!- Hide quoted text -
>
> - Show quoted text -

I added your recommendation to my code and then added the statement
below.

ls_attributes = dw_1.Describe("DataWindow.syntax")

The "~t" in your statement "dw_1.Modify (ls_name +
".Background.Color='16777215~tif(isnull(" +
ls_name + "), 12648384, 16777215)'")" appears as below in
ls_attributes for each of my columns. (The "~t" is interpreted as a
tab.)

background.color="16777215 if(isnull(eiacodxa), 12648384, 16777215)"

How can I keep the Modify function from interpreting "~t" as a tab?


Dean Jones Posted on 2008-08-18 20:22:08.0Z
From: "Dean Jones" <dean_dot_jones_at_powerobjects_dot_com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <5c899d1c-bdb3-4e99-8264-6889557be7eb@b30g2000prf.googlegroups.com> <48a9c564$1@forums-1-dub> <380aae25-9cec-47e1-81b0-a0b3dcc44b2f@n33g2000pri.googlegroups.com>
Subject: Re: Dynamic Datawindow Background Color
Lines: 86
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48a9d9f0$1@forums-1-dub>
Date: 18 Aug 2008 13:22:08 -0700
X-Trace: forums-1-dub 1219090928 10.22.241.152 (18 Aug 2008 13:22:08 -0700)
X-Original-Trace: 18 Aug 2008 13:22:08 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87577
Article PK: 416833

It needs to be a tab.

--
Dean Jones
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 Ext. 112

TeamSybase
* * Think Sybase * *


<meb.tucson@gmail.com> wrote in message
news:380aae25-9cec-47e1-81b0-a0b3dcc44b2f@n33g2000pri.googlegroups.com...
On Aug 18, 11:54 am, "Jason 'Bug' Fenter [TeamSybase]"

<NO_SPAMMING_jason.fenter_@_teamsybase.com> wrote:
> I seem to be having all kinds of quirkiness with it. Apparently, you
> can't set background properties for invisible controls (columns that you
> "delete" off of the datawindow"). I also can't seem to modify a
> background property using a column number.
>
> Try this:
> String ls_name, ls_valid
> Long i
>
> FOR i = Long (dw_1.Describe ("datawindow.column.count")) TO 1 STEP -1
> ls_name = dw_1.Describe ("#" + String (i) + ".Name")
> ls_valid = dw_1.Describe (ls_name + ".background.mode")
> IF ls_Valid <> '!' THEN
> dw_1.Modify (ls_name + ".Background.Mode='0'")
> dw_1.Modify (ls_name + ".Background.Color='16777215~tif(isnull(" +
> ls_name + "), 12648384, 16777215)'")
> END IF
> NEXT
>
>
>
> meb.tuc...@gmail.com wrote:
> > How can I modify a datawindow object to change a column record's
> > background.color value using an "if" statement?
>
> > In the datawindow painter I can add the following "if" statement to
> > the background.color.
>
> > if ( isNull(#1), 12648384, 16777215)
>
> > This will make the background color white for column 1 if the value is
> > not null and light green if the value is null. If I look at the
> > Datawindow Syntax for column 1 I see the following.
>
> > background.color="16777215~tif ( isNull(#1), 12648384, 16777215)"
>
> > How can an "if" statement like the above be created using the
> > datawindow Modify function rather than the datawindow painter? I have
> > tried the following but none of them work.
>
> > dw_details.Modify("#1.Background.Color='16777215~tif ( isNull(#1),
> > 12648384, 16777215)'")
> > dw_details.Modify("#1.Background.Color='16777215~~tif ( isNull(#1),
> > 12648384, 16777215)'")
> > dw_details.Modify("#1.Background.Color='16777215~~~tif ( isNull(#1),
> > 12648384, 16777215)'")
> > dw_details.Modify("#1.Background.Color='16777215~~~~tif ( isNull(#1),
> > 12648384, 16777215)'")
>
> > Any help would be greatly appreciated. Thank you!- Hide quoted text -
>
> - Show quoted text -

I added your recommendation to my code and then added the statement
below.

ls_attributes = dw_1.Describe("DataWindow.syntax")

The "~t" in your statement "dw_1.Modify (ls_name +
".Background.Color='16777215~tif(isnull(" +
ls_name + "), 12648384, 16777215)'")" appears as below in
ls_attributes for each of my columns. (The "~t" is interpreted as a
tab.)

background.color="16777215 if(isnull(eiacodxa), 12648384, 16777215)"

How can I keep the Modify function from interpreting "~t" as a tab?


meb.tucson Posted on 2008-08-18 20:23:42.0Z
From: meb.tucson@gmail.com
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Dynamic Datawindow Background Color
Date: Mon, 18 Aug 2008 13:23:42 -0700 (PDT)
Organization: http://groups.google.com
Lines: 92
Message-ID: <2044233e-fddc-4a51-b2a9-6557e8d73de4@u6g2000prc.googlegroups.com>
References: <5c899d1c-bdb3-4e99-8264-6889557be7eb@b30g2000prf.googlegroups.com> <48a9c564$1@forums-1-dub> <380aae25-9cec-47e1-81b0-a0b3dcc44b2f@n33g2000pri.googlegroups.com>
NNTP-Posting-Host: 199.46.245.231
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1219091023 10789 127.0.0.1 (18 Aug 2008 20:23:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 18 Aug 2008 20:23:43 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: u6g2000prc.googlegroups.com; posting-host=199.46.245.231; posting-account=IN7E2goAAAAtEaBcY2ZAIdDzm2Ko8_wX
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 webwasher (Webwasher 6.7.6.3649)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!u6g2000prc.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87579
Article PK: 416835


On Aug 18, 12:28 pm, meb.tuc...@gmail.com wrote:
> On Aug 18, 11:54 am, "Jason 'Bug' Fenter [TeamSybase]"
>
>
>
>
>
> <NO_SPAMMING_jason.fenter_@_teamsybase.com> wrote:
> > I seem to be having all kinds of quirkiness with it. Apparently, you
> > can't set background properties for invisible controls (columns that you
> > "delete" off of the datawindow"). I also can't seem to modify a
> > background property using a column number.
>
> > Try this:
> > String ls_name, ls_valid
> > Long i
>
> > FOR i = Long (dw_1.Describe ("datawindow.column.count")) TO 1 STEP -1
> >         ls_name = dw_1.Describe ("#" + String (i) + ".Name")
> >         ls_valid = dw_1.Describe (ls_name + ".background.mode")
> >         IF ls_Valid <> '!' THEN
> >                 dw_1.Modify (ls_name + ".Background.Mode='0'")
> >                 dw_1.Modify (ls_name + ".Background.Color='16777215~tif(isnull(" +
> > ls_name + "), 12648384, 16777215)'")
> >         END IF
> > NEXT
>
> > meb.tuc...@gmail.com wrote:
> > > How can I modify a datawindow object to change a column record's
> > > background.color value using an "if" statement?
>
> > > In the datawindow painter I can add the following "if" statement to
> > > the background.color.
>
> > > if ( isNull(#1), 12648384, 16777215)
>
> > > This will make the background color white for column 1 if the value is
> > > not null and light green if the value is null.  If I look at the
> > > Datawindow Syntax for column 1 I see the following.
>
> > > background.color="16777215~tif ( isNull(#1), 12648384, 16777215)"
>
> > > How can an "if" statement like the above be created using the
> > > datawindow Modify function rather than the datawindow painter?  I have
> > > tried the following but none of them work.
>
> > > dw_details.Modify("#1.Background.Color='16777215~tif ( isNull(#1),
> > > 12648384, 16777215)'")
> > > dw_details.Modify("#1.Background.Color='16777215~~tif ( isNull(#1),
> > > 12648384, 16777215)'")
> > > dw_details.Modify("#1.Background.Color='16777215~~~tif ( isNull(#1),
> > > 12648384, 16777215)'")
> > > dw_details.Modify("#1.Background.Color='16777215~~~~tif ( isNull(#1),
> > > 12648384, 16777215)'")
>
> > > Any help would be greatly appreciated.  Thank you!- Hide quoted text -
>
> > - Show quoted text -
>
> I added your recommendation to my code and then added the statement
> below.
>
> ls_attributes = dw_1.Describe("DataWindow.syntax")
>
> The "~t" in your statement "dw_1.Modify (ls_name +
> ".Background.Color='16777215~tif(isnull(" +
> ls_name + "), 12648384, 16777215)'")" appears as below in
> ls_attributes for each of my columns.  (The "~t" is interpreted as a
> tab.)
>
> background.color="16777215 if(isnull(eiacodxa), 12648384, 16777215)"
>
> How can I keep the Modify function from interpreting "~t" as a tab?- Hide quoted text -
>
> - Show quoted text -

I mentioned in my last post that the "~t" is converted to a tab when I
view the results of the Describe("DataWindow.syntax"). Previously, I
was not seeing the desired column color changes at runtime when the
"~t" showed up as a tab via the Describe("DataWindow.syntax"),
however, this time around the background is changing colors at runtime
as desired so all is well. Thank you for your help.