(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 -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ 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.
