Copy record

[hornetster]

I am rather a newbie here, (databases in general - openbase & mysql...) I have a database (mySQL with an ODBC connection - Windows server 2003) that imports information into a table on a semi regular basis. I know that when it is imported, a small number (20 or so) will always have a couple of the fields incorrect. I have edited the initial import, so the records are correct, and copied to another table.
Is there a way to copy a whole record from one table, to overwrite a record in another table? Initially looking at doing this manually, but perhaps then creating a macro to do it.
At the moment, I cannot find a way to copy a whole record - using the copy option in openbase just seems to copy the currently selected field, even if the whole record is selected.....

[r4zoli]

I cannot answer your really question. I know that connecting to MySQL with 3.5.1 ODBC driver not so stable, as 5.1 ODBC, I suggest use JDBC driver instead.

[QuazzieEvil]

you can do it with the rowset service. I have some docs at http://www.geocities.com/rbenitez22 that show you how to use the row set serivce.

Also, I believe there is an example in the code snipets sub forum that does exactly that--you may want to look at the also/first-->
http://user.services.openoffice.org/en/ ... =45&t=1169

hope that helps.

[DrewJensen]

Also by using using standard SQL commands either in the SQL window or in a script.