RobNorthcott
Programmer
I've got a freaky problem that I can't explain - just checking to see if it's a known issue with BDE/TQuery/QReport before I waste too much time...
Our app is written in Delphi 5 using the BDE and Paradox. It prints invoices using a TQuery to get the required lines of invoice(s) then prints them using QReport. Very occasionally it seems to miss one or more lines from the invoice. Running the print operation again always works, so it's not a data issue. All I can think of is that the query sometimes fails to return a full result set, or the QReport is skipping a line of the detail file. I've never managed to replicate this to test it, but a couple of customers have shown me invoices that have missing lines, so I know it is happening. It is VERY intermittant - one customer who reports this problem is a large wholesaler doing thousands of invoices a month and they reckon it only happens once a month.
Any ideas? Is there a known problem with intermittant failure of TQuery, QReport, BDE? It's almost as weird as that 4GB disk space bug...
BTW, it doesn't seem to be OS-linked - people have reported the problem on Win98 and XP, and possibly 2000 but I can't be sure of that.
Rob
Our app is written in Delphi 5 using the BDE and Paradox. It prints invoices using a TQuery to get the required lines of invoice(s) then prints them using QReport. Very occasionally it seems to miss one or more lines from the invoice. Running the print operation again always works, so it's not a data issue. All I can think of is that the query sometimes fails to return a full result set, or the QReport is skipping a line of the detail file. I've never managed to replicate this to test it, but a couple of customers have shown me invoices that have missing lines, so I know it is happening. It is VERY intermittant - one customer who reports this problem is a large wholesaler doing thousands of invoices a month and they reckon it only happens once a month.
Any ideas? Is there a known problem with intermittant failure of TQuery, QReport, BDE? It's almost as weird as that 4GB disk space bug...
BTW, it doesn't seem to be OS-linked - people have reported the problem on Win98 and XP, and possibly 2000 but I can't be sure of that.
Rob