急！急！！急！！！麻烦大家帮我看看为什么这个数据不能进数据库。

Question

xiaoshouADOtable.Active:=true;                        xiaoshouADOtable.Append;                
xiaoshouADOtable.FieldValues['shangpinname']:=stringgrid1.Cells[0,x];                   xiaoshouADOtable.FieldValues['danwei']:=stringgrid.cells[1,x];              xiaoshouADOtable.FieldValues['shuliang']:=stringgrid1.Cells[2,x];              xiaoshouADOtable.FieldValues['danjia']:=stringgrid1.Cells[3,x];              xiaoshouADOtable.FieldValues['zongjine']:=stringgrid1.Cells[4,x];              xiaoshouADOtable.FieldValues['haoma']:=liushuihao;              xiaoshouADOtable.fieldvalues['guige']:=edit1.text;奇怪的很，就是上面第4句，不能把值送给数据库。

Answer 1

xiaoshouADOtable.Active:=true;  
          xiaoshouADOtable.Append;   
             xiaoshouADOtable.FieldValues['shangpinname']:=stringgrid1.Cells0,x]; 
                  xiaoshouADOtable.FieldValues['danwei']:=stringgrid.cells[1,x]; 
             xiaoshouADOtable.FieldValues['shuliang']:=stringgrid1.Cells[2,x];
              xiaoshouADOtable.FieldValues['danjia']:=stringgrid1.Cells[3,x];     
         xiaoshouADOtable.FieldValues['zongjine']:=stringgrid1.Cells[4,x];   
           xiaoshouADOtable.FieldValues['haoma']:=liushuihao;    
          xiaoshouADOtable.fieldvalues['guige']:=edit1.text;
现在可能好看点，数据库里设置为文本类型的了，这里的类型应该对吧？

Answer 2

数据库里设置为文本类型的了，就算我把这句改为：
xiaoshouADOtable.FieldValues['danwei']:=‘xx’;这样都不行，提示出错是数据库这个字段设为不能为空，我觉得就是这句没能把数据送过去，为什么会这样。 

Answer 3

你最好都改为
xiaoshouADOtable.FieldByName['danwei'].AsString:=‘XX'；我不敢保证你是这句出的错，但我遇到过FieldValues副值错误的情况