Re: How to display image from lookup table in Designer?

Uzytkownik "Daniel Morgan" <damorgan_at_exxesolutions.com> napisal w wiadomosci news:1063261004.592813_at_yasure...
> Tomasz Wisz wrote:
>
> >I'm trying to display Image Item from lookup table and I get this error
> >while generation:
> >
> >CDG-01414 ERROR: Bound Item MIEJSCE_SIECI.Z11_GRAFIKA.L_GRF_OBRAZ: IMAGE
is
> >not an appropriate type for lookup item usage
> >
> >The master table is connected with the detail table (images) by the
lookup
> >link many-to-one.
> >I've tried to put the image's table to a new module and connect it with
the
> >master table, but I've got another error:
> >
> >CDG-00040 ERROR: Module Component Table Usage
> >MIEJSCE_SIECI.L_GRF.GRAFIKI.L_GRF: Many-to-one relationships are not
> >supported by this Generator
> >
> >Can somebody help me resolve the problem?
> >
> >Tomasz Wisz
> >
> >
> >
> >
> Are you trying to select images from an LOV? Please explain more fully
> what you are trying to do.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)

I have tables hierarhy Master-Details-Master like this:

PLACES --<one-to-many>-- GRAPHICS_ELEMENTS --<many-to-one>-- GRAPHICS

I need to display graphics elements and graphics in context of PLACES. I need to show all graphisc elements connected to one selected place. Each of this elements has a picture stored in table GRAPHICS (it's BLOB). So I have built a module "Places" with master table PLACES and another module "Graphics elements" with master table GRAPHICS_ELEMENTS and with lookup table GRAPHICS. The generator says graphics elements from the lookup table can't be shown:

CDG-01414 ERROR: Bound Item PLACES.GRAPHICS_ELEMENTS.L_GRP_IMEGE: IMAGE is not an appropriate type for lookup item usage

Why is that? Is there a solution for this?

I have rebuilt the modules stucture. I've removed the lookup table (GRAPHICS) and made another module called "Pictures" with GRAPHICS table in it. Next I've connected modules "Graphics elements" and "Pictures" with many-to-one key. The generator says this time:

CDG-00040 ERROR: Module Component Table Usage PLACES.L_GRP.GRAPHICS.L_GRP: Many-to-one relationships are not supported by this Generator

I have no clue what to do netx...

Tomasz Wisz, Poland Received on Fri Sep 12 2003 - 08:47:07 CEST