hi all once again…
hmmm my company is using microsoft navision for the ERP process
on form ‘Sales Order’ and "Purchase Order’ usually we didn’t input data (it means we just empty the field)
now, we have more than thousands record from it…
and we want to change all those empty record with word = ‘GENERAL’
if I inject it through sql query analyzer like this (on table Sales header) :
Update [My Company$Sales Header]
set [Shortcut Dimension 2 Code]=‘GENERAL’
WHERE [Shortcut Dimension 2 Code]=’’
is it connected to another table??
if i want to change field shortcut dimension 2 code at table Sales Header, which table i must change with my sql statement?