>I have the following code:
>
>rs=createobject("ADODB.RecordSet")
>? rs.open("select * from atty","otc",2,3)
>? "Ctype=",rs.cursortype
>
>For some reason the cursortype always opens at type 3(Static) instead of 2(Dunamic). Does anyone have any ideas why?
>OTC is a DBC ODBC database and atty is a table in the OTC database.
>
>Thanks
>
>Costas
My guess would be that FoxPro's odbc driver does not support dynamic ADO cursors.