Re: WebDB links

Hi Szymon,

The way I got around having static information in my links was to use the Advanced SQL tab instead of the Text one. In the "After displaying the Footer" section, you would put code like this (I'm not sure if I handled your double quotes right, I don't use those sorts of URLs):

htp.p('<A HREF="http://domain/' ||
GetSchema(WEBDB.wwv_name_value.get_string( l_arg_names,l_arg_values,'YOUR_IN _PARAMETER_GOES_HERE') ) || '.RPT_MY_RAPORT.show"> Back to the report </a>');

This calls the function "GetSchema" with some in-parameter that you have selected in the SQL query of your report to dynamically return the schema value and stick it into your URL. "htp.p" is a predefined WebDB procedure that prints whatever you pass it. So it configures your "dynamic" link, then prints it at the bottom of the page for the user to click on.

Let me know if you have any questions, I hope this fixes your problem! -Sandy

Szymon Manduk <sm_at_profidata.com.pl> wrote in message news:Bu7W4.14020$zA1.340326_at_news.tpnet.pl...
> Hello!
>
> WebDB 2.1 / Oracle8i 1.5.0 / Windows NT
>
> I have simple report with one of the column pointing to Update Form where
> user can update or delete choosen row.
> After update I want to go back to the report and list once again rows,
> including changed one.
> My question is:
> How can I can create "back to the report" link on the Update Form?
>
> Of course in Text Option of the Update Form I can write code like this:
>
> <A HREF="http://domain/<SCHEMA>.RPT_MY_RAPORT.show"> Back to the report
 </a>
>
> but it contains static information and when I'll change domain or schema
> part of the adress the link will be invalid.
>
> Thanks for any help
>
> S.Manduk
>
>
Received on Tue May 23 2000 - 00:00:00 CEST