Subject | Re: TIBOStoredproc |
---|---|
Author | ronanvanriet |
Post date | 2004-01-05T15:06:16Z |
Hello,
Has this problem been resolved?
I am assuming this is a selectable SP? How many records are returned,
1 or more. What does the SP's DML look like? How are you parameters
defined?
Have you tried
with sp do begin
close;
parambyname('par1').asstring:=var1;
if not prepared then prepare;
open;// ExecProc
var2:=sp.parambyname('par1').asstring;param 'par1' not found
var2:=sp.fieldbyname('par1').asstring;field 'par1' not found
end
Ronan
Has this problem been resolved?
I am assuming this is a selectable SP? How many records are returned,
1 or more. What does the SP's DML look like? How are you parameters
defined?
Have you tried
with sp do begin
close;
parambyname('par1').asstring:=var1;
if not prepared then prepare;
open;// ExecProc
var2:=sp.parambyname('par1').asstring;param 'par1' not found
var2:=sp.fieldbyname('par1').asstring;field 'par1' not found
end
Ronan