Hi, Well, the subject line pretty much sums it up, but this is why.
I currently have a macro that exports the result set of a query to a text table. It is fairly simple using the SELECT INTO TEXT TABLE command of HSQLDB and then simply removes the table object that is created in the datasource. It is currently hard coded for the query, and creates a file name based on the current date.
Now, after reading Mechtilde's comment yesterday I was thinking about how one could generalize this macro and perhaps end up with an addon.
Preferably I would like to be able to run the macro and have it recognize if either a table item or a query item is selected in the BaseDocument window and use this as the source, prompting the user for a file name.
The first step of course is to recognize when the current component on the desktop is a BaseDocument. I have that part - pretty much - working, although an open table view window on top of the basedocument window is a problem still.
But the next step, getting a handle to the current selection just eludes me. Any ideas on this would be most appreciated.
If this is not possible at this moment, then so be it. I can easily put together a dialog box that would allow the user to select a table or a query.
Then the next step would be figuring out how to make this an addon - but here there seems to be plenty of resources to turn to and I will scoure them first.
Thanks Drew --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
