Thank you everyone. You have saved my project! (I am porting an old Paradox database over to OpenOffice. A database I actually NEED... and I've been nervous for some time about how much longer I'm going to be able to get Paradox to work, as Mr Gates' monster continually "improves" Windows.)
While I still long for the NICE, SIMPLE "export to .csv" that Paradox (and MySQL! (Yes. I know that Base can be used for a MySQL front end!) offer, the work-arounds suggested by the posters above WORK! (And I managed to get past all the "gotchas" that I manage to find, when trying to follow instructions.)
All that follows is just my "blow by blow" exposition of what they suggested, filled out with guidance for the next person on where I went wrong trying to implement the suggestions.
(I'd still like to know what "Save All" SHOULD do, or if my memory about what I think it did for me (once!) must be faulty.)
All of the following done on a Windows 7 machine, using the native database engine of OO, ver 4.1.1, 13 Mar 17
UnklDonald418's answer, massaged...
In ooBase main project manager window, select (left pane) Queries.
Right click on query's name, lower right pane, select "edit in SQL View".
Select all the text, ctrl-c to copy the selected text.
Close the editing session.
In ooBase main project manager window, select (left pane) Tables.
In upper right pane, click on Create View. You will get what looks like a query dialog.
The way you are viewing your view(!) could be in either of two states. If you are seeing rows and columns, (Row labels at left: "Field", "Alias", etc; columns: One for each field in table), then you are viewing your View in "Design View". Switch that OFF ("View/ Switch Design View On-off", or via button on toolbar). That should leave you with a simple pane into which you can type anything.
Do ctrl-v (pr paste by any other means), to put what you copied earlier here. It will look a bit like...
SELECT "date" AS "date", "tick" AS "tick", "quant" AS "quant", "cost" AS "cost", "frm" AS "frm", "to" AS "to", "pool" AS "pool" FROM "xactions
...(If, of course, your table is like mine was! Name: xactions. Fields: date, tick, quant, etc.)
Save your VIEW. You won't be able to tell Views from Queries within Base after this, if there is a significant difference in the first place, unless you put something in the name you chose for the view. (Don't be alarmed that the prompts are speaking of a "Query".)
You can, at this stage, run the query to verify that it displays what you intend.
Close the "Query" design window. In which you have designed your View!
Open a Writer document, and arrange your windows so that you can see that, and see you ooBase main project manager window, which should be showing your queries and views.
From the lower right pane of the ooBase main project manager window, drag your view onto the Writer page.
A dialog opens.
First, make your wish known: You want to "Insert data as" TEXT. (Radio buttons across top of dialog.)
For each field from the table that you want in your .csv, double click on the name (in "Database columns" column), and it will be added to the panel to the left of the list of the database column names.
You can now "do things" to the text in the panel you've just populated. In my case, at this point, it looked like...
<cost> <date> <frm> <pool> <quant> <tick> <to>
... which would have produced text, by not comma separated, for one thing. Nor would text fields be delimited with quotation marks. And the fields would have been in the wrong order for my wants. All of that easily fixable. What I needed to get what I wanted was....
... which I created "by hand" out of the "rough draft" that the Base dialog had helped me start. Created in the panel on the dialog.
(I then copied the result to a text file, and saved it for re-use later. You don't HAVE to fill the panel to the right of the one with field ("database column") names by the dialog's mechanism.)
Dialog filled in. Click OK.
Your Writer doc should fill with lines of data, one record from table to each line... with whatever commas, quotation marks, etc, you specified.
Then, final stage, you can either....
(Note to self... this won't work for ST2XTAB's wants.)
Still in Writer: SaveAs. Change type to Text.
(Navigate to right folder, assign name)
Click "Save" button.
You will be asked "This doc may contain... " with two choices... "Keep current format" or "Save in ODF" format. You want "Keep Current Format".
You MAY (unlikely) get "Error saving... Access denied." (I will probably get it, hence this note!) This can happen if you have an earlier document, in the folder you are trying to save to, using the same name as you are trying to use, is currently open in another application. Close that, and try again! (In my use, if ST2XTAB is still open, havng accessed TmpGL.txt, that will cause the error.)
OPTION B... longwinded, but "safe"...
In some obscure instances, The way Writer ends a "saved as .txt" file's lines and files differs from the way others do it. In my case, the difference mattered (for ST2XTab2). (Note to self: ALSO: For ST2XTAB, the last record needs to have at least 7 commas added to it. Too many does not hurt.)
An alternative way to save the text AS TEXT...
In the Writer doc, ctrl-A to select all of the text. Close Writer doc, if you want to save the text from the text editor (next step) under the same name.
Open the text editor you like. Open a new doc. Ctrl-V. Save.
TA DA!!! Data now safely in .csv file!!! (Using extension ".txt", if you used Option A.)
Post by UnklDonald418 » Sun Mar 12, 2017
In my experience Calc seems to do a better job of exporting tables.
From the result screen of the Base query select all the rows and drag them onto a blank Calc sheet.
Then from the Calc sheet use SaveAs to export the data.
** N B **
To select all rows of the query, click the empty box to left of column headings, the "cell" above the column of empty boxes which start each row of the query result. The MOST upper left "cell" of the whole query table, immediately above and left of first record's first field.
And also note: Click there, to select all rows, all columns, then IMMEDIATELY either do ctrl-c, or right-click/copy. (If you click somewhere else first, although all records remain selected, "copy" does not copy everything.
(I haven't checked, in detail, the rest of this solution... I believe it works, though. Be sure during the SaveAs (of the Calc sheet) you tick the "Edit filter settings" box, if you want to be able to put quotes around text fields, etc. (Note to self: ST2XTAB needs the quotes))
Post by MrProgrammer » Mon Mar 13, 2017
Open the query in Base. Edit > Copy. Open a new spreadsheet. Edit > Paste. File > Save As > File type > (scroll way down to find) Text CSV.
(MSPhobe comment: Yes! Works! (Pretty sure... haven't done exhaustive test, apart from work you see elsewhere here.)
Open a new spreadsheet. View > Data Sources. Select your query. Select all the records (square to left of field names). (from the toolbar) Data to Text....
(MSPhobe comment: Yes! Works! ... and Very Neat!!! I like this! First time I've seen a USE for "data sources") (Works IF you have "registered" the database with Base, which is the default result when you create a new database.)
The suggestion from MrProgrammer went on to say...
Then: File > Save As > File type > (scroll way down to find) Text CSV.
(MSPhobe comment: Works! Pretty sure... haven't done exhaustive test, apart from work you see elsewhere here.)
OpenOffice 4.1.1 on Windows 7, plus others on XP. "Native", and as FE to MySQL