Thanks Bernie The problem lies elsewhere I am sure I can add I hate the day when RBTI (who I love and who are my rising sun) also forbids me to use set pointer and forces me to use declare cursor Gunnar Ekblad
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bernie Corrigan Sent: den 25 november 2002 18:41 To: [EMAIL PROTECTED] Subject: EXISTS/FAILS (was LINEEND) Albert - I have had no trouble whatsoever with EXISTS/FAILS. Those keywords are all over several large legacy systems I've upgraded to 6.5++. Why do you think this would cause Gunnar's problems? As far as I know they are still supported altho not recommended. Bernie ---------------------------------------- At 12:22 PM 11/25/2002 -0500, you wrote: >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/ ================================================ 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/
