dbTalk Databases Forums  

Search and Replace gives GPF error

comp.databases.paradox comp.databases.paradox


Discuss Search and Replace gives GPF error in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dan
 
Posts: n/a

Default Search and Replace gives GPF error - 04-25-2006 , 07:56 AM






I have a form in my application that I want to do a search and replace on a
field column (ctrl-shift-z) in edit gives me the dialog. Each time I execute
the "change next option" I get a General Protection Fault to abort
operation. If I select abort, I get errors 216 @ 00002E28 and 71F40. Has
anyone seen this error before and have a solution?

Thanks
(I am using Paradox V10)
Dan



Reply With Quote
  #2  
Old   
Bertil Isberg
 
Posts: n/a

Default Re: Search and Replace gives GPF error - 04-25-2006 , 08:19 AM






You can find a lot of causes to Genreal Protection Violations error in
the document Errors explained on my site - URL below.

Search the index file for Unexpected: General Protection Violation. Note
, there are two entries in the index.

--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply

Reply With Quote
  #3  
Old   
Dan
 
Posts: n/a

Default Re: Search and Replace gives GPF error - 04-25-2006 , 08:52 AM



I found the error 216 as "Service Pack #1 needs to be installed before
Service Pack #2" How do I correct this?

I found a solution on the form by deleting one of two table views on the
form and replacing with a field. Don't understand why that would cause a
GPF.

Dan


"Bertil Isberg" <bertil.isberg (AT) retlifmapsSCB (DOT) se> wrote

Quote:
You can find a lot of causes to Genreal Protection Violations error in the
document Errors explained on my site - URL below.

Search the index file for Unexpected: General Protection Violation. Note ,
there are two entries in the index.

--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply



Reply With Quote
  #4  
Old   
Bertil Isberg
 
Posts: n/a

Default Re: Search and Replace gives GPF error - 04-25-2006 , 03:34 PM



Dan
<<
I found the error 216 as "Service Pack #1 needs to be installed before
Service Pack #2" How do I correct this?
Quote:
I'm pretty sure this is not your problem.


<<<
I found a solution on the form by deleting one of two table views on the
form and replacing with a field. Don't understand why that would cause a
GPF
Quote:
Can you recreate this problem in a new form, I would be interested in
getting a full description of how to create such a form?

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://web.comhem.se/~u82608896/

"Dan" <megaflex (AT) bellsouth (DOT) net> skrev i meddelandet
news:444e29b8$1 (AT) pnews (DOT) thedbcommunity.com...
Quote:
I found the error 216 as "Service Pack #1 needs to be installed before
Service Pack #2" How do I correct this?

I found a solution on the form by deleting one of two table views on the
form and replacing with a field. Don't understand why that would cause a
GPF.

Dan


"Bertil Isberg" <bertil.isberg (AT) retlifmapsSCB (DOT) se> wrote in message
news:444e21e8$1 (AT) pnews (DOT) thedbcommunity.com...
You can find a lot of causes to Genreal Protection Violations error in
the
document Errors explained on my site - URL below.

Search the index file for Unexpected: General Protection Violation. Note
,
there are two entries in the index.

--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply





Reply With Quote
  #5  
Old   
Bertil Isberg
 
Posts: n/a

Default Re: Search and Replace gives GPF error - 04-27-2006 , 04:13 PM



Dan

I can verify your GPV in all versions of Paradox since Paradox 7. If you
limit the size of the ShdwProj tableframe so only one row is showing, the
GPV does not occur.

Noone has mentioned this problem earlier, mainly because Locate and Replace
is not a common operation, I guess.


--
Bertil Isberg - CTECH
Paradox buglist:
online: http://web.comhem.se/~u82608896/

"Dan" <megaflex (AT) bellsouth (DOT) net> skrev i meddelandet
news:44510cb5$1 (AT) pnews (DOT) thedbcommunity.com...
Quote:
Bertil,
I have attached two tables linked in data model one to many and two forms.
You can copy to your work folder in Paradox V10 to execute. The
"twotabletest.fsl" shows two table frames linked in data model. If you try
to do a ctl-shift-z to search and replace values in the "service desc"
field
you get a GPF, error 216. If you go to the "twotabletest2.fsl" and try the
search and replace it works fine. Any clues to why this doesn't work?

Thanks
Dan

"Bertil Isberg" <bertil.isberg@NOcomhemSPAMdotse> wrote in message
news:444e87d8$1 (AT) pnews (DOT) thedbcommunity.com...
Dan

I found the error 216 as "Service Pack #1 needs to be installed before
Service Pack #2" How do I correct this?


I'm pretty sure this is not your problem.



I found a solution on the form by deleting one of two table views on the
form and replacing with a field. Don't understand why that would cause a
GPF


Can you recreate this problem in a new form, I would be interested in
getting a full description of how to create such a form?

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://web.comhem.se/~u82608896/

"Dan" <megaflex (AT) bellsouth (DOT) net> skrev i meddelandet
news:444e29b8$1 (AT) pnews (DOT) thedbcommunity.com...
I found the error 216 as "Service Pack #1 needs to be installed before
Service Pack #2" How do I correct this?

I found a solution on the form by deleting one of two table views on
the
form and replacing with a field. Don't understand why that would cause
a
GPF.

Dan


"Bertil Isberg" <bertil.isberg (AT) retlifmapsSCB (DOT) se> wrote in message
news:444e21e8$1 (AT) pnews (DOT) thedbcommunity.com...
You can find a lot of causes to Genreal Protection Violations error
in
the
document Errors explained on my site - URL below.

Search the index file for Unexpected: General Protection Violation.
Note
,
there are two entries in the index.

--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply










Reply With Quote
  #6  
Old   
Dan
 
Posts: n/a

Default Re: Search and Replace gives GPF error - 04-28-2006 , 08:32 AM



I converted the shdwproj table to a single field. That works, it is just not
as functional as having a list of choices for hte users to hi-lite to move
to another set of records. Thanks for reviewing.

I have also noticed if you make the shdwproj a table frame on a form and the
other table single field type view I can still use search and replace. I
just cannot do search and replace with both as table frames.

Dan

"Bertil Isberg" <bertil.isberg@NOcomhemSPAMdotse> wrote

Quote:
Dan

I can verify your GPV in all versions of Paradox since Paradox 7. If you
limit the size of the ShdwProj tableframe so only one row is showing, the
GPV does not occur.

Noone has mentioned this problem earlier, mainly because Locate and
Replace
is not a common operation, I guess.


--
Bertil Isberg - CTECH
Paradox buglist:
online: http://web.comhem.se/~u82608896/

"Dan" <megaflex (AT) bellsouth (DOT) net> skrev i meddelandet
news:44510cb5$1 (AT) pnews (DOT) thedbcommunity.com...
Bertil,
I have attached two tables linked in data model one to many and two
forms.
You can copy to your work folder in Paradox V10 to execute. The
"twotabletest.fsl" shows two table frames linked in data model. If you
try
to do a ctl-shift-z to search and replace values in the "service desc"
field
you get a GPF, error 216. If you go to the "twotabletest2.fsl" and try
the
search and replace it works fine. Any clues to why this doesn't work?

Thanks
Dan

"Bertil Isberg" <bertil.isberg@NOcomhemSPAMdotse> wrote in message
news:444e87d8$1 (AT) pnews (DOT) thedbcommunity.com...
Dan

I found the error 216 as "Service Pack #1 needs to be installed before
Service Pack #2" How do I correct this?


I'm pretty sure this is not your problem.



I found a solution on the form by deleting one of two table views on
the
form and replacing with a field. Don't understand why that would cause
a
GPF


Can you recreate this problem in a new form, I would be interested in
getting a full description of how to create such a form?

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://web.comhem.se/~u82608896/

"Dan" <megaflex (AT) bellsouth (DOT) net> skrev i meddelandet
news:444e29b8$1 (AT) pnews (DOT) thedbcommunity.com...
I found the error 216 as "Service Pack #1 needs to be installed before
Service Pack #2" How do I correct this?

I found a solution on the form by deleting one of two table views on
the
form and replacing with a field. Don't understand why that would cause
a
GPF.

Dan


"Bertil Isberg" <bertil.isberg (AT) retlifmapsSCB (DOT) se> wrote in message
news:444e21e8$1 (AT) pnews (DOT) thedbcommunity.com...
You can find a lot of causes to Genreal Protection Violations error
in
the
document Errors explained on my site - URL below.

Search the index file for Unexpected: General Protection Violation.
Note
,
there are two entries in the index.

--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply












Reply With Quote
  #7  
Old   
Bertil Isberg
 
Posts: n/a

Default Re: Search and Replace gives GPF error - 04-28-2006 , 08:52 AM



Dan
<<
I converted the shdwproj table to a single field.
Quote:
I made it a tableframe showing one row. maybe it's possible to change
the rowno property of the shdwproj tableframe when an action
DataSearchReplace is issued.


--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply


Reply With Quote
  #8  
Old   
Bertil Isberg
 
Posts: n/a

Default Re: Search and Replace gives GPF error - 04-28-2006 , 08:59 AM



This works

Customer and Orders. Both as TableFrames with 5-9 rows showing.

Add this code to Orders, the detail table, in the Action event

if eventInfo.id()=dataSearchReplace then
Customer.nrows=1
doDefault
Customer.nrows=5
endif


Now it is possible to do a Locate adn Replace in Orders. During the
operation Customer is only showing one row.


--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply

Reply With Quote
  #9  
Old   
Dan
 
Posts: n/a

Default Re: Search and Replace gives GPF error - 04-28-2006 , 04:01 PM



I can only get it to work if the cursor is on the first record of parent
table when I select ctrl-shift-z. If the cursor in on second record I get
"cannot delete objects that are in use".

Dan


"Bertil Isberg" <bertil.isberg (AT) retlifmapsSCB (DOT) se> wrote

Quote:
This works

Customer and Orders. Both as TableFrames with 5-9 rows showing.

Add this code to Orders, the detail table, in the Action event

if eventInfo.id()=dataSearchReplace then
Customer.nrows=1
doDefault
Customer.nrows=5
endif


Now it is possible to do a Locate adn Replace in Orders. During the
operation Customer is only showing one row.


--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply



Reply With Quote
  #10  
Old   
Bertil Isberg
 
Posts: n/a

Default Re: Search and Replace gives GPF error - 04-28-2006 , 04:58 PM



Dan

Ok, you'll need some more lines of code

var
nCust number
lirows longint
endvar
if eventInfo.id()=DataSearchReplace then
lirows=Customer.nrows
nCust=Customer_no ; get the current id from master table
Customer.setRange(Customer_No) ; set a range on master table to only
show this id
Customer.nrows=1 ; limit the number of rows
doDefault
Customer.setRange() ; remove the range
Customer.locate("Customer No",nCust) ; find the current id
Customer.nrows=lirows ; restore the number of rows
endif




--
Bertil Isberg - CTECH
Paradox buglist:
online: http://web.comhem.se/~u82608896/

"Dan" <megaflex (AT) bellsouth (DOT) net> skrev i meddelandet
news:445282b7$1 (AT) pnews (DOT) thedbcommunity.com...
Quote:
I can only get it to work if the cursor is on the first record of parent
table when I select ctrl-shift-z. If the cursor in on second record I get
"cannot delete objects that are in use".

Dan


"Bertil Isberg" <bertil.isberg (AT) retlifmapsSCB (DOT) se> wrote in message
news:44521fda (AT) pnews (DOT) thedbcommunity.com...
This works

Customer and Orders. Both as TableFrames with 5-9 rows showing.

Add this code to Orders, the detail table, in the Action event

if eventInfo.id()=dataSearchReplace then
Customer.nrows=1
doDefault
Customer.nrows=5
endif


Now it is possible to do a Locate adn Replace in Orders. During the
operation Customer is only showing one row.


--
Bertil Isberg
CTECH
Paradox Buglist: http://web.comhem.se/~u82608896/

remove spamfilter (reversed) to reply





Reply With Quote
Reply




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.