>oCommand.CommandType = adCmdText
>oCommand.CommandText = "SET DELETED OFF"
>oCommand.Execute()
>
Thank you Sergey,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 -)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 :-)))