How to export a single record

Classic Servoy
1

I am wanting to export a single record, so that it can be imported into an identical offline solution running on a nearby machine.

The idea is something like:

  1. Create a txt file
  2. Write each field of the current record to it (This includes a lot of freetyped data a pdf blob field etc)
  3. Transfer it on a memory stick.
  4. Import the data at the other end.

What I cannot get my head around is how to do this with all of the standard commas, junk in the blob field etc.

Options:

  1. Will Marcels Data plugin do this?
  2. Is there an easy way to create some form of output that will not get confused by rubbish in fields and the pdf data.
  3. Is there anything in the database manager that would allow me to grab the SQL command that produces the record and therefore export it as a RAW SQL STATEMENT, then using the RAW SQL statement to import it at the other end?

Using 3.5.10.

Thanks

David

2

IN MySql (not sure about others) one can do a SQL statement such as:

SELECT <whatever> INTO DUMPFILE <dump filename>

Apparently only one row is dumped and it can have BLOB fields.
The dump filename would then be on the server so you would have to then find a way to get this filename to your user to copy.
Check google for other SQL servers.
For MySQL see: