What to do when an Active X command is invalid in FoxPro

[ontsjc]

Hello,

I'm using a charting Active X control (ChartFX) in a foxpro form. One of the things you can automate is the the division of the major and minor tic marks on the y-axis. The problem is that the property to set in the active x control to set the major tick marks is entitled STEP, the minor tick marks is MINORSTEP. When ever I try to automatically set the STEP tick mark, FoxPro gives me a syntax error. The MINORSTEP it has no problem with. Here's the code:

WITH THISFORM.Timeseriescontrol
.Axis(AXIS_Y).STEP = 150 &&This command generates syntax error
.Axis(AXIS_Y).MINORSTEP = 50 &&This command does not
ENDWITH

Is there anyway around this? I tried putting it into a variable, then executing the variable with a macro substitution, but that didn't work. Any help would be greatly appreciated. Thanks.

 

[Mike Gagnon]

Hard to say without having the activex.
Have tried a smaller value? Perhaps there is a maximum?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[ontsjc]

Thanks for the response. I know it's not the value, I can get it to work in an interactive mode where I enter it directly into an interface provided by the control. It is very strange. Every other property of the chart I can fill in behind the scences except this one. The vender has been no help. It gets really annoying when I have two hundred charts to get out and I have to manually set this single property for each one. If anything else comes to mind, let me know. Thanks again for responding.

 

[DSummZZZ]

Since STEP is a keyword, VFP probably ain't happy with it.

Have you tried other ways of setting the value, like maybe:

STORE ".Axis(AXIS_Y).STEP = 150" TO cSet
&cSet

or maybe

.Axis(AXIS_Y).OBJECT.STEP = 150

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[ontsjc]

VERY COOL! The one that worked was the first

STORE ".Axis(AXIS_Y).STEP = 150" TO cSet
&cSet

I had to change the AXIS_Y (which is a constant) to it's value of 0, but then it worked! Thank you very much. Huge headache gone.

What I don't understand though is I had tried the following previously and it didn't work:

cCMD = ".Axis(0).STEP = 150"
&cCMD

What's the difference?

 

[TamarGranor]

Another thing you could try is adding the Object keyword so VFP knows you're talking to the control.

WITH THISFORM.Timeseriescontrol.Object
     .Axis(AXIS_Y).STEP = 150  &&This command generates syntax error
     .Axis(AXIS_Y).MINORSTEP = 50 &&This command does not
ENDWITH

 

[ontsjc]

That works as well. Thanks. I'd never used the object keyword before. Thanks for everyone's help!

 

[DSummZZZ]

Glad you got it to work. As for why

STORE ".Axis(AXIS_Y).STEP = 150" TO cSet
&cSet

worked and

cCMD = ".Axis(0).STEP = 150"
&cCMD

didn't, not sure, unless 'cCMD' wasn't initialized first.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm