Hi, I've got a sql script file in which I create some tables, then I create stored procedure(I use variables in MSSQL format, it means: @variable).
Until there was only part that creates tables everything worked fine, but after I added part that creates procedure I get an error during execute:
"Incorrectly defined object Parameter. Information is inconsistent or incomplete"
(this is translation from polish, so it could sound little different)
I thought that ADOCommand treats SQL variables as its parameters, so before Execute method I wrote: "AdoCommand.ParamCheck:=false", but it didn't help.
What should I do?
PS. All my script works fine in MSSQL, it's only problem with ADOCommand.
Until there was only part that creates tables everything worked fine, but after I added part that creates procedure I get an error during execute:
"Incorrectly defined object Parameter. Information is inconsistent or incomplete"
(this is translation from polish, so it could sound little different)
I thought that ADOCommand treats SQL variables as its parameters, so before Execute method I wrote: "AdoCommand.ParamCheck:=false", but it didn't help.
What should I do?
PS. All my script works fine in MSSQL, it's only problem with ADOCommand.