Yes,
That made no difference.
What is interesting though, is that the RowSet.Command
= COMMAND doesn't even recognize the INSERT in this
form:
INSERT INTO table ([columns]) VALUES ([values])
At least it parsed the INSERT when in form:
INSERT INTO table VALUES ([values])
But then refused to executed saying it will only do
SELECT commands (just like the suite Query tool)! What
the heck, the SDK docs tell me that I can use RowSet
to modify the database(?)! ;)
I think I will have to rewrite my function using the
weird RowSet SDB type db access API, or use the
Statement interface.
Suggestions on which I should use: ResultSetUpdate, or
Statement? I'm familiar with SQL... but using
ResultSetUpdate would allow me to use non-SQL
datasources (right?).
Thanks,
Mike
--- Marc Santhoff <[EMAIL PROTECTED]> wrote:
> Am Montag, den 21.11.2005, 14:28 -0500 schrieb
> [EMAIL PROTECTED]:
> > Marc,
> >
> > Thanks for the hint in trying to use the OOo suite
> to
> > try the SQL statements... but unfortunately, the
> query
> > view is ONLY good for SELECT statements. As You
> may
> > recall, my problem is with an INSERT.
>
> The more important part of my hint was to use
> (double) quotes around
> table names.
>
> Have you tried quoting the table names?
>
> Marc
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
---------------------------------------------------
Michael Sowka, Graduate Enginerd ___
<*,*>
E-mail: [EMAIL PROTECTED] [`-']
Web: http://www.sowka.com -"-"-
---------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
