Hi Brent, I haven't run into this particular problem before myself, but I would like to suggest that maybe you just build your "SQL statement" as a <@VAR just before the DBMS Action. Something like:
<@ASSIGN local$temp_sql VALUE="<@if blah> sel count(*)...... <@else> sel count(*) ....... </@if>"> And then just put the following in your DBMS Action <@VAR local$temp_sql ENCODING=NONE> I do it this quite regularly because I don't like the small text in the Action window (I'm an old guy, eh). And this way no "extra" logic needs to be executed inside the DBMS Action at runtime, because the SQL "logic" was executed during the variable assignment before hand. Note: If you need double-quotes inside your SQL assignment, then use <@DQ> so that the assignment doesn't break. Hope this helps. Cheers..... Scott Cadillac ----- Original Message ----- From: "Brent Skean" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 10:27 AM Subject: Re: Witango-Talk: tango tags within DBMS actions > The strange one we've come across is a dbms with <@if></@if> > > This dbms works perfectly for 100's/1000's of iterations, then mysteriously, > the sql will fail for a single time and then go on and work perfectly... > > our error checking shows the sql is perfectly formed. > > I am wondering if there is a timing conflict between tango and the odbc > driver. > > in our other "pure" sql, there are no tango metatags (just vars) and we > never have a problem. > > but in dbms that has <@if>, we've identified at least 2 cases where the dbms > has failed (even though the debug showed no problem with the sql... we can > cut/paste it and it works fine), while working properly 99.99999 majority > of the time. > > the sql is doing a simple count of records, nothing esoteric... it sure > looks like the <@if> is the culprit. > > > <@if blah> > sel count(*)...... > <@else> > sel count(*) ....... > </@if> > > I am thinking we need to move the <@if> back out to tango action level, not > keep them in the dbms. > > Anyone else have any similiar experience? > > Brent Skean > Current Solutions > > > -----Original Message----- > From: Anthony M. Humphreys <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Tuesday, February 11, 2003 7:51 AM > Subject: RE: Witango-Talk: tango tags within DBMS actions > > > >Often it's because of a typo in a tag, > > or else a mis-matched tag pair, ie a @IF without a /@IF > > or else an array is expected and the var is not an array or is empty > > > >Sometimes it's a bugger to find... > > > > > > > > > >-----Original Message----- > >From: Atrix Wolfe [mailto:[EMAIL PROTECTED]] > >Sent: Monday, February 10, 2003 7:32 PM > >To: [EMAIL PROTECTED] > >Subject: Witango-Talk: tango tags within DBMS actions > > > > > >does anyone have any idea why tango tags within DBMS actions would stop > >being processed? Im wondering if we tweaked a setting somewhere... > > > >thanks for the help! > >Atrix > >________________________________________________________________________ > >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > >________________________________________________________________________ > >TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
