I don't know for sure what is (not) going on.
A couple of thoughts:
1. I recall that there is some subtle difference between executing
onBeforeDataObjectEvent at the page level, and between onBeforeExecuteEvent
on the data object itself. Perhaps the page-level event executes before
criteria are automatically set (just a guess). In the absence of other
suggestions, you might try moving the code from the page to the DO and see
if there is any difference.
2. I see that you are not using the reference to the data object that is
contained in the event (available via getSource). I always think it is
less error-prone to do it that way, as you are assured that you have a
reference to the object that is causing the event. To eliminate any
question, I would suggest something like:
CSpMultiSQL doSrc = (CSpMultiSQL) event.getSource();
CSpLog.send(this, CSpLog.ERROR, " this_onBeforeExecuteEvent for
DO: "+doSrc.getName());
Don't know if this helps at all, but it's all I can think of.
-- Curt
At 10:29 AM 8/6/99 -0500, Roger Feeley wrote:
>Hi Curt,
>
>Thanks for the response.
>
> > is it that neither log message below is actually written?
>Both log messages are written but there is nothing in between.
> >
> > If so, then either the query type is not 'select' when this method
> > executes, or the method is not executing when you expect it to.
> >
> > Are you sure that the DO is bound at the page (top) level?
>Yes. The whole reason for this exercise is to modify 4 Sybase servers from
>one keyclick. The way I do this is to catch the transaction in
>onBeforeExecuteEvent and then spread it to 4 other data objects. I have to
>do this in different ways. For a delete, I simple extract the primary key
>field/s, construct the delete SQL and do executeImmediates to 4 data
>sources. For Inserts and updates, things get a bit more complicated. What
>I do is what I call a "brain transplant". I transfer every field from this
>data object to 4 other data objects which I then execute appropriately.
>
>All of this is working just fine. The thing I am trying to correct is a
>simple problem where the user wants to change what amounts to the primary
>key. Since we have no indexes on this table, it is entirely possible in SQL
>to do this. ND wants to use the new key in the dynamic criteria (not
>unreasonable). What I intended to do was simply save off the dynamic
>criteria in a user session object and then restore it later (just for
>updates).
> >
> > I don't use bound data objects, but I recall that if the DO is bound to a
> > repeated on the page, the only method that would fire would be
> > repeated_onBeforeExecuteEvent, not this_..... .
> >
>No repeated. On this page we are displaying a single record in free form.
>The data object is returning a single record. The equivilent in SQL would
>be, "Select * from TR_Labels_TIF where Bridge_Symbol = 'us;ibm' ". My user
>may want to change us;ibm to us;ibm1.
>
>
> > -- Curt Springer,
> > Team ND
> >
> >
> >
> > At 06:56 PM 8/5/99 -0500, Roger Feeley wrote:
> > >I just know that I have done something stupid. I have a data object and
>I
> > >want to retrieve the dynamic criteria and store it in a user data session
> > >object. For some reason, I come up blank. The log tells me nothing
>other
> > >than I didn't retrieve anything. bStr comes up null. Any ideas?
> > >
> > >public int this_onBeforeExecuteEvent(CSpDataObjectEvent event)
> > > {
> > > CSpMultiSQL doDest;
> > >
> > > if(getExecutingQueryType() == SELECT_QUERY_TYPE)
> > > {
> > > CSpString bStr;
> > > CSpMultiSQL doSrc = (CSpMultiSQL)CSpider.getDataObject
> > >("doTIF_Edit");
> > > CSpLog.send(this, CSpLog.CRITICAL, "*****getting dynamic criteria
>=");
> > > bStr = new
> >
>SpString( doSrc.getDynamicCriteria(CSpCriteriaSQLObject.JOIN_CRITERIA_TYPE))
> > >;
> > > CSpLog.send(this, CSpLog.CRITICAL, "*****dynamic criteria =" +
>bStr);
> > > CSpider.putUserSessionObject("sDynamicCriteriaSave", bStr);
> > > return (PROCEED);
> > > }
> > >
> > >
> > >
> > >_________________________________________________________________________
> > >
> > >For help in using, subscribing, and unsubscribing to the discussion
> > >forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
> > >
> > >For dire need help, email: [EMAIL PROTECTED]
> >
>
>
>_________________________________________________________________________
>
>For help in using, subscribing, and unsubscribing to the discussion
>forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
>For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
