Use below sample queries to update SQLDICTIONARY table to resolve field id conflict in AX 2012.
select * from SQLDICTIONARY where TABLEID = 0
select * from SQLDICTIONARY where TABLEID = 0 and NAME = 'XYZ'
select * from SQLDICTIONARY where TABLEID = 0 and FIELDID = 0
update SQLDICTIONARY
set FIELDID = 0
where TABLEID = 0 and NAME = 'XYZ'
select * from SQLDICTIONARY where TABLEID = 0
select * from SQLDICTIONARY where TABLEID = 0 and NAME = 'XYZ'
select * from SQLDICTIONARY where TABLEID = 0 and FIELDID = 0
update SQLDICTIONARY
set FIELDID = 0
where TABLEID = 0 and NAME = 'XYZ'
No comments:
Post a Comment