To all who tried to help on this one the code now looks like del rows fro trans where aar = 1 del rows fro transfg del rows fro verfg del rows fro ibub del rows fro hbfg del rows fro ibfg del rows fro ib del rows fro ub del rows fro ubfg del rows fro hb del rows fro verifik where aar = 1
and works ok even if I still do not understand why some of the previous ones did not work with where clauses in 2.11 syntax that where perfectly executed at R:Prompt. My own conclousion for this is I better stop using the DOS version and concentrate on win 7.0 soon to come Thanks for all tips -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bernie Corrigan Sent: den 25 november 2002 18:47 To: [EMAIL PROTECTED] Subject: RE: LINEEND Gunnar - The problem with your code is your abbreviations. EXI can mean EXISTS, EXIT, or EXITFORM. The interpreter can't differentiate that you want it to mean EXISTS. The last I heard ESP wasn't built in, yet. Bernie ---------------------------------------- At 05:15 PM 11/25/2002 +0100, you 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 > > > > > > >Attachment Converted: C:\NE\winmail.dat > ================================================ 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/
