How to store data from mysql query to editable array or cursor ?

[Coolprogram]

Well question is simple, how can i store data from mysql query to editable array or cursor ?

i'v tried like
SQLEXEC(P1,"SELECT * FROM zaliavosprekes WHERE pavadinimas LIKE '%"+a+"%' INTO CURSOR cOrders","afas")

 

[Olaf Doschke]

mysql should error on this, it doesn't know INTO CURSOR. You're executing mysql here not foxpro sql. If you remove that sqlexec will create a cursor on it's own, it's name will be "afas".

Read about the sqlexec() parameters and you'd know.

Bye, Olaf.

 

[Mike Lewis]

Remove the INTO CURSOR clause from your query. It's unnecessary and MySQL won't understand it.

The query should be something like this:

SQLEXEC(P1,"SELECT * FROM zaliavosprekes WHERE pavadinimas LIKE '%"+a+"%'","afas")

This will send the results to a cursor named Afas (assuming you have a variable named "a" that contains your search string).

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Coolprogram]

So how can I add data to cursor or array from mysql database ?

Thanks , best redargs

 

[Coolprogram]

I'v tried this mike , it works . But how can I use it as cursor ? As then I try to use afas i got error unknow variable

Best regards

 

[Mike Lewis]

Just treat it like any other cursor or table. For example:

SELECT afas
BROWSE
GO TOP 
GO BOTTOM
LOCATE FOR ..... [i]whatever[/i]
* Whatever else you want to do with it

Mike





__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Coolprogram]

thanks mike , problem solved