MySql to VFP cursor

[Claudio Costa]

Hi again.

Im trying to get the rows from an MySql Select to a VFP cursor but all I get is an result.

Im using VFP 9 and MySql ODBC 8.0 Ansi driver

My code:

SQLEXEC(gnConnHandle,'SELECT referencia FROM artigos','abc')

SELECT abc

browse

but what i get is this :

 

[Chriss Miller]

Well, you ignored what I said and just listened to Tore plus assume getting a connection handle already proves a driver works.

I'm serious here, the driver you use must be changed. You can of course create a DSN, but the final truth about a driver working is with actively working on data in all ways.

We invested quite some time in the threads I found and you disregard that all as irrelevant.

 

[Chriss Miller]

Here for reference:

Running SQLEXEC on MySQL Database -- Continued... - Microsoft: FoxPro

Hello All, In reviewing a prior thread (https://www.tek-tips.com/viewthread.cfm?qid=1829136), it seems as though I have a very similar dilemma. The primary difference is that I'd prefer not to utilize outdated ODBC connectors due to vulnerability concerns. I'll quickly recap below: MySQL...

www.tek-tips.com

Mysql Connection String using latest driver - Microsoft: FoxPro

Hi all I am using Mysql as backend database for my applications the Mysql ODBC Connector version 3.51 (32 bit) is installed on my system and I give the connection string as below connection_string="DRIVER={MySQL ODBC 3.51 Driver};SERVER=" + m_server + ";port=3306;UID=" + m_uid + ";PWD=" +...

www.tek-tips.com

 

[Pieter Koemans]

Hi again.

Im trying to get the rows from an MySql Select to a VFP cursor but all I get is an result.

Im using VFP 9 and MySql ODBC 8.0 Ansi driver

My code:

SQLEXEC(gnConnHandle,'SELECT referencia FROM artigos','abc')

SELECT abc

browse

but what i get is this :

In addition to Chris, you can also try the Mariadb 3.1 driver, works fine with VFP and i think released in 2023

 

[Chriss Miller]

Yes, I pointed out MariaDB Drivers may work, too in the other thread.

Im using VFP 9 and MySql ODBC 8.0 Ansi driver

Since you say that the question now is which one. Assuming you indeed installed 8.0.33 the question that's most relevant is what data type the referencia column of the artigos table is and what you get from SELECT Count(*) from artigos.

 

[Chriss Miller]

By the way: It doesn't suffice to install the correct driver. If you still use SQLCONNECT('WebBrowser', 'root', 'mysql') and didn't define a new DSN or changed the configuration of the WebBrowser DSN you already have to use the 8.0.33 driver, then you still get the same erroneous behavior. How is your DSN configured?

 

[Claudio Costa]

The connection is ok , I can insert rows in the mysql table.

Its just the Select that is not given de results.

 

[Tore Bleken]

I don't use MySql myself, so I am not quite sure about the syntax. Could it be that you need to add a Where clause? Something like

SELECT referencia FROM artigos Where 1=1