Thanks so much for all your efforts, but I worked out that I was missing (') in front of my string and that was the reason it was not importing into the data base!
Have a great week end - Sorry for any inconvienence I may have caused you.
Thanks so much for all your help ! Much appreciated, I hope I am not being too much of a pain... but... I was unable to detect the name of the optional field I had origionally created. I followed your clear instructions by locating the sub folder "TYPE" for CSOPTFH, CSOPTFD, ICOFD,tables but...
Thanks so much for the data base tables that need editing - although when I tried to run a "Microsoft Query Wizard" from Excel 2007, I did manage to find the tables but when I reached the last step of the wizard i received the following error "Incorrect syntax near the keyword 'VALUES'...
Error after trying to delete from IC
Description: Incorrect procedure. You cannot delete optional field ITEMUNITQTY because it is in use in Inventory Control.
Source: 13:02:02
I tried to delete in Inventory Control after the message appeared when i tried to delete in common services..Both do no work for me... the error message is : same as before :Cannot delete as it is being used by inventory control"
I am unable to edit the type of string my optional field has been originally set up as. Eg changing from a text field to a number field.
How is this done?
Thanks so much for any help!
BTW i am the end user...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.