Re: RE : [development-axapta] Adjustment

[jesper . joergensen]

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.