I do not think there is a global way to do that. Why every "Select" statement is not readonly by default is unknown. Sorry I could not help more. Let me know if you find someway, it would be nice to know.

>thank you Patrick but i allready knew it, i need a "set "-> like option, i mean if i need use batchmode 2 i put this code =SQLSETPROP(con, 'Batchmode', .T.), what do i put to have read only cursor when use a simple: select * from xtable?