Yes I know Bill If I do it without where clause it works fine ( but in 2.11 a where clause was required) I will retest with the where clause that should actually be where aar = 1 On the two lines where I need it the rest I can do without a where clause I am sure I shall find a work around where no workaround should be needed this should work:
del rows fro transfg where kontonr is not null or kontonr is null del rows fro verfg where vernr is not null or vernr is null del rows fro ibub where kontonr is not null or kontonr is null del rows fro hbfg where kontonr is not null or kontonr is null del rows fro ibfg where kontonr is not null or kontonr is null del rows fro trans where kontonr is not null or kontonr is null del rows fro ib where kontonr is not null or kontonr is null del rows fro ub where kontonr is not null or kontonr is null del rows fro ubfg where kontonr is not null or kontonr is null del rows fro hb where kontonr is not null or kontonr is null del rows fro verifik where vernr is not null or vernr is null but it does not so I will work around the problem. But I can add I rather work around the problem In R:Base then in MS Access that some clients forested me to work with Th -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Downall Sent: den 25 november 2002 19:07 To: [EMAIL PROTECTED] Subject: RE: LINEEND Gunnar, This type of where clause, that finds every single row, was the way we had to do it in 2.11, when DELETE required a WHERE clause. Beginning with version 3.0, you could do the same thing this way: del rows fro transfg del rows fro verfg del rows fro ibub del rows fro hbfg del rows fro ibfg del rows fro trans del rows fro ib del rows fro ub del rows fro ubfg del rows fro hb del rows fro verifik It will be way faster, because it will just reset the beginning row/end row and counters to zero. It won't try to use indexes. That alone may solve your problem. It may be that you have a corrupted index. A PACK or RELOAD would also repair the indexes, and would squeeze out all the deleted space. Bill On Mon, 25 Nov 2002 18:44:45 +0100, Gunnar Ekblad wrote: >del rows fro transfg where kontonr is not null or kontonr is >null >del rows fro verfg where vernr is not null or vernr is null >del rows fro ibub where kontonr is not null or kontonr is >null >del rows fro hbfg where kontonr is not null or kontonr is >null >del rows fro ibfg where kontonr is not null or kontonr is >null >del rows fro trans where kontonr is not null or kontonr is >null >del rows fro ib where kontonr is not null or kontonr is >null >del rows fro ub where kontonr is not null or kontonr is >null >del rows fro ubfg where kontonr is not null or kontonr is >null >del rows fro hb where kontonr is not null or kontonr is >null >del rows fro verifik where vernr is not null or vernr is null ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
