Improve company productivity with a Business Account.Sign Up


Firbird. SQL

Posted on 2007-12-06
Medium Priority
Last Modified: 2013-12-09
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

 ( input_parameter_name < datatype>, ... ) 
 ( output_parameter_name < datatype>, ... )
DECLARE VARIABLE variable_name < datatype>; 
  /* write your code here */ 

Open in new window

Question by:AlanGlynSmith
LVL 19

Expert Comment

by:Gary Benade
ID: 20419813
LVL 20

Accepted Solution

hes earned 150 total points
ID: 20420849
Did you take a look at SQl Express ?
LVL 19

Expert Comment

by:Nick Upson
ID: 20423089
you need this book before you go any further

It's not cheap but it will save you literally weeks of time

Author Closing Comment

ID: 31413106
Doh! Brilliant, perfect solution. Why can we never see what's in front of our faces?

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

I recently worked on a Wordpress site that utilized the popular ContactForm7 ( plug-in that only sends an email and does not save data. The client wanted the data saved to a custom CRM database. This is my solution.
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question