Thanks Tony,
Made no difference.
Ben Petersen
On 6 Feb 2002, at 6:24, Anthony Schmidt wrote:
>
> Eric:
>
> You can also try including an Indicator variable in your "Select Into"
> syntax. The different versions of R:Base/RunTime all react differently when
> you don't use an Indicator variable.
>
> Tony
>
>
>
>
> |---------+---------------------------->
> | | owner-rbase-l@son|
> | | etmail.com |
> | | |
> | | 02/05/2002 06:24 |
> | | PM |
> | | Please respond to|
> | | rbase-l |
> | | |
> |---------+---------------------------->
>
>>----------------------------------------------------------------------------------------------
-----------------------------------------------|
> |
>
|
> | To: [EMAIL PROTECTED]
>
|
> | cc: (bcc: Anthony Schmidt/BayShore/SGU_LN)
>
|
> | Subject: Re: RunTime Problem
>
|
>
>>----------------------------------------------------------------------------------------------
-----------------------------------------------|
>
>
>
>
>
> Ben, (feels a little like talking to myself again... <g>)
>
> Since I'm referring to a literal column name and literal table name
> only one value can be returned, thus the "=". Error checking on the
> next line would pick up, serendipitously, a "too many values
> returned" error if somehow there were two tables with the same
> name or one table with two columns of the same name.
>
> My general concern is that this has worked fine for a year and a
> half. The app has been reconstructed and re-codelocked many
> times during that time. Twice before I've had code stop working for
> no apparent reason under RunTime (on _certain_ machines) with
> codelocked files, and inserting some placebo like code in front of it
> solved the problem. If I understood what caused it to happen it
> would be a lot easier to take. OK, I'll stop whining now.
>
> Thanks,
>
> Ben (there I go again... oh,... no that is me, right??? <g>)
>
>
>
> On 5 Feb 2002, at 21:12, Ben Johansen wrote:
>
> > Hi Ben,
> >
> > I normally use "in" preceding a sub-select...
> >
> > One of the other Ben's ;-)
> >
> > ----- Original Message -----
> > From: "Ben Petersen" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, February 05, 2002 11:58 AM
> > Subject: Re: RunTime Problem
> >
> >
> > > Eric,
> > >
> > > I found the code segment that is the problem. It is actually
> > > obsolete at this point, it began a routine for a database
> > > modification. Has been included in the app since 8/24/2000
> > > according to my notes. I ran it against 3 other databases with
> > > identical schemas used by other customers with the same results.
> > >
> > > Sel count(sys_column_name) into zCt +
> > > from sys_columns +
> > > whe sys_Column_Name = 'I' +
> > > and Sys_Table_ID = +
> > > (sel Sys_table_ID fro sys_Tables +
> > > whe Sys_Table_Name = 'DuesSched')
> > >
> > >
> > > Ben Petersen
> > >
> > > On 5 Feb 2002, at 21:44, Eric M. Bienstock, Ph.D. wrote:
> > >
> > > > |.... There are no commands in these files that are _explicitly_ not
> > > > | supported under runtime, and as best as I can tell it's crashing in
> > > > | an early part of the app (prior to the first menu)
> ..................
> > > > ==========================================
> > > >
> > > > Ben,
> > > > Post the code here.
> > > >
> > >
> > >
> --------------------------------------------------------------------------
> > -
> > > > Eric M. Bienstock, Ph.D.
> > > > Database Development, etc.
> > > > Authorized R:BASE Developer
> > > > Eric M. Bienstock & Associates, Inc.
> > > > day: 212-978-7948 eve: 973-763-8650(8)
> > > > FAX: 209-882-9250 [EMAIL PROTECTED]
> > > > http://members.home.net/ericmb/Ericmb.htm
> > >
> > >
> --------------------------------------------------------------------------
> > -
> > > >
> > > > ----- Original Message -----
> > > > From: "Ben Petersen" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Tuesday, February 05, 2002 12:52 PM
> > > > Subject: Re: RunTime Problem
> > > >
> > > >
> > > > | Eric,
> > > > |
> > > > | The customer is running RTW 6.5+... I mistakenly sent files
> > > > | codelocked under 6.1a the first time, did the
> slap-my-forehead-with-
> > > > | heal-of-hand thing <g> and sent again codelocked under 6.5+, to
> > > > | no avail. I use RClass to assemble my command files for
> > > > | codelocking, and it automatically deletes previous apx files. As
> > > > | well, I have it set to strip comments from command files before it
> > > > | generates the APP files.
> > > > |
> > > > | > If it runs under regular R:BASE but crashes under Runtime,
> > > > | > then the fault is probably some command that Runtime does
> > > > | > not support.
> > > > |
> > > > | There are no commands in these files that are _explicitly_ not
> > > > | supported under runtime, and as best as I can tell it's crashing in
> > > > | an early part of the app (prior to the first menu) which has been
> > > > | running under runtime for a couple years now. As well, it runs fine
> if
> > > > | traced under runtime.
> > > > |
> > > > | Thanks,
> > > > |
> > > > | Ben
> > > > |
> > > > |
> > > > | On 5 Feb 2002, at 20:12, Eric M. Bienstock, Ph.D. wrote:
> > > > |
> > > > | > |... I codelocked an application today, sent it to a
> > > > | > | customer, and got an exception error upon starting it up...
> > > > | > ==========================================
> > > > | >
> > > > | > Ben,
> > > > | >
> > > > | > I've always found that it's important to Codelock with the same
> > version
> > > > you
> > > > | > plan to run the APX. Also, be sure to delete the previous APX
> prior
> > to
> > > > | > creating a new one.
> > > > | >
> > > > | > If it runs under regular R:BASE but crashes under Runtime, then
> the
> > > > fault is
> > > > | > probably some command that Runtime does not support.
> > > > | >
> > > > |
> > > >
> > >
> --------------------------------------------------------------------------
> > > > -
> > > > | > Eric M. Bienstock, Ph.D.
> > > > | > Database Development, etc.
> > > > | > Authorized R:BASE Developer
> > > > | > Eric M. Bienstock & Associates, Inc.
> > > > | > day: 212-978-7948 eve: 973-763-8650(8)
> > > > | > FAX: 209-882-9250 [EMAIL PROTECTED]
> > > > | > http://members.home.net/ericmb/Ericmb.htm
> > > > |
> > > >
> > >
> --------------------------------------------------------------------------
> > > > -
> > > > | >
> > > > | > ----- Original Message -----
> > > > | > From: "Ben Petersen" <[EMAIL PROTECTED]>
> > > > | > To: <[EMAIL PROTECTED]>
> > > > | > Sent: Tuesday, February 05, 2002 11:49 AM
> > > > | > Subject: RunTime Problem
> > > > | >
> > > > | >
> > > > | > | Hi all,
> > > > | > |
> > > > | > | I'm stuck. I codelocked an application today, sent it to a
> > > > | > | customer, and got an exception error upon starting it up. Tried
> it
> > on
> > > > | > | my desktop under runtime (RBW6.5+) and got the same result.
> > > > | > | They are running Win98 and I'm using NT4 server.
> > > > | > |
> > > > | > | I tried codelocking under both 6.1a and 6.5+ with the same
> result.
> > > > | > | Runs fine under single-user and if I trace under Runtime. The
> odd
> > > > | > | part is that the changes made between versions of the app are
> > > > | > | fairly deep in the app, and this is crashing, it appears, right
> > after
> > > > | > | connecting to the DB.
> > > > | > |
> > > > | > | I'm a little desperate as several customers are waiting for
> this
> > > > | > | update... any suggestions would be very much appreciated.
> > > > | > |
> > > > | > | tia,
> > > > | > |
> > > > | > | Ben
> > > > | > | ================================================
> > > > | > | 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/
> > > >
> > >
> > >
> > > ================================================
> > > 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/
>
================================================
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/
