|Subject||RE: [firebird-support] Update only First 10 problem ?|
> Hello, I've a problem with this query :when you say it doesn't work - do you mean that it's unpredictable?
> UPDATE TB_TEST SET COL='123'
> WHERE ID_TEST IN (
> SELECT FIRST 10 ID_TEST
> FROM TB_TEST)
> ok, that work but all the records are updated and I want to update
> only the first 10 records, there are a other solution or it's a bug
> from firebird ?
> With stored procedure no problem but I want use SQL Query.
> I use the last firebird version for linux.
Please note that SELECT FIRST syntax is totally meaningless (at best) and
absolutely unpredictable (at worst) without an ORDER BY clause.
FIRST what? there is not such thing as natural order in Firebird.
So,... please try again with an order by clause and report back.