Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-17 Thread MB Software Solutions
Steve Ellenoff wrote: > The options field value is using bit flags... so just break the > option # you are using into it's proper pieces for each bit value. > > 131609 = 131072+512+16+8+1 > > This is equivalent to a number where the bits 17,9,4,3,0 are set. > > Looking at the MyODBC reference this

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-17 Thread Steve Ellenoff
The options field value is using bit flags... so just break the option # you are using into it's proper pieces for each bit value. 131609 = 131072+512+16+8+1 This is equivalent to a number where the bits 17,9,4,3,0 are set. Looking at the MyODBC reference this is equivalent to: FLAG_SAFE + FLA

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-13 Thread MB Software Solutions
Eugene Vital wrote: >>> This is the specific setting that affects it. >>> >>> 16384 |FLAG_NO_BIGINT|Change BIGINT Columns to IntChange >>> |BIGINT| >>> columns to |INT| columns (some applications can't handle |BIGINT|). >>> >>> >>> >>> >> I just wish it were easy

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-12 Thread Eugene Vital
MB Software Solutions wrote: > Eugene Vital wrote: > >>> Don't remember, been using it for years...here is a complete reference >>> for the ODBC connection parameters. >>> http://dev.mysql.com/doc/refman/5.1/en/myodbc-configuration-connection-parameters.html >>> >>> >>> >> This i

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-12 Thread MB Software Solutions
Eugene Vital wrote: >> Don't remember, been using it for years...here is a complete reference >> for the ODBC connection parameters. >> http://dev.mysql.com/doc/refman/5.1/en/myodbc-configuration-connection-parameters.html >> >> > > This is the specific setting that affects it. > > 16384

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-12 Thread Eugene Vital
Eugene Vital wrote: > MB Software Solutions wrote: > >> Eugene Vital wrote: >> >> >>> Michael, >>> >>> The answer is in the connections string! 8-) >>> >>> LOCAL lcSQLConStr as String ,; >>> liSQLHandle as Integer >>> >>> >>> * this connections string gives the desired results >>

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-12 Thread Eugene Vital
MB Software Solutions wrote: > Eugene Vital wrote: > >> 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 >> Driv

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-12 Thread MB Software Solutions
Eugene Vital wrote: > 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;PASS

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-12 Thread Steve Ellenoff
When you figure out which flag it is, please post back the answer. I don't recall seeing any flag that should have made this happen. -Steve At 06:54 PM 9/11/2007, you wrote: >Eugene Vital wrote: > > Michael, > > > > The answer is in the connections string! 8-) > > > > LOCAL lcSQLConStr as String

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-11 Thread MB Software Solutions
Eugene Vital wrote: > 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;PASS

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-11 Thread Steve Ellenoff
Go to the drivers tab, scroll down to the bottom, and look for the MyODBC 3.51 entry, there you can see the full revision #. At 09:17 PM 9/10/2007, you wrote: >Steve Ellenoff wrote: > > Just a thought - have you changed odbc driver versions recently, ie, > > from 3.51.18 to 3.51.19? That might al

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-10 Thread MB Software Solutions
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. > > I don't think I have...where do I find the revision number? My ODBC control panel screen only shows 3.51. --

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-10 Thread Eugene Vital
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"

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-10 Thread Steve Ellenoff
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 behavi

Re: MySQL COUNT(*) comes back as Character field result in VFP9

2007-09-09 Thread MB Software Solutions
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