Hi,
I am rather new to interbase and am using Interbase 7.1 and Delphi 7 (on windows 2003 server)-- stored procedures have JUST REFUSED to work for me...
! PS ASSIST...
i have created a simple stored procedure (INSERT_DISTRICT) to insert values into a table (districts) and calling the same from delphi code.
The table has 3 columns, districtcode, districtname, dateset (dateset is set to the default date 'now')
If i call the proceure directly from interbase, i cannot see the values inserted into the database, yet the query executes and dateset column get a new value.
INTERBASE STORED PROCEDURE CODE:
connect "PORTFOLIO.gdb" USER="SYSDBA" password="masterkey";
SET TERM ^;
CREATE PROCEDURE insert_district
(
insDcode varchar(8),insDname varchar(20)
)
AS
BEGIN
INSERT INTO districts
(districtcode, districtname)
VALUES
(
:insDcode,
:insDname
);
END^
SET TERM ; ^
I am rather new to interbase and am using Interbase 7.1 and Delphi 7 (on windows 2003 server)-- stored procedures have JUST REFUSED to work for me...
! PS ASSIST...
i have created a simple stored procedure (INSERT_DISTRICT) to insert values into a table (districts) and calling the same from delphi code.
The table has 3 columns, districtcode, districtname, dateset (dateset is set to the default date 'now')
If i call the proceure directly from interbase, i cannot see the values inserted into the database, yet the query executes and dateset column get a new value.
INTERBASE STORED PROCEDURE CODE:
connect "PORTFOLIO.gdb" USER="SYSDBA" password="masterkey";
SET TERM ^;
CREATE PROCEDURE insert_district
(
insDcode varchar(8),insDname varchar(20)
)
AS
BEGIN
INSERT INTO districts
(districtcode, districtname)
VALUES
(
:insDcode,
:insDname
);
END^
SET TERM ; ^