Jet DB Engine and parameterized UPDATE query

[Gilberto Campos]

Hi all.

I am having a strange problem.

I am developping an application that acceses an Access db through Jet
(.UDL files).

I have writen parametric INSERT queries that work fine.
I am now trying to write a parametric UPDATE query but I always get a
return error code that the language manual translates to:

Exception occurred in Microsoft JET Database Engine, Operation must use
an updateable query.

I have looked at file and directory permissions, but everything looks
ok.

Does anyone have any clues to why parametric INSERT works and UPDATE
does not?

Thanks in advance.

G.
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

[pietlinden]

how about posting your code and SQL statement... I see no reason why a
parameterized update query wouldn't work...

[dedejavu]

Access has some irritating habits that make little sense when it comes
to UPDATE queries.
If any portion of the recordset is not updateable you get that
'Operation must use an updateable query' message.
For example you may have an outer join, or a linked read only table, or
a non-updateable query joined to the table you are trying to update.
Even though you are not updating the non-updateable items, access won't
let you do it.
My solutions have been to put sql in an IN statement to limit the
recordset instead of a join, or to make a temp table (which I detest).
HTH
P

[Gilberto Campos]

"pietlinden" <pi********@hotmail.com> wrote in message
news:11********************@o13g2000cwo.googlegrou ps.com

how about posting your code and SQL statement... I see no reason why a
parameterized update query wouldn't work...

Not very simple since I am working in LabView.
It actually uses ADO underneath, so I copied the function from the
INSERT query (that works perfectly) and modified the SQL statement
generation. I did not touch the ADO calls that build the parametric
query.
G.
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

[Gilberto Campos]

"dedejavu" <de******@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com

Access has some irritating habits that make little sense when it comes
to UPDATE queries.
If any portion of the recordset is not updateable you get that
'Operation must use an updateable query' message.
For example you may have an outer join, or a linked read only table, or
a non-updateable query joined to the table you are trying to update.
Even though you are not updating the non-updateable items, access won't
let you do it.
My solutions have been to put sql in an IN statement to limit the
recordset instead of a join, or to make a temp table (which I detest).
HTH
P

Non of these things!

I am trying to update ONE single table.
G.

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG