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/
