RE : [development-axapta] Adding new dataSource to Form

Steeve Gilbert Fri, 02 Jan 2004 22:36:22 -0800

I've looked and newQuery is not called when I launch InventOnHandItem. Anyway, I've got a similar modification to do on InventTransOnOrder and this form look less confusing so maybe you can help me complete the modification on this form and I'll have a better Idea on how to do it on InventOnHandItem.

So, on InventTransOnOrder I need to add the CustTable.NameAlias if the Reference is "Sales Order". Still, we must be able to use "Find..." and "Filter" function on the CustTable.NameAlias field. I did the same thing as on InventOnHandItem : Add a new dataSource CustTable with these properties:

JoinSource : InventTrans
LinkType   : InnerJoin
Table      : CustTable

Results : No NameAlias is displayed. InnerJoin is just for test purpose 'cause I'll eventually have to set it to OuterJoin to also list entries that don't have "Account Number". The problem is when I set it to OuterJoin the form literally crash with these errors message:

------
Cannot select a record in Customers (CustTable).
The join does not contain any link between the joined tables in the where clause.
(C) \Classes\QueryRun\next
(C) \Classes\FormDataSource\executeQuery
(C) \Forms\InventTransOnOrder\Data Sources\InventTrans\Methods\executeQuery - line 12
------

I don't know why it doesn't crash with "InnerJoin".

Setting the LinkType to "Active" result in the NameAlias displaying only for the first and selected rows.

Thanks for reading my mess, just wanted to add has much detail as possible.
Thanks for your fast response Harry.

Any ideas I can search on are welcomed! ;-)

Steeve...

-----Message d'origine----- De : Harry [mailto:[EMAIL PROTECTED] Envoyé : 6 octobre, 2003 16:16 À : [EMAIL PROTECTED] Objet : RE: [development-axapta] Adding new dataSource to Form

hi

InventOnHand form displays data by a very roundabout way! You will have to
change the methods on inventsum table to return the namealias. I think the
method is newQuery()

regards

harry

-----Original Message-----
From: Steeve Gilbert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 7 October 2003 9:12 a.m.
To: [EMAIL PROTECTED]
Subject: [development-axapta] Adding new dataSource to Form

Hello everyone,

 I need to add the InventTable.NameAlias field to the InventOnHandItem
form.  The challenge is that the "Find..." and "Filter" (right-click)
function must be available for this field.  I add a new DataSource
called "InventTable" to the InventOnHandItem form.  Here's the
properties of the new DataSource:

DelayActive : No
JoinSource  : InventSum
LinkType    : InnerJoin
Table       : InventTable

In the form's grid, I add the field and link it to this new DataSource.

(Doesn't seems to be of any help but...) I add a relation on InventSum
so that InventSum and InventTable are linked by ItemId.

Results : The field NameAlias is always empty!

With so much try/failed attempt I did discovered that if I set
"LinkType" to "Active".  The first row and the selected row both have
the good NameAlias.  But all the others "NameAlias" fields are empty.

Got Tips?

Steeve...

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Yahoo! Groups Sponsor

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE : [development-axapta] Adding new dataSource to Form

Reply via email to