• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

Delphi4 quick reports problems

Hi,

I've written an application in Delphi 4 Developer (SP2) and wrote it using Paradox databases.

Now I've converted the application over to DAO 3.0 MS Access (not ODBC) databases and Quick Reports works really badly now--giving access violations and invalid floating point operation exceptions.  This is a really simple program which really only uses the OnNeedData event to retrieve the data from the rest of the program.  The exceptions are occuring INSIDE quick report after the OnNeedData routine is done.

Is this Quick Reports that comes with Delphi 4 that unstable?

As many comments would be welcome!

Thank you!
MP
0
mikepj
Asked:
mikepj
  • 8
  • 6
  • 3
1 Solution
 
ZifNabCommented:
hi mikepj,

have you downloaded the update file at QaSoft?

http://www.qusoft.com/

Updated QuickReport 3.0.4 Standard file

Regards, Zif.
0
 
mikepjAuthor Commented:
No; I didn't know it existed!  Will get back to you.

Thank you!
MP

0
 
mikepjAuthor Commented:
It still doesn't work.  More information:  All I need to do to get access violations with quick reports is:

1.  Show the form containing the QuickReport.
2.  Close the form
3.  Show the form again

I don't even need to do anything!

We're going to throw Quick Reports away; I guess it's worthless.

Thank you for trying.
MP

0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
ZifNabCommented:
mmm mikepj, wait a minute.... Are you using threads, or are you using the QR with it's thread method?

If so, your problem will probaly come from Access... Access doesn't like to work in threads... at least in some ways.
0
 
mikepjAuthor Commented:
I don't think so; I'm not doing anything special.
0
 
ZifNabCommented:
mikepj, try to make a simple same report with a paradox table from DBDemos... and check the result.
0
 
SupWangCommented:
Hi mikepj,
Try to drop a new table on the QuickRep form and connect the QuickRep to the new table (Don't connect something else to the new table).

Regards, SupWang
0
 
SupWangCommented:
In your code, if you use the "GetBookMark", "GotoBookMark" and "FreeBookMark". try to remove it as following. I still don't know why the bookmark will cause the prob. But maybe you need to
solve this prob quickly, so I tell you the way which I used to solve this prob.

procedure TBrPartsForm.Button1Click(Sender: TObject);
var
  Form1: TForm1;
//  BookMark: TBookMark;
begin
  Screen.Cursor := crHourglass;
//  BookMark := MastData.Parts.GetBookMark;
  Form1 := TForm1.Create(Self);
  Screen.Cursor := crDefault;
  try
    Form1.QuickRep1.PreView;
  finally
    Form1.Release;
//    MastData.Parts.GotoBookMark(BookMark);
//    MastData.Parts.FreeBookMark(BookMark);
  end;
end;
0
 
mikepjAuthor Commented:
I never did have time to check to see if this works.  I wanted to answer it before it disappears from the system.

Thank you,
MP

0
 
SupWangCommented:
I want to know if this works. if you have time, please check it and tell me the result in here.

Regards, SupWang
0
 
mikepjAuthor Commented:
Will do; it shouldn't take that long to do but I've been travelling and also quite busy.

Have you used Access 97/DAO 3.5 with Delphi before?
0
 
SupWangCommented:
Hi mikepj,
Sorry, I have not used Access 97/DAO 3.5.
Please take a look at my question: http://www.experts-exchange.com/secure/comp/lang/delphi/Q.10136064

Regards, SupWang
0
 
mikepjAuthor Commented:
VERY interesting!  Thank you for this info!

Best regards,
MP

0
 
SupWangCommented:
How did you think about that? In D3 not have this prob.
0
 
mikepjAuthor Commented:
I found this at www.opus.ch and I think this answers some of our questions!

"QuickReports for Delphi 4 does not work with Opus DirectAccess unless you get the upgrade from QuSoft becauses it uses threading internally. This is not compatible with DAO, the native Microsoft Jet engine interface, which Opus DirectAccess uses."

Later...
MP

0
 
mikepjAuthor Commented:
I jumped straight from D1/Paradox to D4/Access.  (Kind of a rough landing with regards to Access!).  For this reason, I know nothing of D2/D3...
0
 
SupWangCommented:
It only solve your prob. not mine. :-(
Does it means QuickReports for Delphi 4 can't compaticale with Access Database?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 8
  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now