What tool are you using to write your stored procedures? I think you only have to worry about Set Term stuff if you are running a script with multiple statements etc...
Dial up www.ibexpert.com, they have a cut down free version and a demo version... Great tool. Colin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of vss Sent: Friday, 20 February 2004 2:58 p.m. To: NZ Borland Developers Group - Delphi List Subject: RE: [DUG] Cant Create Stored Proc bloody hell !! This is goin gto take me longer than I expected ! I have also been reading stuff about MSDE that indicates that MSDE might be ok for my situation.....hmmmm.....decisions descisons :-( Jeremy -----Original Message----- From: Myles Penlington <[EMAIL PROTECTED]> To: "'NZ Borland Developers Group - Delphi List'" <[EMAIL PROTECTED]> Date: Fri, 20 Feb 2004 14:40:13 +1300 Subject: RE: [DUG] Cant Create Stored Proc > FB/IB SP debugging leaves a lot to be desired. > > There must be many of us of have pulled our lots of hair over stored > proc syntax error messages Grasping for what's left ... > > You need a space here > SET TERM !! ; > > M. > > -----Original Message----- > From: vss [mailto:[EMAIL PROTECTED] > Sent: Friday, 20 February 2004 14:39 > To: NZ Borland Developers Group - Delphi List > Subject: Re: [DUG] Cant Create Stored Proc > > > There must be something totally wackey here, I get an error even doing > SET TERM !!; > > I am going off Firebird pretty quickly...grrr > > -----Original Message----- > From: "Paul Mckenzie" <[EMAIL PROTECTED]> > To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]> > Date: Fri, 20 Feb 2004 14:10:34 +1300 > Subject: Re: [DUG] Cant Create Stored Proc > > > Thoughts - I am not an IB expert... > > > > Have you done the "Set Term" thing? > > I believe there should be a ";" at the end of the SQL statement. > > AFAIK there is a "IN" construct in IB - there definitely is in IB6+ > > > > HTH > > > > Regards > > Paul McKenzie > > Analyst Programmer > > SMSS Ltd. > > > > ----- Original Message ----- > > From: "vss" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, February 20, 2004 1:50 PM > > Subject: [DUG] Cant Create Stored Proc > > > > > > > HI all. > > > I seem to have a problem where I cant create a Stored proc in > > Firebird. > > > I have looked at examples but still I cant see the error here it > is. > > Can > > > anyone see the error? > > > If I try to put :- > > > > > > suspend; > > > end > > > > > > and the end, suspend is an unknown token, and then if i take it > out, > > END > > > is an unknown token ! > > > > > > Thanks, Jeremy > > > > > > CREATE PROCEDURE ExtensionSummary_ssp ( iExtensionFrom integer, > > > iExtensionTo integer, > > > dDateFrom date, > > > dDateTo date, > > > tTimeFrom time, > > > tTimeTo time > > > ) > > > RETURNS > > > ( > > > total_calls integer, call_date date , call_time time, > > > call_duration time, call_extension integer, call_trunk integer, > > > call_type char(1), call_dialed_number Char(50), call_destination > > char > > > (50), > > > total_cost decimal(12,2), cost decimal(12,2), Account char(50), > > > CallerID char(50), extension_name char(5) > > > ) > > > AS > > > > > > Begin > > > > > > select count(*) as total_calls,ch.call_date,ch.call_time, > > > > > > ch.call_duration,ch.call_extension,ch.call_trunk,call_type,ch.call_dia > l > > ed_ > > > number, ch.map_desc as call_destination, SUM(Cost) as total_cost, > > > ch.cost , ch.acc_desc as Account,ch.CallerID, ch.call_extension as > > > extension_name, 'Date From 01/01/2004 to 20/02/2004 and Time From > > > 00:00:00 to 23:59:59' as date_from, 'Extension From 200 to 211' as > > > extn_from, 'Extension Report' as Report_title, 'Brophy Knight and > > > Partners'as companyname from callhistory ch left join extension ex > > > on ex.number = ch.call_extension WHERE ch.call_extension >= 210 > > > and ch.call_extension <=299 AND ch.call_date between '01 December > > > 2003' and '20 December 2003' AND > > cast > > > (ch.call_time as time) between cast('12:00:00' as time) and cast > > > ('23:00:00' as time) AND (call_type_id in (1,2,3,4,5,7,8,6,9,0)) > > > group by > > > > > > ch.call_extension,ch.call_date,ch.call_time,ch.call_duration,ch.call_t > r > > unk > > > > > > ,ch.call_type,ch.call_dialed_number,Call_destination,Account,ch.Caller > I > > D,c > > > h.map_desc,ch.call_destination, ch.acc_desc, ch.Account, ch.cost, > > > ch.call_extension,ex.owner > > > > > > end > > > > > > _______________________________________________ > > > Delphi mailing list > > > [EMAIL PROTECTED] > > > http://ns3.123.co.nz/mailman/listinfo/delphi > > > > > > _______________________________________________ > > Delphi mailing list > > [EMAIL PROTECTED] > > http://ns3.123.co.nz/mailman/listinfo/delphi > > _______________________________________________ > Delphi mailing list > [EMAIL PROTECTED] > http://ns3.123.co.nz/mailman/listinfo/delphi > _______________________________________________ > Delphi mailing list > [EMAIL PROTECTED] > http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ###################################################################### Attention: The information in this email and in any attachments is confidential. If you are not the intended recipient then please do not distribute, copy or use this information. Please notify us immediately by return email and then delete the message from your computer. Any views or opinions presented are solely those of the author. ###################################################################### _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
