Hi there
I have solved it a bit different, but you would be able to construct your
scenario based on my code.
I got a XML document with the table name or an alias for the table as XML
element, as child elements I got the fields and needs to create a record in
Axapta based on this.
void A()
{
FileName fileName = 'File Name goes hier';
XMLDocument importData;
XMLNode xmlNode;
XMLNode node;
XMLNodeListIterator XMLNodeListIterator;
Counter XMLNodeCounter;
SysDictTable dictTable;
Common record;
boolean valueFound;
fieldId field;
;
// Open XML Document
importData = new XMLDocument();
importData.Async(true);
importData.load(filename);
if (importData.readyState() == 4)
{
// get first Node
xmlNode = importData.documentElement();
XMLNodeListIterator = new XMLNodeListIterator(xmlNode.childNodes());
ttsbegin;
// get child Nodes
while (XMLNodeListIterator.moreValues())
{
node = XMLNodeListIterator.value();
if (TableName2Id(Node.attributes().nextNode().text()) > 0)
{
// First Element holds the table
dictTable = new
SysDictTable(tableName2Id(Node.attributes().nextNode().text()));
valueFound = false;
record = dictTable.makeRecord();
// child elements holds the fields with values
for (XMLNodeCounter = 0; XMLNodeCounter <
node.childNodes().length(); XMLNodeCounter++)
{
// Node name = FIeld Name
field =
dictTable.fieldName2Id(node.childNodes().item(XMLNodeCounter).attributes().nextNode().text());
if (field
&& !isSysID(field))
{
// get the node value
record.(field) =
node.childNodes().item(XMLNodeCounter).getNodeValue();
valueFound = true;
}
}
if (valueFound)
{
record.insert();
}
}
XMLNodeListIterator.nextValue();
}
ttscommit;
}
}
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Entwicklung Axapta
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
[EMAIL PROTECTED] <blocked::mailto:[EMAIL PROTECTED]>
http://www.as-T.biz
Phone: +49 5242 / 40 80 54
Fax: +49 5242 / 40 80 40
Mobile: +49 172 / 571 03 34
________________________________
"Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und
ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie
sicher, dass die Information in dieser Nachricht ausschließlich an die
adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie
gesendet worden sein, dann informieren Sie bitte umgehend den Absender und
löschen Sie die Nachricht. Vielen Dank."
"The information in this e-mail and any attachments is confidential. The
information must only be held in areas that have controlled and limited access
to the addressed persons. If this e-mail has been sent to you in error, please
immediately notify the sender and delete the e-mail. Thanks."
________________________________
________________________________
Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag
von surfing2alien
Gesendet: Mittwoch, 3. Januar 2007 23:53
An: development-axapta@yahoogroups.com
Betreff: [development-axapta] Update field with switch-case
I'm looking for an example where I can find the way to achieve the
following.
Can somebody tell me , or point to an example in Axapta 3.0, what to
fill in
in the dots in method B , and how method A should look like:
I receive a fieldid from a message in method A.
This fieldid is validated by another method B, and there is a switch-case
which tells what the fieldtype is.
Depending on the type of field in method B, 1 of the fields in my
Table in
method A has to be updated.
method A()
XMLmessage XMLmessage;
Table Table;
;
receives a XMLmessage.
In this XML message the fieldtype is extracted
call method B
method B()
switch fieldtype
{
case MName : return..... ; break;
case MAge : return..... ; break;
case MAdress : return..... ; break;
case MCity : return..... ; break;
.
.
.
default : return.......; break;
}
(back in method A)
depending on the fieldtype, one of the fields in the Table has to be
inserted with the value
which is extracted after the fieldtype in the message.
Thanks
/B
[Non-text portions of this message have been removed]
