Re: WARNING:Latest 4GL+Online buggy
Posted in 1999
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
From: David Williams <djw@smooth1.demon.co.uk> > > > LET my_str = "select a,b,c from t1" > ^^^^^^^^^^^^^^^^^^ > 1 2 > 12345678901234567890 characters > PREPARE x FROM my_str > IF my_flag = "Y" THEN > apply monetary discount to the job > END IF > > AFTER THE prepare > > my_str = "select a , b , c , d from t1" > 1 2 > 123456789012345678901234567 characters > ^ > memory space for my_flag now " " > > Hence suddenly after the prepare my_flag becomes " " and the discounts > are not applied. Hence the costs sent to the account system are wrong > and the client invoices customers wrong or calculates their internal > costs wrong and management reporting figures are wrong. (This could > put the customer out of business!). WHAT? Are you saying that the prepare changes variable sizes? Gee whiz, that's pretty bad. I'd expect it to cause truncation of the string, but not overwriting another variable. That's pretty bad... :-( ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
In article <7ump66$qog$1@news.xmission.com>, Obnoxio The Clown <obnoxio@hotmail.com> writes > >WHAT? Are you saying that the prepare changes variable sizes? Gee whiz, >that's pretty bad. I'd expect it to cause truncation of the string, but not >overwriting another variable. That's pretty bad... :-( > Yep! Ouch. UK Tech Support are on the 'case' though! Watch this space. >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com -- David Williams