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 c

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 Andrew Douglas Pitonyak
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 close

Re: [dba-dev] Can not delete a previously opened Base document

2005-10-30 Thread Andrew Douglas Pitonyak
Wolfgang Schaible wrote: hi, Am Sonntag 30 Oktober 2005 02.55 schrieb Andrew Douglas Pitonyak: If I open a Base document and then close it, I can not delete the file. I need to exit OOo before I can delete the file. Is there anyway that I can really close the connection to the database?

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 docum

Re: [dba-dev] Can not delete a previously opened Base document

2005-10-30 Thread Wolfgang Schaible
hi, Am Sonntag 30 Oktober 2005 02.55 schrieb Andrew Douglas Pitonyak: > If I open a Base document and then close it, I can not delete the > file. I need to exit OOo before I can delete the file. Is there > anyway that I can really close the connection to the database? ? no problem use 2.0 on linu