Bill, Indeed I do. I've noticed when tracing I'd get errors when queries referred to (I think) sys_tables, but I haven't had that happen with references to sys_columns, as best as I remember. I was going to say the problem command referred to sys_columns, but I forgot sys_tables is in the sub-Select (see lights coming on <g>).
I can experiment and see... but that doesn't answer the questions "why now?" and "why not under "regular" RBase?" Thanks, Ben On 6 Feb 2002, at 14:11, Bill Downall wrote: > Ben, > > In some older versions of R:Base (not just runtime), a query against > sys_columns could cause a crash if there were views in the database > that had variables in their definitions. Do you have any views where > there is a dotted variable in the view definition? (It made no difference > whether the query even referenced that view at all.) Predefining the > variables stopped the crashes. > > Bill > > On Wed, 6 Feb 2002 10:25:47 -0000, Ben Petersen wrote: > > >Larry, > > > >I found the offending statement by commenting out chunks of code, > >and by elimination came to the one statement. So I can't say with > >confidence that it actually executed. > > > >A few minutes ago it worked with a chunk of similar code > >commented out before (but that didn't happen yesterday), which > >leads me to believe that it is not the statement itself, but some odd > >combination of circumstances. There are something like 5 nearly > >successive queries against the sys_columns table in the preceding > >block of code... maybe the 5th pushed it over the edge. > > > >But, as I mentioned before, this has been in place for a long time... > >if I made any changes in this part of the code recently they were > >purely cosmetic (ie remove/add blank lines). Why it failed now, and > >why it runs fine under regular RBase would be the larger questions. > > > >Thanks, > > > >Ben Petersen > > > > > >On 6 Feb 2002, at 12:24, Lawrence Lustig wrote: > > > >> Ben: > >> > >> Was the program bombing when the code was executed, or was > the offending > >> line never even reached in the execution flow? > >> -- > >> Larry > >> > >> > >> > >> > _________________________________________________________ > >> Do You Yahoo!? > >> Get your free @yahoo.com address at http://mail.yahoo.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/ > ================================================ 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/
