Re: Search and Replace gives GPF error



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@xxxxxxxxxxxxxxxx> wrote in message
news:44521fda@xxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.



Relevant Pages

  • Re: SP Question
    ... less overhead than a cursor. ... > Hi, Hari ... >> First record you can retrive using TOP clause in select statement. ... You need to use cursor with FETCH LAST. ...
    (microsoft.public.sqlserver.server)
  • Re: select mline returns truncated values
    ... > SELECT MLINEFROM zoot WHERE SelectMe ... Look at the structure of your cursor. ... This is what VFP does - it evaluates the first record in the ... > the first record is not included in the output set, ...
    (microsoft.public.fox.programmer.exchange)
  • select mline returns truncated values
    ... CREATE CURSOR zoot ... SELECT MLINEFROM zoot WHERE SelectMe ... The filter on SelectMe proves this, as the first record is not included ...
    (microsoft.public.fox.programmer.exchange)
  • Re: wm5 contact list default with name
    ... you can still accomplish this by highlighting the contact name and using the left/right cursor to select the default number/method to contact the contact. ... Noticed also that after you "find" a contact using the filter, where the app used to leave that record as the entry point, as soon as you clear the filter, it goes back to the first record in the database... ...
    (microsoft.public.pocketpc)
  • Trying to avoid using a cursor....
    ... it without resorting to a cursor. ... to run an procedure that will take the value of that first record in column ... move through the records one by one, but I've read often in this forum that ...
    (microsoft.public.sqlserver.programming)