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.



Options: ReplyQuote

Written By
December 01, 2009 08:44PM
Re: Urgent HELP!!!!
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.