hi Andrew, hi Frank, hi *
Am Mittwoch 02 November 2005 05.10 schrieb Andrew Douglas Pitonyak:
> Frank Schönheit - Sun Microsystems Germany wrote:
> >Hi Andrew,
> >
> >>I tried
> >>oTables = oCon.getTables()
> >>oTables.refresh()
> >>
> >>This did not work....
> >
> >This is surprising, since it's exactly what the Controller does
> > with its own connection when you dispatch the URL ...
> >
> >Ciao
> >Frank
>
> Initially, adding a table worked with oTables.refresh(), but
> delete did not. I performed a couple of iterations and then
> adding worked sometimes, and sometimes not. Using the dispatch
> ALWAYS worked. All of the code that I use is found in this
> document:
> http://www.pitonyak.org/database/OOoBaseBinaryFields.odt
> There is a section titled: "Using SQL statements to modify
> tables". I show the code that I currently use to refresh the
> database document, and then the code that I use to remove and add
> tables... Not that it probably matters. Working hard to document
> things so that I will know how to do things that I think are
> cool! :-)
Its more than a open help:
-DB EOYY exists, Base may be open or not,
Help NOT open :-)
-rename:
oStmt.executeUpdate("ALTER TABLE EOYY RENAME TO YYxx), then
'RefreshTables':
--FindComponentWithURL: If oDoc.hasLocation() Then..->
Property or method not found
-SQL done (EOYY gone, YYxx exists in reality), but
starting BASE the old EOYY is shown
try to open:->Table not found ..."EOYY"
==>BASE does NOT refresh itself during start: STRANGE
Base.New.Refresh shows the reality
Without 'RefreshTables' the application dies because
'if(oConn.Tables.hasByName(sEOYY))then' says true, and this is a lie
Same with
oTables = oCon.getTables()
oTables.refresh()
not easy to use Base...
Wolfgang
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
