Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Claudio Costa

  1. C

    MySql to VFP cursor

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

    MySql to VFP cursor

    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 :
  3. C

    SQLEXEC crashes VFP

    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
  4. C

    SQLEXEC crashes VFP

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

    SQLEXEC crashes VFP

    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
  6. C

    SQLEXEC crashes VFP

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

    SQLEXEC crashes VFP

    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')...

Part and Inventory Search

Back
Top