Thanks Albert I alreday tried that thanks to Bill D. But I keep experimenting and hope for all the help I van get this how the code looks now: 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 still charshing out after 5 tables, better the 3 where I strted this morning Thanks again
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Albert Berry Sent: den 25 november 2002 18:22 To: [EMAIL PROTECTED] Subject: RE: LINEEND Gunnar, Exists/fails are obsolete syntax. Try the same thing replacing the clauses with WHERE kontonr IS NULL OR kontonr IS NOT NULL and see if 6.5++ still works properly "Gunnar Ekblad" <[EMAIL PROTECTED]> wrote: >I can now after one more days of testing add: > >1 I stripped the database from 60 tables to 11 > >2 taken away all rules and indexes > >3 Stripped my commandfile from 225 lines to 15 > >4 This is how the stripped commandfile looks: > >DISC >SET MULTI OFF >CON GL >del rows fro transfg � � � � � � �where kontonr exi or kontonr fails >*(transaction previous year deleted based on accountnummber) >del rows fro verfg � � � � � � � �where vernr exi or vernr fails >del rows fro ibub � � � � � � � � where kontonr exi or kontonr fails >del rows fro hbfg � � � � � � � � where kontonr exi or kontonr fails >del rows fro ibfg � � � � � � � � where kontonr exi or kontonr fails >del rows fro trans � � � � � � � �where kontonr exi or kontonr fails >del rows fro ib � � � � � � � � � where kontonr exi or kontonr fails >del rows fro ub � � � � � � � � � where kontonr exi or kontonr fails >del rows fro ubfg � � � � � � � � where kontonr exi or kontonr fails >del rows fro hb � � � � � � � � � where kontonr exi or kontonr fails >del rows fro verifik � � � � � � �where vernr exi or vernr fails > >5 The database tables contains between 25 rows and 2000 rows > >6 Executed in win version of 6.5++ No problem > >7 Executed in DOS version 1.851 (or the beta for patch 3) it either hangs or >crushes (where seems to vary a little depending on order of lines in >commandfile (are I sick or something)) > >8 If I take away the where clauses it execute ok even in dos > >9 In real life I need the where clause only on 2 lines the rest of where >clauses is because 2.11 required a where clause > >10 I am convinced that 99 times out of 100 if a commandfile does not work it >is because of me is this case 100? > >11 I am still puzzled by lineend but do not any longer believe it causes any >harm > >12 If it is not apparent the app is GL-General Ledger handling previous year >current year and next year and this is the stripped version of yearly >rollover. > >13 Am I the only one on DOS version left since it been so quit or are US not >waked up yet and Australia already in bed? > >I hope 13 point on this does not mean bad luck in answer > >Gunnar asking for understanding > > > > > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/ ================================================ 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/
