Recent content by Claudio Costa

Im with Fox for several years , but Im newby with MySql, MariaDB. I was using tinytext on text fields, now that Ive changed to char is returning ok. Thanks everybody for your help and patience.

Hello. the fields size in MariaDb are 20 and 50 characters , so they should appear ok in VFP , right ? Edit : I changed the fields in MariaDB to char type and now its working ok !

And where I put the SELECT CAST line ? in the SQLEXEC ? sorry , im a newby in MySql / MariaDB.

Hi again. Im using an MariaDb database with VFP but when doing a select the query is returning memo fields instead of strings. The numeric fields are returned ok. So , whats going on ?

Thanks for your help Miller , I appreciate it.

The connection is ok , I can insert rows in the mysql table. Its just the Select that is not given de results.

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 :

Thank you Bleken ! I changed Select * From to Select just one field and it works . Now I got to learn how to fill a grid with the sql result

Just discover that QLEXEC(gnConnHandle,'INSERT INTO works fine. Whats the problem with select * from ??

I dont understand. SQLCONNECT('WebBrowser', 'root', 'mysql') TO gnConnHandle works , the connection is made it returns > 0 however SQLEXEC(gnConnHandle, 'SELECT * FROM artigos', 'mapa') crashs VFP

it crashs in the SQLEXEC(gnConnHandle, 'SELECT * FROM artigos', 'mapa') line so I cant get any error list :(

My code: STORE SQLCONNECT('WebBrowser', 'root', 'mysql') TO gnConnHandle IF gnConnHandle <= 0 = MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error') ELSE = MESSAGEBOX('Connection made', 48, 'SQL Connect Message') SQLEXEC(gnConnHandle, 'SELECT * FROM artigos', 'mapa')...