Using Interbase stored procedures with Delphi 1

[kagee]

Hi,
i am trying to call an interbase stored procedure from a delphi app but after execproc i cannot see the data in the database...

the stored procedure is for inserting some values into several tables in the database.

Urgently need HELP!!!

 

[lespaul]

What is your code for call the SP?

 

[kagee]

i've changed the procedure to first try & insert 2 values into one simple table -districts.
am using D7 & IB7.1
after execproc, the data doesnt show in the database
the stored procedure is :

set term ^;
create stored procedure insert_district
(distname, distcode)

as begin
(districtname, districtcode);
end

values
(
:distname,
:distcode
);
set term ;^

 

[lespaul]

What is the DELPHI code you are using for calling the SP?

Leslie

 

[kagee]

Hi
am also using a datamodule where i have dropped all my IB connection and IB transaction, and then the TstoredProc

the delphi code is:

storedproc1 := datamodule1.Tstoredproc1.create(self);

with storedproc1 do begin

datamodule1.Tstoredproc1.prepare
datamodule1.Tstoredproc1.parambyname('distname').AsInteger :=districtnametxt.text;
datamodule1.Tstoredproc1.parambyname('distcode').AsInteger :=districtcodetxt.text;

datamodule1.Tstoredproc1.execproc;
datamodule1.Tstoredproc1.free
end;

 

[lespaul]

storedproc1 := datamodule1.Tstoredproc1.create(self);

with storedproc1 do begin

prepare
parambyname('distname').AsInteger :=districtnametxt.text;
parambyname('distcode').AsInteger :=districtcodetxt.text;

execproc;
free
end;

you've already declared storedproc1 as datamodule1.Tstoredproc1 you don't need to keep referencing the whole thing after you say 'with storedproc1 do'

HTH

Leslie

 

[kagee]

the problem am having is that after executing the SP, i cannot see the data in the interbase database.

Theres smthing am not just getting right ...
(even after executing the procedure directly from interbase,i can not see the data...)