×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

WHats wrong with this stored procedure?

WHats wrong with this stored procedure?

WHats wrong with this stored procedure?

(OP)
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 ; ^

RE: WHats wrong with this stored procedure?

Probably you have to refresh your query in delphi

Steven van Els
SAvanEls@cq-link.sr

RE: WHats wrong with this stored procedure?

And make sure you COMMIT the transaction from which you're executing the procedure.

Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close