RE: [gnome-db] input values in SQL view



On Fri, 2003-01-17 at 23:03, Adam Tauno Williams wrote:
> >>I've just implemented support for input values in the SQL window, so now
> >>you can do things like:
> >>update table set field1 = :field1, field2 = ':field2'
> >>and mergeant will ask you for :field1 and :field2 values.
> >Nice feature!
> 
> Fabulous!  Will this work are parameters for stored procedures as well?
> 
> select call p_shop_job_totals(:job_id)

yes, it parses the string, and when it finds :something, it assumes it's
a placeholder and asks the user for a value, regardless of the command
you enter (normal selects, updates, calls to procs, etc).

cheers




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]