I have worked with Firebird / Interbase for about 12 years now and I must
admit I am stumped. I am writing a stored procedure that uses “TIME”
fields. I want to initialize a begin and end time and I keep getting
errors. I wrote as simple a stored procedure as I could to illustrate the
problem. I am setting up a StartTime and need to add an hour to the time
and store as an end time. I cannot get it to work and here is an example of
just setting EndTime = StartTime. I am using Firebird V1.5.5.4926.



What am I missing here?





CREATE PROCEDURE TP

AS

DECLARE VARIABLE Starttime TIME;

DECLARE VARIABLE Endtime TIME;

begin

StartTime = '08:00';

EndTime = StartTime; ß error occurs on this

end











Thanks for any help!



Jerry Sands





[Non-text portions of this message have been removed]