Hi

arul

I am new to MSD Navision ..I created new database and new company but when i tried to restore the database it shows the
following error...

will u pls help me out....

You cannot delete or change the type of the Quality Location field (in the Location table) before the value in the field is reduced to 0 (zero) or '' (blank) in all records. This message occurred because a nonzero value was found for the record Code='DVIX-7007' in company SBM. ](*,)

mohana_cse06

Data type of field Quality Location in Location table is different in existing database and the backup you are restoring..

If you want to change it, you need to open company SBM, run table Location and remove the values in Quality Location field or copy the data to new filed..

arul

Thanks...You means the data type is modified in the form ,so u want me to remove the field in the location...
I didn't get exactly ....the problem is in my database or in the table....

mohana_cse06

I mean to remove the data in field..not the field itself..