Re: Urgent HELP!!!!
Posted by: Martin Pirringer
Date: December 20, 2009 10:55AM

first a question... Why not use foxpro directly to send the data?

The above sub has a lot missing so here is just some basic instructions

1.) Open the OLEDB connection to Foxpro
2.) execute the select statement on the foxpro tabel
3.) Load the result into a local cursor
4.) open the MYSQL connection
5,) Loop through the cursor and for each row create a properly formated MYSQL INSERT statement and send it to MYSQL
Something like "INSERT INTO dept ('" + fieldneme1 + "', '" + fieldname2 + ') VALUES('" + fieldvalue1 + "'. '" + fieldvale2 + "')" etc
Then send each one of those rows to the server.

This should work as long as you do not violate any other MYSQL rules like uniqueness of a key field or foreign keys etc.

HTH

Martin
f

Options: ReplyQuote


Subject
Views
Written By
Posted
8979
December 01, 2009 08:44PM
Re: Urgent HELP!!!!
3798
December 20, 2009 10:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.