Thanks Fred, that makes sense. I'll give it a go. Tina Currie DataHouse www.datahouse.com.au
-----Original Message----- From: Fred Taylor [mailto:[email protected]] Sent: Tuesday, 12 October 2010 11:40 AM To: ProFox Email List Subject: Re: Setting backcolours in grid ... AGAIN A string constant is limited to 256 characters. Try building up a variable to contain your ICASE() code and using the variable in the SetAll call. Also, you're not continuing a string variable correctly between multiple lines, you have to use + to concatenate strings, you'r just continuing the line. I'm surprised that code would even attempt to compile the way you have it. Fred On Mon, Oct 11, 2010 at 5:28 PM, Tina Currie <[email protected]> wrote: > Hi there, > > > > Can anyone see a major flaw in this code? I've got baby brain remember (4 > months pregnant) and have moments of extreme fuzziness these days LOL > > > > If I only use 4 different cases in the ICASE() function, it's fine - but it > whines when I do any more than that. Is there a limitation I don't know > about using the SetAll? > > > > thisform.grdSchedule.SetAll("DynamicBackColor", "ICASE(curScheduler.techid = > '00001',RGB(255,45,45),; > > curScheduler.techid = > '00002',RGB(0,128,0),; > > curScheduler.techid = > '00003',RGB(128,0,255),; > > curScheduler.techid = > '00010',RGB(64,128,128),; > > curScheduler.techid = > '00004',RGB(255,128,0),; > > > curScheduler.techid = > '00005',RGB(0,0,255),; > > curScheduler.techid = > '00006',RGB(128,128,0),; > > curScheduler.techid = > '00007',RGB(128,0,64),; > > curScheduler.techid = > '00008',RGB(128,64,0),; > > curScheduler.techid = > '00009',RGB(128,128,128),; > > > RGB(255,255,255))","Column") > > > > Thanks in Advance, > > > > Tina > > > > > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
