FBSPGenerator screenshots		See below for some screenshots of FBSPGenerator in action: [ 1 ]   [ 2 ]   [ 3 ]   [ 4 ] or go back to the main page of FBSPGenerator  (Note: Screenshots taken from the SynEdit version - and yes, you can change the colours ;-) - and don't get irritated by the window title, it is actually standalone (not in IB_SQL).
SQL statement		Here you can try your statement and choose which columns will be used to generate the different types of procedures: (Note atm no "weird" joins are supported, only "flat" selects)
Select Procedure		Generates a Select procedure. Be sure to include the right Order By clause when the result set is big (you can't create indexes on storedprocs, they are always returned in "natural" sp order). I plan to build in options for the input params here that would go into the Where clause of the For Select loop.
Insert procedure		By checking "Generator code", you can generate code which uses a Generator to retrieve the next value and return this as an output param from the SP.
Update procedure		This generates the source for a procedure to update a single row based on the PK.
Delete procedure		Well guess what that'll look like ... (no it *doesn't* Delete From with no where clause <g>) Feel free to contact me if you have any questions or suggestions.