>Now I start playing with CAs that uses VFP DBC but with ADO (VFPOLEDB) DataSourceType.
>I'm not a big fan of ADO but for VFP9 DB I'm stick with it.
>Is there ANY way to make a SP to be used as SelectCMD to populate Cursor?
>
>Also is there ANY way to execute any NON query commands with ADODB.Command?

I dunno about CA but you can execute any supported VFP commands with ADODB.Command

oCommand.CommandType = adCmdText
oCommand.CommandText = "SET DELETED OFF"
oCommand.Execute()