Diman
Admin
Admin
| Posts: 1495 |  |
Karma: 19
|
|
RE: Update error
|
|
Posted: 2000/09/01 20:54 |
|
|
|
|
Hi !
The problem is follows ... NCOCI8 did not extract table name from SELECT query. It creates updating querys, using syntax: UPDATE (<original query> SET ... WHERE ... It is good, until you not have a ORDER BY phrase, because you can not use ORDER BY in subquerys. So, there are 2 options (and more):
- remove ORDER BY from your query;
- use TOCIUpdateSQL with filled TableName property.
|
|
