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_dial > > 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_tr > > unk > > > > > > ,ch.call_type,ch.call_dialed_number,Call_destination,Account,ch.CallerI > > 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
