Moving data from VFP to MySQL

[StewartUK]

I am planning a move my data from VFP to MySQL.

I have a VFP table of flags (which can be applied to contacts' records to show what they are interested in and so on) in which I have a field called AfterApply.

This field's default value is a parameter statement. In several records I have written in code to do other things when that flag is applied. Every time any flag is applied, the following line executes : EXECSCRIPT(AfterApply, Ik, ThisMany, Began, tdEnds)

Can you give me some advice on the best way to implement this in the MySQL world?

Thanks,

Stewart

 

[bborissov]

Does MySQL has triggers?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[StewartUK]

Borislav,

Yes, it does.

I've tried to think of how I'd use them in this instance. Where I might want to insert an additional record would be straightforward, but how would I, for instance, get an email sent? Maybe return "something" to the UI?

Thanks,

Stewart

 

[jdhilljr]

I had set up a fax interface utility from VFP to a mysql table using a connection string via the mysql ODBC driver. I just used a remote view in the VFP application and grabbed the parameters from the mysql table when it was triggered by the server. You could always use it as a utility on a timer also. Not sure if this will help with what you are doing.

If you can't stand behind your troops, stand in front of them.
Semper Fidelis

Jim