RB 6.02 and TChart 5.01 in D5

rbuser

I am having a problem with getting the chart to show data all the
time. Every other time I run the report there is data, and the other
times the chart is blank. This problem is easily reproducible in my
application and so I rolled back to RB 6.01 and the problem went away.
This leads me to believe there is a problem with RB 6.02. Have you
seen this behavior before?

Mike Hubbard

digitalmetaphors

This isn't a known issue. True, the datapipeline implementation may be a
little different from 6.01 and 6.02, and it may be behaving differently
based on your code. When you say every other time it works, then doesn't
work, then this may point to a missing initialization of a variable, or the
data set record pointer is still stuck at the end of the dataset? Are you
opening and closing the datsets before, during, after the report is run?
Let the report open and close the datasets for you and traverse the data.
You shouldn't have to manipulate the dataset, the report engine may get out
of sync otherwise.

If you create a new report outside of your application, and place a dbChart
in it, do you get the same behavior?


Cheers,

Jim Bennett
Digital Metaphors

rbuser

The application is fairly complex. I open the report before it is run
so that I can extract the SQL statement. I parse it, then display a
dialog to the user so that they may enter parameters (similar to your
auto search dialog, but with more specific needs for our app). I then
validate the users entries and insert them into the SQL statement
embedded in the report. Then I run the report. This has worked for 2
years and works fine with RB 6.01.

With RB 6.02 it alternates between working and showing no data. For
example the first time it may show data, then it will be blank then it
shows data, then it is blank, and so on and so on. The only thing
that varies is the first time; it may or may not show data. After
that the pattern is consistent.

Something has changed in 6.02 to cause this. Please help or I will
not ever be able to upgrade.

Thanks

Mike Hubbard

digitalmetaphors

We'll need a working demo so that we can isolate what is causing this. I
would take the SQL extraction/ insertion out of the equation first. Create
a simple sql statement for the report to use, just to see if that part of
the application is causing the problem.

Have you checked the sql that is used everytime the report is run? Perhaps,
write the sql to a txt file when the user enters criteria, and afterwards
copy the sql into a TQuery feeding a TDBGrid on a form to make sure it isn't
the problem. Please, make the simplest demo possible (without sending your
whole application) to support@digital-metaphors.com

Cheers,

Jim Bennett
Digital Metaphors

rbuser

>We'll need a working demo so that we can isolate what is causing this. I

I am sure it probably is related to the SQL extraction/insertion if
you are not experiencing the problem. Creating a working demo will be
a lot of work but I will see what I can do.



The SQL is not the problem. First of all it is the same
extraction/insertion every time and it works only every other time.
Second of all I have verified with the SQL Profiler that the SQL is
valid.

Mike