Building links in SQL-based report?
Date: Mon, 23 Oct 2000 21:46:53 GMT
Message-ID: <8t2bkc$nqp$1_at_nnrp1.deja.com>
In WebDB 2.2 I used the report wizard to
create a workable report which links to
a form. Now I want to add a DECODE( )
expression as a column in this report,
having a link of its own to a different
form.
I figured I could lift the existing
SQL 'SELECT' statement from the source or
the package body and edit it to include
the DECODE( ) as part of a SQL-based
report. However before making any changes
the SQL 'SELECT' is regarded as Invalid.
The problem appears to be a special character
'%3D', as used in this snippet of the Select:
p_arg_names=_lastname_cond& p_arg_values=%3D& p_arg_names=_busname_cond$ p_arg_values=%3D&
I'm assuming %3D (ascii '=') is a placeholder of some kind? Any thoughts or experience?
TIA and best wishes, Jon Angel HHS
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Oct 23 2000 - 23:46:53 CEST