Re: RE : [development-axapta] Adjustment
Thanks for your mail Joannick, But I tried that sollution, it keeps telling me this: "Cannot edit a record in SqlDictionary (SqlDictionary). The record has never been selected." So I had to trace the values I got for the private vars _tableId and _fieldId, they contained the rigth value though. ...I am trying the other sollutions ;-) /bjo --- In [EMAIL PROTECTED], "Joannick Bacon" <[EMAIL PROTECTED]> wrote: I'm not sure, but there's maybe a way to do it. You could update the rightjustify field of SQLDictionary to true. tts begin; SELECT FORUPDATE SQLDictionary WHERE SQLDictionary.tableId == ?? && SQLDictionary.FieldId == ?? ; RightJustify = true; SQLDictionary.update() tts commit; Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com -Message d'origine- De : byteway_so [mailto:[EMAIL PROTECTED] Envoyé : 28 octobre, 2003 10:08 À : [EMAIL PROTECTED] Objet : [development-axapta] Adjustment Yahoo! Groups Sponsor ADVERTISEMENT Click to learn more... Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : [development-axapta] Adjustment
I'm not sure, but there's maybe a way to do it. You could update the rightjustify field of SQLDictionary to true. tts begin; SELECT FORUPDATE SQLDictionary WHERE SQLDictionary.tableId == ?? && SQLDictionary.FieldId == ?? ; RightJustify = true; SQLDictionary.update() tts commit; Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com -Message d'origine- De : byteway_so [mailto:[EMAIL PROTECTED] Envoyé : 28 octobre, 2003 10:08 À : [EMAIL PROTECTED] Objet : [development-axapta] Adjustment Hi all, I wonder if it is possible to adjust a field of a table programmatically. I know how to get to the SQLDictionary record for the specifick field. It goes something like: MyTable _table; int _tableId; int _fieldId; ; _tableid = _table.TableId; _fieldId = fieldName2Id(_tableid,"MYCOLUMNNAME"); But after I have that record, what do I need to do to get the Adjustment of the field for example to "right"? Any help would be appreciated. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: RE : [development-axapta] Adjustment
Changing the records in the table SQLDictionary NOT a good plan. You might loose date at the next synchronize from Axapta converts the field back the properties as set up in the Axapta AOT. You need to change the EDT in Axapta then synchronize the tables, this will update the SQLDictionary. The SQLDictionary is used by Axapta to support asynchronously update of the Data Dict in Axapta and the SQL Database. /Jesper Original Message processed by Tobit InfoCenter Subject: RE : [development-axapta] Adjustment (28-Okt-2003 16:30) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] I'm not sure, but there's maybe a way to do it. You could update the rightjustify field of SQLDictionary to true. tts begin; SELECT FORUPDATE SQLDictionary WHERE SQLDictionary.tableId == ?? && SQLDictionary.FieldId == ?? ; RightJustify = true; SQLDictionary.update() tts commit; Bacon Joannick Stagiaire Informatique / IT trainee B O A - F R A N C | M I R A G E T 418.227.1181 #2313 F 418.227.1188 www.boa-franc.com -Message d'origine- De : byteway_so [mailto:[EMAIL PROTECTED] Envoyé : 28 octobre, 2003 10:08 à : [EMAIL PROTECTED] Objet : [development-axapta] Adjustment Hi all, I wonder if it is possible to adjust a field of a table programmatically. I know how to get to the SQLDictionary record for the specifick field. It goes something like: MyTable _table; int _tableId; int _fieldId; ; _tableid = _table.TableId; _fieldId = fieldName2Id(_tableid,"MYCOLUMNNAME"); But after I have that record, what do I need to do to get the Adjustment of the field for example to "right"? Any help would be appreciated. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Adjustment
Hi, You normaly needs to change the EDT to change the field properties. Try having a look at the sysDict* classes and the systemclasses dict*. You might find a usefull hint in the forms for setting up global types. /Jesper Original Message processed by Tobit InfoCenter Subject: [development-axapta] Adjustment (28-Okt-2003 16:12) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Hi all, I wonder if it is possible to adjust a field of a table programmatically. I know how to get to the SQLDictionary record for the specifick field. It goes something like: MyTable _table; int _tableId; int _fieldId; ; _tableid = _table.TableId; _fieldId = fieldName2Id(_tableid,"MYCOLUMNNAME"); But after I have that record, what do I need to do to get the Adjustment of the field for example to "right"? Any help would be appreciated. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [development-axapta] Adjustment
Assuming the table field is defined using an extended datatype, you will have to change the EDT rather than the field itself. However, beware that this means that any other tables using this edt, and in fact any other place in the application using that edt will obviously be affected too. The way you do it is using infolog methods to directly access the AOT, getting references to the individual nodes and then changing properties using the global method setProperty(). See the following for ideas: TreeNode Infolog.findNode(str _path) returns a treenode with reference to the AOT node specified by path (ie. \\Data Dictionary\Extended datatypes\MyType) str TreeNode.AOTgetProperties() returns the properties of a specific node. str Global::findProperty(str _properties, str _property) converts a propertysheet (as given by AOTGetProperties) to a specific propertyvalue (ie. alignment = findProperty(node.AOTgetProperties(), 'Alignment')) str Global::setProperty(str properties, str propertyname, str value) set-equivalent of findProperty. Check the online help for the classes and methods mentioned above to find other interesting methods, like AOTFindChild. Best regards Thomas Turn Jensen - Original Message - From: "byteway_so" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 4:07 PM Subject: [development-axapta] Adjustment Hi all, I wonder if it is possible to adjust a field of a table programmatically. I know how to get to the SQLDictionary record for the specifick field. It goes something like: MyTable _table; int _tableId; int _fieldId; ; _tableid = _table.TableId; _fieldId = fieldName2Id(_tableid,"MYCOLUMNNAME"); But after I have that record, what do I need to do to get the Adjustment of the field for example to "right"? Any help would be appreciated. Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
