Am Sonntag, den 16.12.2007, 22:51 +0100 schrieb Frank Schönheit - Sun
Microsystems Germany:
> > - get access to the four sections of a base doc container: tables,
> > queries, forms and reports (although that should be easy doable as it is
> > now ... lacking time to search and test)
> > e.g. aBaseDoc.Forms() (doesn't this exeist already?)
>
> Hmm - what exactly do you want to access here? The UI? That's the
> selection supplier, I suppose. The component definitions? That already
> exists. The open "sub documents"? That doesn't exist, and is the same as
> you mentioned above.
> I'm unclear what you exactly mean here, please elaborate.
Coming back on this one lately:
The point making me to ask for an equivalent of the documents
"FormDocuments" and "ReportDocuments" was this:
md =
ThisDatabaseDocument.DataSource.connectWithCompletion(NULL).MetaData
dim types()
rs = md.getTables(NULL,"","%",types())
rs.next()
while NOT(rs.IsAfterLast())
tn = rs.getString(3)
s = s + tn + chr(10)
rs.next()
wend
That is a sequence retrieving all table names into a string. Okay, not
so complicated, but if I had to explain someone why getting the forms is
one property away and the tables aren't, I'd stumble.
Since The documents View has to do anyways, why not make a shortcut for
tables and queries, too?
Btw. the last parameter of MetaData.getTables is documented as "NULL
get's all types of tables", but if it is set to NULL something like
"Object variable not set" occurs.
Marc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]