Re: Error message "No content provider available for URL!"

Dick Hoffman <[email protected]> Tue, 01 Dec 2009 17:51:13 -0500
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
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 for URL!" Any idea what
>> I'm doing wrong?
>> Dick
>
> Hello Dick,
>
>  From a 'wild guess' stand point - I would look at your SQL statement
> for procedures, functions, control statements perhaps, that the OOo
> parser does not recognize. I would also check that Escape Processing is
> turned off when you try to execute the statement.
>
> Anyway - that is a first type of thing to look at.
>
> Let us know how it goes - ok?
>
> Drew
Please see my reply to Frank where I've included the statements I'm 
using. I've looked at them until I'm cross eyed and can't see what's wrong.
Dick