Re: onstat -g sql output - host variables section

On Mar 4, 12:41 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > What makes you sure that the application is not passing the variables in the > wrong order? > Regards. > > > > > > On Thu, Mar 4, 2010 at 5:20 PM, Tom <tlow...@munis.com> wrote: > > Greetings, > > > I thought that the variables listed in the "Host variables" section > > aligned with the fields given in the "Current SQL statement" section > > located just before the "Host variables" output. But, as shown in this > > example, this does not appear to be the case. I looked at the values > > in the actual table and they do not match up. > > > Here is the onstat -g sql 113 output: > > > Current SQL statement : > >  select * from txchgdef where txchgdef.txch_mt_sw = ? and> >    txchgdef.txch_ar_cat = ? and txchgdef.txch_prop_id = ? and > >    txchgdef.txch_year = ? and txchgdef.txch_list_no = ? and > >    txchgdef.txch_chg_def = ? > > > Host variables : > >   address            type       flags > > value                                    I added this part > >   ----------------------------------------- > >   0x0700000037d08038 SMINT      0x000 1                       <-- > > txchgdef.txch_mt_sw     <-- OK > >   0x0700000037d080c8 SMINT      0x000 20                     <-- > > txchgdef.txch_ar_cat      <-- OK > >   0x0700000037d08158 SMINT      0x000 2010                 <-- > > txchgdef.txch_year         <-- Out Of Order > >   0x0700000037d081e8 INT           0x000 2144                 <-- > > txchgdef.txch_list_no      <-- Out Of Order > >   0x0700000037d08278 CHAR       0x000 020600000089E <-- > > txchgdef.txch_prop_id    <-- Out Of Order > >   0x0700000037d08308 CHAR       0x000 TAX                  <-- > > txchgdef.txch_chg_def    <-- OK > > > And here is the relevant section from a dbaccess screen that shows the > > actual values and which fields they belong to: > > > txch_mt_sw         1 > > txch_ar_cat        20 > > txch_prop_id       020600000089E > > txch_year          2010 > > txch_list_no       2144 > > txch_chg_def       TAX > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently...- Hide quoted text - > > - Show quoted text - Fernando called it. I contacted the folks who wrote the program and they changed the order of the variables during a recent update. They are fixing that now. Thanks Fernando - again. Tom