FireBird数据库,一条SQL语句的异常
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无关
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;