hi,

Microsoft ODBC for Oracle v2.573.3711 file MSORCL32.DLL.

what does Oracle Error:
Not Allowed to use key-set driven cursor on join, union, minus...blah,
blah...

mean when i issue in SQL Tag?

<!--SQL name=mysql
SELECT TABLE1.COL1, TABLE2.COL2 FROM TABLE1,TABLE2
WHERE TABLE1.ID=TABLE2.ID ORDER BY TABLE1.COL1
-->


I even tried this one out just for curiousty, and got the same message too:
<!--SQL name=mysql
SELECT TABLE1.COL1, TABLE2.COL2 FROM TABLE1,TABLE2
WHERE 1=1 ORDER BY TABLE1.COL1
-->

but without including TABLE2, that means the select is from 1 table only,
it works.

Actually, i use this approach to display a selection of items in replacement
of a SelectRow() implementation to highlight a current item.

tia,
peter.