Re: Forms 6i Tab Canvas "Irregularities"?

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sun, 16 Apr 2006 16:18:35 GMT
Message-ID: <v7u0g.66052$H71.44446@newssvr13.news.prodigy.com>

> : No relationships are defined. The blocks are loaded by a simple WHERE
> : query. Each of the blocks display information from only one table.
> :
>
> how are the blocks 'loaded by a simple WHERE query'? are the blocks based
on
> tables or did you right some code to load them?
>
> ++ mcs
>
>

In the Block Property Pallete.

For the Batting block, which is based on a BATTING table, the WHERE clause is:

batting.player_id = :player.key_player_id

For the Pitching block, which is bases on a PITCHING table, the WHERE clause is:

pitching.player_id = :player.key_player_id Received on Sun Apr 16 2006 - 11:18:35 CDT