Subject | Stored Procedure with one input parameter on DataSnap Server returning table |
---|---|
Author | Franz |
Post date | 2012-08-10T16:20:49Z |
Please help with specifying components and parameters for the following situation:
1. DataSnap Server with one table TestParm and one stored proc TestSP:
begin
TestOutput = :testInput*10;
TestBlob = :TestInput * 100;
insert into TestParm (TestInput, TestOutput, TestBlob) values (:TestInput, :TestOutput, :testblob);
for
select TestInput, TestOutput, TestBlob
from TestParm
where TestParm.TestInput = :TestInput
into :TestCopyInput, :TestCopyOutput, :TestBlob
do
begin
suspend;
end
end
2. Delphi XE2 DataSnap Server with a unit ServerMethodsUnit.pas with
TSQLConnnection pointing at database with table TestParm
TDatasetProvider with property Dataset pointing at TSQLStoredProc
TSQLStoredProc with StoredProcName pointing at TestSP (see above)
Should my TestInput input parameter be filled in at Params?
3. On the Client side:
TSQLConnection with driver Datasnap
TSQLQuery with SQL string:
select * from testsp where TESTINPUT = :TESTINPUT;
Should any parameters be set in the Params property?
I tried all kinds of combinations, but get error messages all the time. I.e. dbx.sql is an unrecognized command type, invalid ordinal 0, parameter mismatch for procedure TestSP.
What should be the correct combination of components, parameters for this?
Please help!
Regards,
Franz
1. DataSnap Server with one table TestParm and one stored proc TestSP:
begin
TestOutput = :testInput*10;
TestBlob = :TestInput * 100;
insert into TestParm (TestInput, TestOutput, TestBlob) values (:TestInput, :TestOutput, :testblob);
for
select TestInput, TestOutput, TestBlob
from TestParm
where TestParm.TestInput = :TestInput
into :TestCopyInput, :TestCopyOutput, :TestBlob
do
begin
suspend;
end
end
2. Delphi XE2 DataSnap Server with a unit ServerMethodsUnit.pas with
TSQLConnnection pointing at database with table TestParm
TDatasetProvider with property Dataset pointing at TSQLStoredProc
TSQLStoredProc with StoredProcName pointing at TestSP (see above)
Should my TestInput input parameter be filled in at Params?
3. On the Client side:
TSQLConnection with driver Datasnap
TSQLQuery with SQL string:
select * from testsp where TESTINPUT = :TESTINPUT;
Should any parameters be set in the Params property?
I tried all kinds of combinations, but get error messages all the time. I.e. dbx.sql is an unrecognized command type, invalid ordinal 0, parameter mismatch for procedure TestSP.
What should be the correct combination of components, parameters for this?
Please help!
Regards,
Franz