VFP Label + MySQL

[Yosua]

Hi,
I'm looking for a tutorial on how to create label with MySQL table, but I found nothing on the Google. So I believed this forum is a good start.
Can anyone tell me how to create label with MySQL table?

Thanks

 

[JRB-Bldr]

how to create label with MySQL table

Let's start with the basics...

You can use VFP to get a record set (one or more records) from a data table within a MySQL Database by issuing the appropriate SQLEXEC() command after having established a Connection to the MySQL Database.

If you already know how to do that, great.
If not, then begin by studying how that is done.

Then, once you have the record set meeting your desired criteria, into a VFP Cursor, you can use it to send to a VFP Label Form.

Good Luck,
JRB-Bldr

 

[Yosua]

Hi JRB-Bldr,
Yes, I know the basic SQLEXEC(), but how to put it into VFP Label writer?
I've made a cursor for the SQLEXEC() but I can't find it in the Expression (Field Properties).

 

[fluppe689]

hello Yosua

how is your sqlexec statement.
when you have a cursor file for example

sql = "select * from dbo...."
retcode = sqlexec(handle,sql,"t_label")
if retcode > 0
select t_label
go top
count to m.i
if m.i > 0
select t_label
go top
*** then do this
suspend
***** the program wil suspend en you can create a new label from the foxpro menu new file choose label

endif
select t_label
use
else
wait window "not a good connection"
endif


when the label is made you ommit the supend statement

That is the way I always to it.
I hope this can help you

Filip

 

[Mike Lewis]

I've made a cursor for the SQLEXEC() but I can't find it in the Expression (Field Properties).[/qupte]

You need to be sure that the cursor exists while you are working in the label designer. And also, it must be in the current work area.

Alternatively, just type the field names by hand in the expression dialogue. Presumably, there are only a few fields in the label, and you know all their names, so it shouldn't be a problem. Provided the cursor exists when you run the labels, it should work fine.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Yosua]

Thanks fluppe, Mike
So it should be fine when I run it, even when the cursor is not listed in expression.
Thanks for your time

 

[Mike Lewis]

So it should be fine when I run it, even when the cursor is not listed in expression.

Exactly. The expression builder is only for your convenience, to save you typing the field names. But it's also OK to type the field names if the cursor isn't available at that time.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Yosua]

Then I'll do it manually. Thanks Mike