Grid backclor in VFP8

[kmagy]

Hi every body
Iam trying to set back color of the records in a grid based on customer balance, Iam using the following code
but it produces the error 'Unrecognized command verb'

DODEFAULT()
WITH THIS
.SetAll("DynamicBackColor", ;
&quot;IIF(BALANCE<0, RGB(255,170,213), ;
IIF(BALANCE=0, RGB(255,255,255), ;
IIF(BETWEEN(BALANCE1,500), RGB(255,255,168), ;
IIF(BETWEEN(BALANCE,501,1000), RGB(210,210,210), ;
IIF(BETWEEN(BALANCE,1001,3000), RGB(201,255,144), ;
IIF(BALANCE>3000, RGB(136,196,255), ;
RGB(255,255,255))))))))&quot;,&quot;COLUMN&quot
ENDWITH

Please let me know what is wrong with it
Thanks in advance

 

[ChrisRChamberlain]

kmagy

DODEFAULT()

should be

DODEFAULT

in VFP 8.0

FAQ184-2483 - the answer to getting answered.​

Chris

http://www.pdfcommander.com

http://www.pdfcommander.co.uk

 

[ChrisRChamberlain]

kmagy

Ignore that last post - I was thinking of DOEVENTS

FAQ184-2483 - the answer to getting answered.​

Chris

http://www.pdfcommander.com

http://www.pdfcommander.co.uk

 

[kmagy]

It is working fine when there is (5 IIF statments)
but when adding the sixth IIF statment it produces the error

 

[ChrisRChamberlain]

kmagy

Maybe a typo but 'BALANCE1,500' is missing a comma

Have you considered a DO CASE... statement as an alternative? It would be easier to maintain.

FAQ184-2483 - the answer to getting answered.​

Chris

http://www.pdfcommander.com

http://www.pdfcommander.co.uk

 

[Mike Gagnon]

kmagy

IIF(BETWEEN(BALANCE1,500)

Is this one right? Or is it a typo?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[kmagy]

It is written correclty in the form but when I write it here I wrote it without comma by mistake
Thanks