RE: [development-axapta] XML

2005-04-06 Thread Lars Mikkelsen 





You could do this if you are planning to use the BizTalk interface. If you
just want to read and parse an xml file, the BizTalk interface is way to
difficult to use. There is really no need to write a schema or write
classes/methods in order to parse an xml document.

 

Axapta has a wrapper for the Microsoft MSXML parser. This parser can be used
to read or create xml documents. The wrapper for this parser can be found in
the class tree node prefixed with "XML".  The main class is "XmlDocument"
and you can search the AOT for usage of this class. 

 

You can also search the internet for samples of using MSXML. It should be
pretty easy to translate VB samples if you can't find any Axapta samples.

 

 

  _  

From: Sandeep Kr. Shukla [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 05, 2005 8:49 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] XML

 



Hello,

For this you will have to write the schema for that XML file and after
that you will have to write the classes\methods for each node in Axapta
to read the data from the XML file. After that you will have to attach
the methods to the nodes in the XML schema that you have specified in
the Axapta. When you process the in the gateway queue then the data will
be imported in the Axapta.

Regards, 
Sandeep Kr. Shukla 


-Original Message-
From: studlee15 [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 04, 2005 7:04 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] XML




I have the task of importing data using an XML file.  I have done this 
before at me previous job, but I cannot recall quite how I did it.  
Does anyone of any example of how to read through an XML file?

Thanks.









Yahoo! Groups Links








  --


email-body was scanned and no virus found


[Non-text portions of this message have been removed]







  _  

Yahoo! Groups Links

*  To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
  
*  To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
 
  
*  Your use of Yahoo! Groups is subject to the Yahoo!
  Terms of Service. 



[Non-text portions of this message have been removed]













Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] document_all

2005-04-06 Thread kram1976 





Your document is attached.



[Non-text portions of this message have been removed]













Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Axapta upgrade from 2.5 to 3.0

2005-04-06 Thread Arkadiusz Krasucki 





Hi

Does anybondy have any materials or know something about upgrade Axapta 2.5
to 3.0.
Is there any oficial Microsoft documents about that

Regards

Arkadiusz Krasucki
Integris Poznan














Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] XML

2005-04-06 Thread LarsBMikkelsen 


You could do this if you are planning to use the BizTalk interface. If you just 
want to read and parse an xml file, the BizTalk interface is way to difficult 
to use. There is really no need to write a schema or write classes/methods in 
order to parse an xml document.
 
Axapta has a wrapper for the Microsoft MSXML parser. This parser can be used to 
read or create xml documents. The wrapper for this parser can be found in the 
class tree node prefixed with “XML”.  The main class is “XmlDocument” and you 
can search the AOT for usage of this class. 
 
You can also search the internet for samples of using MSXML. It should be 
pretty easy to translate VB samples if you can’t find any Axapta samples.
 

-- Original message -- 


Hello,

For this you will have to write the schema for that XML file and after
that you will have to write the classes\methods for each node in Axapta
to read the data from the XML file. After that you will have to attach
the methods to the nodes in the XML schema that you have specified in
the Axapta. When you process the in the gateway queue then the data will
be imported in the Axapta.

Regards, 
Sandeep Kr. Shukla 


-Original Message-
From: studlee15 [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 04, 2005 7:04 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] XML




I have the task of importing data using an XML file.  I have done this 
before at me previous job, but I cannot recall quite how I did it.  
Does anyone of any example of how to read through an XML file?

Thanks.









Yahoo! Groups Links








  --


email-body was scanned and no virus found


[Non-text portions of this message have been removed]







Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
  
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
  
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 

[Non-text portions of this message have been removed]






 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

[development-axapta] Re: item with zero qty but cost have value

2005-04-06 Thread jaimesq 






Hi Kongyu:

Check if all the transactions have been complete settled.

The problem is that Axapta versions 3.0 Sp2 and Sp3 have some 
mistakes that don't settle all the transaction and leave 
transactions not settled.
If you sum the cost of this transactions you get the amount.

Some of the errors:
  - Transfer transactions partially settled (resolved in a future sp)
  - Return transactions incorrectly settled (resolved in a future sp)
  - Marked transactions partially settled (in decision for version 
4.0)

Many of the problems are going to be resolved in a future service 
pack (with other improvement) or in the version 4.0.

Best regards.

Jaime.















Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Windows user and terminal server

2005-04-06 Thread Matt Benic 





Hi all,
We want to do a test run of Axapta over terminal server next week, but we
are unsure of the correct configuration ITO window users. We have had no end
of pain trying to have different windows users run Axapta on the same
machine (since web deployment installs the app in per-user folders, and we
can't seem to change that).

When we configure our terminal server, should we be allowing remote users to
all log in with the same windows user, or insatall the Axapta client to a
common directory using the standard installer and let them run Axapta
directly instead of through the web deployment component?

Thanks and Regards,

Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division

"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com













Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Windows user and terminal server

2005-04-06 Thread Pieter Wijnen 





Personally I would use a standard (common) install & separate Windows
Users (due to profie settings etc)
 
Pieter

  _  

From: Matt Benic [mailto:[EMAIL PROTECTED] 
Sent: 6. april 2005 11:36
To: Axapta Dev
Cc: Hennie Potgieter
Subject: [development-axapta] Windows user and terminal server



Hi all,
We want to do a test run of Axapta over terminal server next week, but
we
are unsure of the correct configuration ITO window users. We have had no
end
of pain trying to have different windows users run Axapta on the same
machine (since web deployment installs the app in per-user folders, and
we
can't seem to change that).

When we configure our terminal server, should we be allowing remote
users to
all log in with the same windows user, or insatall the Axapta client to
a
common directory using the standard installer and let them run Axapta
directly instead of through the web deployment component?

Thanks and Regards,

Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division

"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com






  _  

Yahoo! Groups Links


*  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
    
*  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]

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




[Non-text portions of this message have been removed]













Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Joining 3 tables with QueryBuildDataSource

2005-04-06 Thread Anton Tjiptadi 






Hi,
I want to join 3 tables with QueryBuildDataSource (QBDS), the
statement is like this :

qbds = q.addDataSource(tablenum(InventJournalTrans));

qbds1 = qbds.addDataSource(tablenum(InventDim));
qbds1.joinMode(joinmode::InnerJoin);
qbds1.addLink(fieldnum(InventDim, InventDimId),fieldnum
(InventJournalTrans, InventDimId));
qrange = qbds1.addRange(fieldnum(InventDim, InventLocationId));
qrange.value(WareId);

qbds2 = qbds1.addDataSource(tablenum(InventTable));
qbds2.joinMode(joinmode::InnerJoin);
qbds2.addLink(fieldnum(InventJournalTrans, ItemId), fieldnum
(InventTable, ItemId));
qrange = qbds2.addRange(fieldnum(InventTable, ESG_ProductType));
qrange.value(PrdType);

-
...the goal is, I want join table InventJournalTrans to InventDim
with key InventDimId and join table InventJournalTrans to
InventTable with key ItemId, but.


strange thing is the result query is like this :
SELECT * FROM InventJournalTrans
JOIN * FROM InventDim WHERE InventJournalTrans.InventDimId =
InventDim.inventDimId
AND ((InventLocationId = 01))
JOIN * FROM InventTable WHERE InventDim.InventLocationId =
InventTable.ItemId
AND ((ESG_ProductType = 11))

---> failure is the join between InventJournalTrans and InventTable
went in to the wrong key, was I making a mistake in QBDS ??

can anyone help me ?

thanks in advance,
















Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] AOS network problems

2005-04-06 Thread Stefan Osterburg 


Hello,

I have the following problem with my AOS server:

It runs fine (users can connect and work normally) up to some point.
Then I get the following message from the AOS server in the event log:

"Server Manager: Fatal socket error 10054 occured while receiving 
service requests from clients."

Afterwards no new users can connect to the AOS ("No AOS could be
found with the current configuration"). Users still connected to the
AOS can continue to work normally.

To fix the problem I have to restart the AOS service (restarting only
the AOS instance is not enough).

Does anyone know what causes this problem, and how to prevent it from
happening?

Regards
Stefan Osterburg





 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

RE: [development-axapta] Windows user and terminal server

2005-04-06 Thread Matt Benic 





Thanks Pieter,

By that do you mean using the install disk and re-installing Axapta for each
windows user (if you can do that), or just installing it to a common
location?

Regards,

Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division

"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com 


-Original Message-
From: Pieter Wijnen [mailto:[EMAIL PROTECTED]
Sent: 06 April 2005 11:53 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Windows user and terminal server




Personally I would use a standard (common) install & separate Windows
Users (due to profie settings etc)

Pieter

  _

From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 6. april 2005 11:36
To: Axapta Dev
Cc: Hennie Potgieter
Subject: [development-axapta] Windows user and terminal server



Hi all,
We want to do a test run of Axapta over terminal server next week, but
we
are unsure of the correct configuration ITO window users. We have had no
end
of pain trying to have different windows users run Axapta on the same
machine (since web deployment installs the app in per-user folders, and
we
can't seem to change that).

When we configure our terminal server, should we be allowing remote
users to
all log in with the same windows user, or insatall the Axapta client to
a
common directory using the standard installer and let them run Axapta
directly instead of through the web deployment component?

Thanks and Regards,

Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division

"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com






  _

Yahoo! Groups Links


*  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/

*  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]

be>

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




[Non-text portions of this message have been removed]







Yahoo! Groups Links




















Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

AW: [development-axapta] ODBC connection using file DSN

2005-04-06 Thread Matthias Schuster 





Hi Bjoern,
 
I wrote some jobs using exeldata. Text files work the same way.
You have to set up an odbc-datasource with the text-file driver. 
 
Here’s the code for an excel solution.
 
Regards matthias
 
LoginProperty LP = new LoginProperty();
    OdbcConnection myConnection;
    Statement myStatement;
    ResultSet myResult;
    LP.setDSN("Excel-Data");
 
    try
    {
    myConnection = new OdbcConnection(LP);
    }
    catch
    {
    info("Check username/password.");
    return;
    }
    myStatement = myConnection.createStatement();
    myResult = myStatement.executeQuery("SELECT * from Tab1");
    while (myResult.next())
    {
    sleep(100);
    print myResult.getString(3);
    }
    pause;
  _  

Von: Bjørn Gudbrand Idstad [mailto:[EMAIL PROTECTED] 
Gesendet: Dienstag, 5. April 2005 13:14
An: development-axapta@yahoogroups.com
Betreff: [development-axapta] ODBC connection using file DSN
 

Hi!
    
Does anyone know if it is possible to create an ODBC connection in Axapta using a file DSN?
And if so, how do I refer to this datasource using LoginProperty.setDSN("")? 

Regards 
Bjørn


[Non-text portions of this message have been removed]






  _  

Yahoo! Groups Links
*  To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
  
*  To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]  
  
*  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service  . 


[Non-text portions of this message have been removed]













Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Import information from excel

2005-04-06 Thread jaiver avila 





I am interested in the code for execute a job, for
import DIRECTLY FROM EXCEL to table ledgerjournaltrans.

_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] AOS network problems

2005-04-06 Thread Pieter Wijnen 





Might be a Network related problem - Check Network
Cards/Cabling/Switches etc

Make sure that SQL Server only Accepts TCP/IP 

HTH

Pieter

-Original Message-
From: Stefan Osterburg [mailto:[EMAIL PROTECTED] 
Sent: 6. april 2005 14:14
To: development-axapta@yahoogroups.com
Subject: [development-axapta] AOS network problems



Hello,

I have the following problem with my AOS server:

It runs fine (users can connect and work normally) up to some point.
Then I get the following message from the AOS server in the event log:

"Server Manager: Fatal socket error 10054 occured while receiving
service requests from clients."

Afterwards no new users can connect to the AOS ("No AOS could be found
with the current configuration"). Users still connected to the AOS can
continue to work normally.

To fix the problem I have to restart the AOS service (restarting only
the AOS instance is not enough).

Does anyone know what causes this problem, and how to prevent it from
happening?

Regards
Stefan Osterburg





 
Yahoo! Groups Links



 
















Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] Windows user and terminal server

2005-04-06 Thread Pieter Wijnen 





One common installation for all users.
Also use one config file to make sure everybody has the same Axapta
environment
 
i.e 
Make a Shortcut with target simmilar to:
 
%programfiles%\Navision\Axapta\Ax32.exe \MyConfig.axc
 
HTH
 
Pieter 

  _  

From: Matt Benic [mailto:[EMAIL PROTECTED] 
Sent: 6. april 2005 14:40
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Windows user and terminal server



Thanks Pieter,

By that do you mean using the install disk and re-installing Axapta for
each
windows user (if you can do that), or just installing it to a common
location?

Regards,

Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division

"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com 


-Original Message-
From: Pieter Wijnen [mailto:[EMAIL PROTECTED]
Sent: 06 April 2005 11:53 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Windows user and terminal server




Personally I would use a standard (common) install & separate Windows
Users (due to profie settings etc)

Pieter

  _

From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 6. april 2005 11:36
To: Axapta Dev
Cc: Hennie Potgieter
Subject: [development-axapta] Windows user and terminal server



Hi all,
We want to do a test run of Axapta over terminal server next week, but
we
are unsure of the correct configuration ITO window users. We have had no
end
of pain trying to have different windows users run Axapta on the same
machine (since web deployment installs the app in per-user folders, and
we
can't seem to change that).

When we configure our terminal server, should we be allowing remote
users to
all log in with the same windows user, or insatall the Axapta client to
a
common directory using the standard installer and let them run Axapta
directly instead of through the web deployment component?

Thanks and Regards,

Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division

"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com






  _

Yahoo! Groups Links


*  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/

*  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]

be>

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




[Non-text portions of this message have been removed]







Yahoo! Groups Links













  _  

Yahoo! Groups Links


*  To visit your group on the web, go to:
  http://groups.yahoo.com/group/development-axapta/
    
*  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]

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




[Non-text portions of this message have been removed]













Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

AW: [development-axapta] Import information from excel

2005-04-06 Thread Andrae, Tobias 





Hi Jaiver,

just take a look at SysExcel and maybe at the ImportWizard classes ;-))
hth Tobias

-Ursprüngliche Nachricht-
Von: jaiver avila [mailto:[EMAIL PROTECTED] 
Gesendet: Mittwoch, 6. April 2005 16:35
An: development-axapta@yahoogroups.com
Betreff: [development-axapta] Import information from excel



I am interested in the code for execute a job, for
import DIRECTLY FROM EXCEL to table ledgerjournaltrans.

_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com





 
Yahoo! Groups Links



 
















Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [development-axapta] AOS network problems

2005-04-06 Thread Malcolm Burtt 


Hi

We've experienced an identical problem at one of our clients. We got around the 
problem by setting an idle timeout on the AOS instance and setting it up to 
start on demand.

Regards

Malcolm Burtt
Global IT Group 
"Business Solutions designed for YOUR business processes" 
Global IT Group is the trading name of Touchstone Global Business Solutions 
Ltd. and is part of the Touchstone Group PLC.



-Original Message-
From: Stefan Osterburg [mailto:[EMAIL PROTECTED]
Sent: 06 April 2005 13:14
To: development-axapta@yahoogroups.com
Subject: [development-axapta] AOS network problems




Hello,

I have the following problem with my AOS server:

It runs fine (users can connect and work normally) up to some point.
Then I get the following message from the AOS server in the event log:

"Server Manager: Fatal socket error 10054 occured while receiving 
service requests from clients."

Afterwards no new users can connect to the AOS ("No AOS could be
found with the current configuration"). Users still connected to the
AOS can continue to work normally.

To fix the problem I have to restart the AOS service (restarting only
the AOS instance is not enough).

Does anyone know what causes this problem, and how to prevent it from
happening?

Regards
Stefan Osterburg





 
Yahoo! Groups Links



 








 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

Re: [development-axapta] Import information from excel

2005-04-06 Thread Roberto Pineda 





Hello.

Does it have to be job?

Try using 'Definition Groups' in
Administration\Periodic\Data export/import.


--- jaiver avila <[EMAIL PROTECTED]> wrote:
> 
> I am interested in the code for execute a job, for
> import DIRECTLY FROM EXCEL to table
> ledgerjournaltrans.
> 
>
_
> Do You Yahoo!?
> Información de Estados Unidos y América Latina, en
> Yahoo! Noticias.
> Visítanos en http://noticias.espanol.yahoo.com
> 
> 
> 
> 

Roberto Pineda

_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com












Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[development-axapta] Re: Joining 3 tables with QueryBuildDataSource

2005-04-06 Thread ozzage 






--- In development-axapta@yahoogroups.com, "Anton Tjiptadi"
<[EMAIL PROTECTED]> wrote:
> 
> 
> Hi,
> I want to join 3 tables with QueryBuildDataSource (QBDS), the
> statement is like this :
> 


> ...the goal is, I want join table InventJournalTrans to InventDim
> with key InventDimId and join table InventJournalTrans to
> InventTable with key ItemId, but.
> 

OK, you're first joining InventDim to InventJournalTrans, which is
fine...

qbds1 = qbds.addDataSource(tablenum(InventDim));

BUT then you're joining InventTable to InventDim, NOT to
InventJournalTrans

> qbds2 = qbds1.addDataSource(tablenum(InventTable));

qbds1 here is the InventDim datasource.

The order is important, even though they're inner joins.

What you can do is start by adding InventTable to the query as qbds

> qbds = q.addDataSource(tablenum(InventTable));

Then join InventJournalTrans as qbds1

> qbds1 = qbds.addDataSource(tablenum(InventJournalTrans));

(set up the links etc for the InventJournalTrans datasource here)

and finally join InventDim as qbds2 to qbds1 (InventJournalTrans)

> qbds2 = qbds1.addDataSource(tablenum(InventDim));

(set up the links etc for the InventDim ds here)

Hope that helps

Andrew Jones















Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.