first stored procedure with Firebird 1.5.

Thread View: borland.public.interbase.opensource

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Dierk Fri, 18 Nov 2005 18:23

#202

Author: Dierk
Date: Fri, 18 Nov 2005 18:23

48 lines
2116 bytes

Hi I want ot write my first stored procedure with Firebird 1.5.
But it is very hard for me. It don�t work.
I run always in trouble. Where�s the problem??

Thanks
Dierk


CREATE PROCEDURE INSUPD_MESSWERT(
    iStation SMALLINT,
    iMesspunkt SMALLINT, iZeitpunkt TIMESTAMP,
    iStatus SMALLINT,
    iMesswert DOUBLE PRECISION )
AS
BEGIN
  INSERT INTO Messwerte(Station, Messpunkt, Zeitpunkt, Status, Messwert)
  VALUES (:iStation, :iMesspunkt, :iZeitpunkt, :iStatus, :iMesswert);

  /*Doppelter Prim�rindex */
  WHEN SQLCODE -803 do

    UPDATE Messwerte SET
      Station = :iStation,
      Messpunkt = :iMesspunkt,
      Zeitpunkt = :iZeitpunkt,
      Status = :iStatus,
      Messwert = :iMesswert
    WHERE (Station=:iStation) and (Messpunkt=:iMesspunkt) and
(Zeitpunkt=:iZeitpunkt)
  END

END



////////////////////////////////////////////////////////////
Statement #1:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command

Statement #2:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 4, char 3
WHEN

////////////////////////////////////////////////////////////

Re: first stored procedure with Firebird 1.5.

#203

Author: Jeff Overcash (TeamB)
Date: Fri, 18 Nov 2005 18:27

11 lines
1438 bytes

Firebird is not InterBase.  You should ask Firebird questions on their forums.

Dierk wrote:
> 
> Hi I want ot write my first stored procedure with Firebird 1.5.

-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
Your friends will know you better in the first minute you meet than your
acquaintances will know you in a thousand years.    (R Bach)

Re: first stored procedure with Firebird 1.5.

#204

Author: Aage Johansen
Date: Fri, 18 Nov 2005 19:30

27 lines
1770 bytes

Dierk wrote:
> Hi I want ot write my first stored procedure with Firebird 1.5.
> But it is very hard for me. It don�t work.
> I run always in trouble. Where�s the problem??

Firebird <> InterBase.

You can check the newsgroups/mailinglists for Firebird here:
http://www.firebirdsql.org/index.php?op=lists

Another starting point is:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1092334448:106436&page=ibp_groups

Groups are mirrored on news.atkin.com

(Note that both Firebird and InterBase are OnTopic on that support list)


There's also the more general 
"borland.public.delphi.database.sqlservers" where
any _sqlserver_ is OnTopic.


--
Aage J.
ps
You'll probably need a "SET TERM ..." before and after your code.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads