Steve
OK, now I can tell you the down side of the second method - since you making
structural changes to the table in question as well as deleting rows, you
need to add some code to LOCK the table because in a multi-user setting the
DROP and CREATE commands could fail if another user is attempting to add,
delete or update rows in the table in question.
SET VAR gError INTEGER = NULL
SET ERROR VAR gError
LABEL LockTable
SET LOCK tablename ON
IF gError <> 0 THEN
DIALOG 'This process requires exclusive access to the table xxxxx, but +
others are using the table. Do you want to try again now?' vAnswer vKey
IF vAnswer = 'Yes' and vKey <> '[Esc]' THEN
GOTO LockTable
ELSE
GOTO EndFile
ENDIF
ENDIF
-- now the code to drop indexes, delete rows and recreate indexes
LABEL EndFile
SET LOCK tablename OFF
CLE VAR etc...
David
David Blocker
[EMAIL PROTECTED]
781-784-1919
Fax: 781-784-1860
Cell: 339-206-0261
----- Original Message -----
From: "Steve Breen" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, April 26, 2005 10:08 PM
Subject: [RBASE-L] - Re: Deleting row question
>
>
> David,
>
> The second method is faster by far.
>
> It seems that the more rows that are deleted the slower it gets. Ran the
> second option first and it just flew thru the process the second one is
> running now and it is going to hours.
>
> I am just going to have to stop it.
>
> Will use the new concept
>
>
> Thanks David and Razzak
>
>
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
