PDA

View Full Version : Lookup Tables in Web Applications



Paul Phang
3-Jan-2006, 10:05 PM
Hi everyone,

I noticed the sample Order Entry program has a Vendor's Selection List in
the Inventory Items entry.

Kindly advise how I can create Selection Lists or Lookup Tables when I use
the wizard to generate Web Objects.

I have tried in vain to achieve this even after I set the Lookup Object in
the data file like how it is done in VDF.

When I compile my VDF program the Lookup Table is available but not for the
Web program.

Thank you and looking forward to any helpful advise.


Regads,
Paul

Knut Sparhell
4-Jan-2006, 02:06 AM
Paul Phang wrote:

> I have tried in vain to achieve this even after I set the Lookup Object in
> the data file like how it is done in VDF.

Lookup tables are either reports (many records) or select options (a
combo, suitable for fewer records). For reports, use the report wizard
to generate it, for selection lists use the ddValue function with
DDPARENTCOMBO or DDRECS option.

VDF wizards doesn't diretly support the integration between a lookup
report and a data entry page. This is something you have to implement
yourself, like adding a querystring parameter to load the right parent
record and reload the page using script.

Selection lists are automatically loaded with all selection options.
Such may also be accomplished using a report, but this will need some
client scripting. Thera are thre methids for reports:

* Load report in same window
* Load report in new window using script
* Load report in a popup window using script
* Load report in a hidden div, appearing when needed, using script

Or, if less than a few 100 records in parent, a select (combo) is best
used and to use such you only need to add a parameter to your ddValue in
ASP.

--
Knut Sparhell, Norway

Paul Phang
4-Jan-2006, 10:22 AM
Thank you for your advise.

I actually thought that the selection list is automatically generated for
web objects just like VDF.

Regards,
Paul

"Knut Sparhell" <knut@sparhell.no> wrote in message
news:W#nuc1PEGHA.728@dacmail.dataaccess.com...
> Paul Phang wrote:
>
> > I have tried in vain to achieve this even after I set the Lookup Object
in
> > the data file like how it is done in VDF.
>
> Lookup tables are either reports (many records) or select options (a
> combo, suitable for fewer records). For reports, use the report wizard
> to generate it, for selection lists use the ddValue function with
> DDPARENTCOMBO or DDRECS option.
>
> VDF wizards doesn't diretly support the integration between a lookup
> report and a data entry page. This is something you have to implement
> yourself, like adding a querystring parameter to load the right parent
> record and reload the page using script.
>
> Selection lists are automatically loaded with all selection options.
> Such may also be accomplished using a report, but this will need some
> client scripting. Thera are thre methids for reports:
>
> * Load report in same window
> * Load report in new window using script
> * Load report in a popup window using script
> * Load report in a hidden div, appearing when needed, using script
>
> Or, if less than a few 100 records in parent, a select (combo) is best
> used and to use such you only need to add a parameter to your ddValue in
> ASP.
>
> --
> Knut Sparhell, Norway

Knut Sparhell
4-Jan-2006, 09:27 PM
Paul Phang wrote:
> Thank you for your advise.
>
> I actually thought that the selection list is automatically generated for
> web objects just like VDF.

Parent lookups are not automatically generated in VDF. Only validation
lookups are. But there are wizards for this, for both Windows and web
applications. For web you may use the report wizard, or perhaps better,
drag a web report class of the Studio object tool to the web browser
object and enter the code in each event procedure.

For web applications validation lists (codes) are runtime generated
using the correct ddValue option in ASP (makes a select type html input
control, or just the options as an option list).

Therefore, this is quite similar.

--
Knut Sparhell, Norway