Strange runtime error behaviour

[Crowley16]

I have a report which contains a bar chart, the rowsource of this bar chart is an sql string that is generated dynamically using information passed to the openArgs of the report.

I get a runtime error when I try to reassign the generated sql string to the rowsource of the chart object, however when I go to debug the code, and if I continue (F8) the code runs, and it works...

any ideas on what's going on?

--------------------
Procrastinate Now!

 

[ssecca]

Sounds like the call is taking longer to run then it take to get to the next step in your code. One possible way to resolve this might be to program in a pause at the approriate time. Basically make your code count to 1000 or 10000 as teh case may be. This would give the SQL time to send a return to your code before going on. Not elegent but it might work.

 

[Crowley16]

Sorry for the ridiculous delay in replying to this, but I was called away on something else, and then I went on holiday for 2 weeks...

Anyway, I put a delay in front of it, and it still has the same thing, so any other ideas?

it seems like it's not recognising the .rowsource property or at least not allowing me access to it, unless I'm in debug mode... very strange...

--------------------
Procrastinate Now!