>>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()
>

Thank you Sergey,
I wasn't clear. I tried to execute a script:

oCommand.CommandType = adCmdText
oCommand.CommandText = "USE SomeTable EXCLUSIVE"+CHR(13)+CHR(10)+"ZAP"
oCommand.Execute()

I even tried:

oCommand.CommandType = adCmdText
oCommand.CommandText = 'EXECSCRIPT("USE SomeTable EXCLUSIVE"+CHR(13)+CHR(10)+"ZAP")'
oCommand.Execute()

but both bombs -)
Finaly I added parameter:

oPar.Destination = 1
oPar.Type = adVarchar
oPar.Size = LEN(myScript) && Where myScript is variable holding the script above
oPar.Value = m.myScript
oCommand.Parameters.Append(oPar)

oCommand.CommandType = adCmdText
oCommand.CommandText = "EXECSCRIPT(?)"
oCommand.Execute()

and everything works :-) but I hope there is a way w/o using EXECSCRIPT :-)))