[libreoffice-users] Re: SQLException when using ADO driver and prepared statements

Hello!

Alexander Thurgood:
> So the question is not whether you can use prepared statements, but
> whether you can use parameterized queries in prepared statements ?

Well, yeah, actually :-)

Alexander Thurgood:
> I guess I would start with whether the simple parameterized SQL
> statement actually runs correctly from within the LO Query SQL editor ?

It doesn't seem to work. I tried SELECT "col1" FROM "tbl1" WHERE "col2" = :x
and just got a bunch of errors (listed below). I did some googling already
but didn't find anything yet. I have some actual work that has to be done so
I'm going to have to return to this a little later. Thanks for the tip!

1.
The data content could not be loaded.

2.
SQL Status: 42000
Error code: -2147217900

Incorrect syntax near ':'.

3.
SQL Status: 42000
Error code: -2147217900

Statement(s) could not be prepared.




--
View this message in context: 
http://nabble.documentfoundation.org/SQLException-when-using-ADO-driver-and-prepared-statements-tp4070605p4070700.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted