Re: SELECT...FOR UPDATE
the statement is :
UPDATE table-name SET { column_name = expression [,...]
| { (col_list) | * } =
(expr_list) }
[ WHERE condition ]
marianat@my-dejanews.com wrote in message
<768l08$bf$1@nnrp1.dejanews.com>...
>I'm working with an Informix OnLine Dynamic Server 7.30, and an ODBC
driver.
>I need to know if it is possible to have a SQL query like this:
>
> select * from <table> order by <field> for update;>
>According to the messages I'm getting, this is not possible: the
"select...for
>update" clause is rejected when you use order by or group by.
>Is this correct?
>
>Thanks,
>Mariana.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own