• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 737
  • Last Modified:

Firbird. SQL

Hi (basic I know, but frustrating) Just starting to port a Database over from SQL Server 2k to Firebird. (Some customers wont pay for SQL Server...  so what can you do?.... I hope Bill is listening?)

Using FlameRobin (not a problem basic but usable) and I just cannot get the syntax right for any Stored Procedures. (I have loads to bring over from SQl Server. I dont mind rewriting them but the syntax is doing my nut in!!)
Does anyone have any sample code? or even a PDF that explains Stored Procedure Syntax in FIrebird 2.0? Obviously the basic SQl query stuf i'm OK with but its the extra stuff in Firebird that is a puzzle such as the Set Term and Returns and Variables etc. If I delete them all then we get a wonderfully obtuse SQL error code = -104
Token unknown
No help files available as far as I can find out.


Many thanks


SET TERM ^ ;
 
CREATE PROCEDURE name 
 ( input_parameter_name < datatype>, ... ) 
RETURNS 
 ( output_parameter_name < datatype>, ... )
AS 
DECLARE VARIABLE variable_name < datatype>; 
BEGIN
  /* write your code here */ 
END^
 
SET TERM ; ^

Open in new window

0
AlanGlynSmith
Asked:
AlanGlynSmith
1 Solution
 
Gary BenadeCommented:
0
 
hesCommented:
Did you take a look at SQl Express ?

http://www.microsoft.com/sql/editions/express/default.mspx
0
 
Nick UpsonPrincipal Operations EngineerCommented:
you need this book before you go any further

http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1196973593:1978743&page=ibp_firebird_book

It's not cheap but it will save you literally weeks of time
0
 
AlanGlynSmithAuthor Commented:
Doh! Brilliant, perfect solution. Why can we never see what's in front of our faces?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now