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.
Any other suggestions anyone?
Thanks,
Mike
--- Marc Santhoff <[EMAIL PROTECTED]> wrote:
> Am Freitag, den 18.11.2005, 10:59 -0500 schrieb
> [EMAIL PROTECTED]:
> > INSERT INTO biblio (Publisher, Title, Author,
> Year,
> > Address, Identifier, Type, Pages) VALUES
> ('Prentice
> > Hall', 'Network flows : theory, algorithms, and
> > applications', 'Ahuja, R.K., Magnanti, T.L.,
> Orlin,
> > J.B.', '1993', 'Upper Saddle River, N.J.', '35',
> '1',
> > '846')
>
> Since you're using case sensitive names it may help
> to quote the table
> names. I've tried something simple in the design
> view of a query and
> switched to the sql view:
>
> (only a dump example for syntax checking)
>
> SELECT "Type", "Editor", "Author" FROM "biblio"
> "biblio"
>
> HTH,
> 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]
