一条SQL语句 怎么写都不对高手看看 可以编译就是出现missing query ,table name错误????
sqlqry1.SQL.Text:='insert into EDT ( ID,DATETIME,JINGDU,WEIDU,QIANGDU,DOUDU,WUCHA,DINGWEIFS,SHENG,SHI,XIAN ) values ('''+list2[0]+''','''+list2[2]+''','''+list2[3]+''','''+list2[4]+''','''+list2[5]+''','''+list2[6]+''','''+list2[7]+''','''+list2[8]+''','''+list2[9]+''','''+list2[10]+''','''+list2[11]+''')';
list2[i]是字符串
sqlqry1.SQL.Text:='insert into EDT ( ID,DATETIME,JINGDU,WEIDU,QIANGDU,DOUDU,WUCHA,DINGWEIFS,SHENG,SHI,XIAN ) values ('''+list2[0]+''','''+list2[2]+''','''+list2[3]+''','''+list2[4]+''','''+list2[5]+''','''+list2[6]+''','''+list2[7]+''','''+list2[8]+''','''+list2[9]+''','''+list2[10]+''','''+list2[11]+''')';
list2[i]是字符串
用showmessage(sqlqry1.SQL.Text) 看看SQL语句把
中间的空格去掉试试?