Hello,I have procedure with this parameters:CREATE PROCEDURE sp_TableData @table sysname , @row sysname , @num bigint , @cond bit , @start bigint=null , @end bigint=null , @clause nvarchar(3000)=null AS
In client application using ADO for calling this procedure: // param types ADOMaster->Parameters->ParamByName("@table")->Value = FTableName; // AnsiString ADOMaster->Parameters->ParamByName("@row")->Value = "ID"; // AnsiString ADOMaster->Parameters->ParamByName("@num")->Value = dbPaging->Result; // int ADOMaster->Parameters->ParamByName("@cond")->Value = true; // boolean ADOMaster->Parameters->ParamByName("@start")->Value = v_nul; // __int64 ADOMaster->Parameters->ParamByName("@end")->Value = v_nul; // __int64 ADOMaster->Parameters->ParamByName("@clause")->Value = Text; // AnsiString ADOMaster->Requery();
Parameters create at design time and all type and size is true, but many time got this error:"Application uses Value of wrong type for the current operation"Regards,sasan.