Just a thought - have you changed odbc driver versions recently, ie, from 3.51.18 to 3.51.19? That might also account for a sudden change in behavior.
At 11:24 PM 9/9/2007, you wrote: >MB Software Solutions wrote: > > (MySQL 5 on both Debian/internet and NT/local) > > > > Ugh...more weird behavior that I swore worked as expected before... > > > > =SQLEXEC(goconn1,"select COUNT(*) as icnt from accounts","curCntLive") > > WAIT WINDOW VARTYPE(curCntLive.icnt) > > > > For some reason, the curCntLive.iCnt field is a CHARACTER field result! > > What the heck?!? Likewise, when I do a simple predefined/default field > > numeric/integer value, it comes back as a character field as well, as > > this example proves: > > > > =SQLEXEC(goconn1,"select 1 as iselected, a1.* from accounts a1","curAccts") > > WAIT WINDOW VARTYPE(curAccts.iselected) > > > > > > I've liked working in MySQL but these little things are starting to get > > annoying. Is this something I should submit to MySQL for > > feedback/review or what would you do? > > > > tia! > > --Michael > > > > >Just tried with MySQL4 on Debian and same results. :-( Guess I'll need >to look at the OPTION value I'm using in the SQLSTRINGCONNECT to see if >that needs adjustment. I've been using 131609 forever. > > >-- >Michael J. Babcock, MCP >MB Software Solutions, LLC >http://mbsoftwaresolutions.com >http://fabmate.com >"Work smarter, not harder, with MBSS custom software solutions!" > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
