提示SQL语法错误
//---------------------------------------

#include <vcl.h>
#pragma hdrstop

#include "Unit3.h"
#include "Unit1.h"

//---------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"

TForm3 *Form3;
//---------------------------------------
__fastcall TForm3::TForm3(TComponent* Owner)
: TForm(Owner)
{
}
//---------------------------------------


void __fastcall TForm3::Button2Click(TObject *Sender)
{
Form3->Close();
}
//---------------------------------------


void __fastcall TForm3::Button1Click(TObject *Sender)
{
try{

DataModule1->ADODataSet1->Connection = DataModule1->ADOConnection1;
DataModule1->ADODataSet1->CommandType = cmdText;
DataModule1->ADODataSet1->CommandText = "qy";
DataModule1->ADODataSet1->Open();
AnsiString sql;
DataModule1->ADOQuery1->Close();
DataModule1->ADOQuery1->SQL->Clear();
sql = "UPDATE qy SET yujing=20,baojing=90 WHERE id=1";
DataModule1->ADOQuery1->SQL->Text = sql;
// DataModule1->ADOQuery1->SQL->Add(sql);
DataModule1->ADOQuery1->ExecSQL();

}
catch(...)
{
ShowMessage("Cann't connect db");
}

}
//---------------------------------------
执行到 AnsiString sql; 时就提示错误 ，那句SQL 语句在ACCESS数据库中执行后可以正确插入数据，什么原因呢？

[解决办法]
那个也是个sql语句，看你要干什么了，看你的代码这里似乎不需要ADODataSet1他，如果你是想让他读取qy表的话这样写

C/C++ code

DataModule1->ADODataSet1->CommandText = "select * from qy";