To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58915
------- Additional comments from [EMAIL PROTECTED] Sun Dec 11 23:57:52 -0800 2005 ------- I don't think the script command will prove to be of help here. As far as I can see there is no way to limit the output to a given table. When the command is issued a full dump of the database if performed, all the table definitions, constraints and inserts for all data, in all tables. Further more there is no way to use the command with any type of query. There is no solution that will generate SQL insert commands that I know off, if you discount creating an export script (macro). However, if once can work with a formatted text file (a cvs file was mentioned earlier) then the solution is already in the HSQLDB engine. The use of a text table. You can issue any select statement and have it save its result set to a text table. Lookup the Create Table comamnd in the HSQLDB users manual. I have used this quite successfully to export data from a Base database. Using this techinque you can easily export all the records from a table or any selection you need from a standard SQL Select statement. The option is to use an Insert Into command with a predefined text table. This approach might suit Steves needs better. I think it would be well worth while to explore the addition of an export function into Base, but feel more thought needs to go into the functionality that would be useful. The requirements stated in the initial filing of the issue, IMO, can be readily met with the tool as delivered. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
