Check out IBExpert at www.ibexpert.com for auto generating views, selects
and stored procs. Pretty good stuff and well done.
John

-----Original Message-----
From: frank_ingermann [mailto:frank.ingermann@...]
Sent: Friday, March 22, 2002 7:17 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Request for help


Hi Jason,

> I wonder if anyone would have on hand or be willing to contribute

some code

> to IB_SQL.
>
> What I would like is the ability to click a button on the Cursor tab

(or the

> Query Forms) with a prepared SELECT statement and have it

automatically

> generate a SELECT procedure which will perform the exact same result

set.

Sounds like a fun thing to do. I'm actually writing something
quite similar atm for one of my own projects: i want to make
the same function that IBExpert offers (to create
nsert/Update/Delete/Select StoredProcs from any query).
So if you don't mind, i can give it a try. It would be nice
if you could give some more details about what exactly you want
to have (esp. what to do whith the StoredProc source after
generating it :-)

> If someone feels up to the task and does a good job, I'll forward a

CREDIT

> to your credit card of $50 or so. Not much but it would be my way of

taking

> you to a nice place to have dinner or something of the sort.

That's generous, but imho not necessary. Being able to work with
IBO is reward enough! (and as for the dinner, you'd have to add
the cost for a plane flight from Germany :-))

> I keep wanting to do this but I don't have the patience...
>
> Regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com

I'll see whether my patience is any better<g>...
You can contact me directly under frank@...

regards,
fingerman




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/