Bob,
Rather than using a select statement, you should modify the query of
your form. Type "this." and select "query()", then add
.dataSourceTable(tableNum<BOM_tempTable>. Then the method
"joinMode(JoinMode::JoinMode::NoExistsJoin) can be used.
You can use the find tool starting at the Form node to look for
methods containing text NoExistsJoin and you will see examples of
where the standard code modifies queries in forms.
I hope this helps,
Mary Ann
On Thu, May 1, 2008 at 7:07 AM, Bob <[EMAIL PROTECTED]> wrote:
>
>
>
>
> Hello Im quite new to ax and I need to do this:
>
> I have a form with 2 data sources
> 1: BOM_tempTable (will change name later)
> 2: productConfigTable
>
> In my form I have to show all the data in table 1 (bom_temptable)
> so I made a design like this:
> ...
> Grid:Grid
> StringEdit:PalleId -> BOM_tempTable.PALLETID (keeps changing to CAPS)
> StringEdit:ReolId -> BOM_tempTable.RackId
> StringEdit:Hyldeid -> BOM_tempTable.ShelfId
> StringEdit:Cover -> BOM_tempTable.Cover
>
> There is also a dropdown box on the design that refers to a baseenum
> with 4 items (Normal,PalleId,ReolId,HyldeId).
> When you select a thing in the dropdown it will
> run "BOM_tempTable_ds.executeQuery();"
>
> The idea is then when you pick one of the items in the dropdown the
> query should change to show the BOM_tempTable where (pickedItem)
> dosnt excist on table 2 I done this to try and get it to work.
>
> public void executeQuery()
> {
> MW_RM_ProductConfigTable _MW_RM_ProductConfigTable;
> ;
>
> switch (sortSelect.selection())
> {
> case BOM_tempFormSortSelect::HyldeId :
> select _BOM_tempTable
> index hint idx
> order by ShelfId
> notExists join _MW_RM_ProductConfigTable
> index hint bomIdx
> where _MW_RM_ProductConfigTable.ShelfId == _BOM_tempTable.ShelfId;
> break;
> ...(2 more case(s) with PALLETID and RackId)...
> case BOM_tempFormSortSelect::Normal :
> select _BOM_tempTable
> index hint idx
> order by recid;
> break;
> }
> super();
> }
> But when I do this there arnt any change I still just get the same
> date as when I open the form any help would be apriciated
>
> (the drop down box works fine when I select somthing It starts to
> scearch but the resault isnt correct cause I can find the items in
> the grid that are on the productconfigtable and I only want the ones
> that arnt there but are on bom_temptable)
>
> on the table BOM_tempTable I made 3 relations
> relation1
> BOM_tempTable.PALLETID == MW_RM_ProductConfigTable
> relation2
> ***.Rackid == ***.Rackid
> relation3
> ***.ShelfId == ***.ShelfId
>
> I tried using no relations and having all relations in one
> I cant figure out what is wrong :E
>
>
