Michael,
The answer is in the connections string! 8-)
LOCAL lcSQLConStr as String ,;
liSQLHandle as Integer
* this connections string gives the desired results
lcSQLConStr ="DRIVER=MySQL ODBC 3.51
Driver;SERVER=MYSERVER;DATABASE=im;USER=MYUSER;PASSWORD=MYPASSWD;PORT=3306;OPTION=16899"
* this connections string gives the behavior you described
lcSQLConStr ="DRIVER=MySQL ODBC 3.51
Driver;SERVER=MYSERVER;DATABASE=im;USER=MYUSER;PASSWORD=MYPASSWD;PORT=3306"
liSQLHandle = SQLSTRINGCONNECT( lcSQLConStr)
IF liSQLHandle > 0
SQLEXEC(liSQLHandle,"select COUNT(*) as icnt from log","curCntLive")
WAIT WINDOW VARTYPE(curCntLive.icnt)
SQLDISCONNECT(liSQLHandle)
ENDIF
Steve Ellenoff wrote:
> 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.
