RE: [gnome-db] input values in SQL view
- From: Rodrigo Moya <rodrigo gnome-db org>
- To: Adam Tauno Williams <adam morrison-ind com>
- Cc: GDA <gnome-db-list gnome org>
- Subject: RE: [gnome-db] input values in SQL view
- Date: 17 Jan 2003 23:34:31 +0100
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]