FBSPGenerator
Download nya,
Screenshots here.
back to top A small source code generator that produces code for Stored Procedures based on a Select statement.Uses either an ordinary TMemo or a TSynEdit with syntax highlighting for editing (set by compiler define, so you can compile it even if you don't have or want SynEdit).

I often use this same function in IBExpert or Marathon to create a raw body for a special storedproc with all the column definitions generated, but I'd like to have it self-coded in a freeware product (like IB_SQL or fiSPEd) so I made one myself... (sorry no download atm - still work in progress... see screenshots!. drop me a note if you want to test what's there already.)


requirements
back to top What you must have to be able to use FBSPGen:
VCL   FBSPGenerator is based on the VCL of Delphi 5/6 Professional.
IBObjects    Jason Wharton's IBObjects - the ulimate component suite for direct access to Firebird.


optionals back to top Things that are not necessary (ie. can be IFDEFd out) but are supported
SynEdit   The open source multi-line editing control also used in Marathon and IBConsole. Native VCL component (no wrapper around a Win ctrl). Download here from SynEdit's home on sourceforge.


installation back to top Read these instructions before downloading / installing! 
   
  • first, IBObjects (and optionally SynEdit) should be installed
  • drop me a note and I will send you a beta version.


downloads back to top Sorry, not yet available. Contact me if you absoultely want to have it now.


screenshots back to top  See here for some screenshots of FBSPGenerator in action.