UniStoredProc1.Close;
UniStoredProc1.ParamByName('Param1').AsString:=Value1;
UniStoredProc1.ParamByName('Param2').AsString:=Value2;
UniStoredProc1.ParamByName('Param3').AsSmallInt:=Value3;
//UniStoredProc1.Prepare; <----------------
UniStoredProc1.Open;
Viwe SQL Profiler
exec sP_StoredProc1 NULL, NULL, NULL
UniStoredProc1.Close;
UniStoredProc1.ParamByName('Param1').AsString:=Value1;
UniStoredProc1.ParamByName('Param2').AsString:=Value2;
UniStoredProc1.ParamByName('Param3').AsSmallInt:=Value3;
UniStoredProc1.Prepare;
UniStoredProc1.Open;
UniStoredProc1.OpenNext;
Viwe SQL Profiler
exec sP_StoredProc1 Value1, Value2, Value3
but
Raise 'Cannot OpenNext if Statement is Prepared'
________
Hemp Marijuana
TUniStoredProc Error
TUniStoredProc Error
Last edited by cxg417 on Tue 15 Feb 2011 15:00, edited 1 time in total.