If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > General Protection Violation with calculated field in report

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-21-07, 16:19
MarkUK MarkUK is offline
Registered User
 
Join Date: Jul 2007
Posts: 1
General Protection Violation with calculated field in report

Hello,
I am new to posting on this forum, but have been intermittently lurking for a number of years. I have a problem that I have not been able to solve myself or find a solution anywhere

I regularly find that I get a General Protection Violation when I try to set up a calculated field in a report.

I have a calculated field in a final report band and if, for example, I set the value to something like..

Code:
 Sum([Capitalgains.PaymentReceived]) - Sum([Capitalgains.CostOfPurchase])
If the report is opened in design mode and not previously run, I can save the report and it crashes out when I try to run it, or, if I have previously run it, it crashes when I try to save any changes to the calculated field. Once changed, saved, exited Paradox and reopened, it works perfectly!

Is this a known bug, or am I overlooking something very silly?

Many Thanks

Mark
Acer 1.8GHz Win XP SP2
Paradox 10.0.0.990
BDE 5.01
Reply With Quote
  #2 (permalink)  
Old 10-06-07, 20:22
Shores Shores is offline
Registered User
 
Join Date: Aug 2003
Location: Bologna - Italy
Posts: 209
Hi!

I don't know if this is a known bug, but many times i had to rebuild a Report totally from scratch for problems like this, and in these cases the only thing that resolved was REBUILDING ALL FROM AN EMPTY REPORT, NOT copying ANY object from the original report...

Bye!
__________________
The only failure is not trying to do it.
Reply With Quote
  #3 (permalink)  
Old 10-12-07, 01:47
OzBrian OzBrian is offline
Registered User
 
Join Date: Jul 2006
Posts: 2
When I have encountered this problem, it is ALWAYS with a calculated field ina Report and usually when I want to alter the field. The only way that I have found around it is to totally delete the calculted field - insert a new field and start the "calculation formula" all over again. Paradox reports do not seem to accept a large number of calculted reports either
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On