提示SQL语法异常

提示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";