FireBird数据库,一条SQL语句的异常

FireBird数据库,一条SQL语句的错误AnsiString sql_strsql_strSELECT DISTINCT ANSI_STR FROM TAG_LI

FireBird数据库,一条SQL语句的错误
AnsiString sql_str="";


sql_str="SELECT DISTINCT ANSI_STR FROM TAG_LIST_TABLE WHERE FIELD_TAG=1";
tag_list_query->SQL->Clear();
tag_list_query->SQL->Add(sql_str);
tag_list_query->ExecSQL();

tag_list_query->Active=1;
if(tag_list_query->RecordCount==0) return;
  //执行到此就报错,
  //错误信息为:[0x0005]:Operation Not Supported.

  这是什么原因?

[解决办法]
ExecSQL用于无结果集的sql语句.和firebird无关

C/C++ code
sql_str="SELECT DISTINCT ANSI_STR FROM TAG_LIST_TABLE WHERE FIELD_TAG=1";tag_list_query->Active=false;//tag_list_query->SQL->Clear();tag_list_query->SQL->Add(sql_str);//tag_list_query->ExecSQL();tag_list_query->Active=true;if(tag_list_query->RecordCount==0) return;