[dba-users] Error message No content provider available for URL!

2009-12-01 Thread Dick Hoffman
I've established a database with two tables that appears to be working very well. I'm trying to write a Basic macro that issues a query and generates some statistics from the results. I'm getting a runtime error that says No content provider available for URL! Any idea what I'm doing wrong?

[dba-users] Re: Error message No content provider available for URL!

2009-12-01 Thread Dick Hoffman
Drew Jensen wrote: Dick Hoffman wrote: I've established a database with two tables that appears to be working very well. I'm trying to write a Basic macro that issues a query and generates some statistics from the results. I'm getting a runtime error that says No content provider available

[dba-users] Re: Error message No content provider available for URL!

2009-12-03 Thread Dick Hoffman
Peter Eberlein wrote: Am 02.12.2009 08:48, schrieb Frank Schoenheit, Sun Microsystems Germany: DBaseName = ConvertURL( C:\RahStuff\Base_Stuff\Cleve_CBC.odb ) ^^ meant ConvertToURL of course, Regards Peter Frank's suggestion, modified per Peter's correction above works just fine. Ocke's

[dba-users] Macro question

2009-12-19 Thread Dick Hoffman
I've used OOo Base to construct a database and wrote a macro in Basic to connect to the database, issue an SQL query and write out a report of statistics calculated from the results of the query. All work very well. Now I'd like to write another macro that issues a different query and

[dba-users] Re: Macro question

2010-01-12 Thread Dick Hoffman
Frank Schoenheit, Sun Microsystems Germany wrote: Hi Dick, I've used OOo Base to construct a database and wrote a macro in Basic to connect to the database, issue an SQL query and write out a report of statistics calculated from the results of the query. All work very well. Now I'd like to

[dba-users] Re: Macro question

2010-01-13 Thread Dick Hoffman
Frank Schoenheit, Sun Microsystems Germany wrote: Hi Dick, Thanks for your help so far!!! I followed your suggestions above and figured out I had to right click on the Stat1 tab to get to the Insert / BASIC module option. I now have two modules: one named Module1 which contains the Species

[dba-users] Error trying to update database

2011-01-27 Thread Dick Hoffman
I'm getting an error when trying to add records to a database that I built some time ago using a form I built some time ago. The error message says: Integrity constraint violation - no parent SYS_FK_123 table: YearStats in statement {INSERT INTO CBC_DATA_RECS (COUNT_YR, PREV_REC_NO, SPEC_NO,

[dba-users] Re: Error trying to update database

2011-01-27 Thread Dick Hoffman
Dick Hoffman wrote: I'm getting an error when trying to add records to a database that I built some time ago using a form I built some time ago. The error message says: Integrity constraint violation - no parent SYS_FK_123 table: YearStats in statement {INSERT INTO CBC_DATA_RECS (COUNT_YR

[dba-users] Re: Error trying to update database

2011-01-27 Thread Dick Hoffman
Dick Hoffman wrote: Dick Hoffman wrote: I'm getting an error when trying to add records to a database that I built some time ago using a form I built some time ago. The error message says: Integrity constraint violation - no parent SYS_FK_123 table: YearStats in statement {INSERT

[dba-users] Re: Error trying to update database - OT

2011-01-28 Thread Dick Hoffman
Reizinger Zoltán wrote: Upgrade to OOo 3.3 Zoltan 2011.01.27. 21:49 keltezéssel, Dick Hoffman írta: I'm getting an error when trying to add records to a database that I built some time ago using a form I built some time ago. The error message says: Integrity constraint violation - no parent

[dba-users] Re: Error trying to update database - OT

2011-01-29 Thread Dick Hoffman
Reizinger Zoltán wrote: OOo 3.3 released: http://www.openoffice.org/index.html 2011.01.28. 19:54 keltezéssel, Dick Hoffman írta: Reizinger Zoltán wrote: Upgrade to OOo 3.3 Zoltan 2011.01.27. 21:49 keltezéssel, Dick Hoffman írta: I'm getting an error when trying to add records to a database