Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-11-10 Thread Wolfgang Schaible
Am Donnerstag 10 November 2005 06.52 schrieb Andrew Douglas Pitonyak: Wolfgang Schaible wrote: hi Andrew, Am Montag 07 November 2005 06.33 schrieb Andrew Douglas Pitonyak: Function FindComponentWithURL(sURL As String, bLoadIfNotFound As Boolean) Dim oDocs ' Enumeration of the loaded

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-11-09 Thread Andrew Douglas Pitonyak
Wolfgang Schaible wrote: hi Andrew, Am Montag 07 November 2005 06.33 schrieb Andrew Douglas Pitonyak: Function FindComponentWithURL(sURL As String, bLoadIfNotFound As Boolean) Dim oDocs ' Enumeration of the loaded components. Dim oDoc' A single enumerated component. Dim sSt$'

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-11-06 Thread Wolfgang Schaible
hi Andrew, hi Frank 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

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-11-01 Thread 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 I will

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-11-01 Thread 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,

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-10-31 Thread Andrew Douglas Pitonyak
Ocke Janssen wrote: Hi, Wolfgang Schaible wrote: hi, Am Sonntag 30 Oktober 2005 02.57 schrieb Andrew Douglas Pitonyak: I load a Base document. I add a table using a macro (and the API). The Base document shows the new tables. If my macro uses SQL to create the table, then the tables are

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-10-31 Thread Wolfgang Schaible
hi, Am Montag 31 Oktober 2005 14.38 schrieb Andrew Douglas Pitonyak: Ocke Janssen wrote: Wolfgang Schaible wrote: Am Sonntag 30 Oktober 2005 02.57 schrieb Andrew Douglas Pitonyak: I load a Base document. I add a table using a macro (and the API). The Base document shows the new tables.

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-10-31 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Wolfgang, Sounds good, but running a macro (with Base-Doc not open), how can I obtain a controller of the document and dispatch the command .uno:DBRefreshTables ? Ocke's last sentence Normally it should be enough to query for the XRefresh interface and call a refresh. was referring

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-10-31 Thread Andrew Douglas Pitonyak
Frank Schönheit - Sun Microsystems Germany wrote: Hi Wolfgang, Sounds good, but running a macro (with Base-Doc not open), how can I obtain a controller of the document and dispatch the command .uno:DBRefreshTables ? Ocke's last sentence Normally it should be enough to query

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-10-30 Thread Wolfgang Schaible
hi, Am Sonntag 30 Oktober 2005 02.57 schrieb Andrew Douglas Pitonyak: I load a Base document. I add a table using a macro (and the API). The Base document shows the new tables. If my macro uses SQL to create the table, then the tables are not visible unless I close and re-open the document.

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-10-30 Thread Andrew Jensen
Wolfgang, PS Can you delete a record using 'oRowSet.deleteRow()' without a crash? Yes, this works without a problem for me using 2.0 FR on WinXP against the embedded database engine. The other problems you mention. Still have one of them, haven't tried the other. Andrew Jensen

Re: [dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-10-30 Thread Ocke Janssen
Hi, Wolfgang Schaible wrote: hi, Am Sonntag 30 Oktober 2005 02.57 schrieb Andrew Douglas Pitonyak: I load a Base document. I add a table using a macro (and the API). The Base document shows the new tables. If my macro uses SQL to create the table, then the tables are not visible unless I

[dba-dev] Adding tables using SQL does not update a Base document immediately.

2005-10-29 Thread Andrew Douglas Pitonyak
I load a Base document. I add a table using a macro (and the API). The Base document shows the new tables. If my macro uses SQL to create the table, then the tables are not visible unless I close and re-open the document. Is there anyway to tell OOo to refresh its view of things from a macro?