各位大哥看看,怎么不能修改呢
with Q_HouseTiao do
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE="1" ');
SQL.Add('WHERE ID=''(SELECT HOUSE_ID FROM USER_HOUSE WHERE USER_ID)='+''''+DBEdit15.TEXT+'''');
ExecSQL;
end;
谢谢
with Q_HouseTiao do
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE="1" ');
SQL.Add('WHERE ID=''(SELECT HOUSE_ID FROM USER_HOUSE WHERE USER_ID)='+''''+DBEdit15.TEXT+'''');
ExecSQL;
end;
谢谢
with Q_HouseTiao do
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE=''1'' ');
SQL.Add('WHERE ID=(SELECT HOUSE_ID FROM USER_HOUSE WHERE USER_ID='+''''+DBEdit15.TEXT+''')');
ExecSQL;
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE='+quotedstr(1));
SQL.Add('WHERE ID=(SELECT HOUSE_ID FROM USER_HOUSE WHERE USER_ID='''+quotedstr(DBEdit15.TEXT)+')');
ExecSQL;
应该是这样!
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE='+quotedstr(1));
SQL.Add('WHERE ID=(SELECT HOUSE_ID FROM USER_HOUSE WHERE USER_ID='+quotedstr(DBEdit15.TEXT)+')');
ExecSQL;前面错了,这次没问题了!
procedure TF_main.Button5Click(Sender: TObject);
begin
with Q_HouseTiao do
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE='+chr(1));
SQL.Add('WHERE ID=(SELECT HOUSE_ID FROM USER_HOUSE WHERE USER_ID='+quotedstr(DBEdit15.TEXT)+')');
ExecSQL;
end;
end;
end.
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE='+quotedstr(1));
SQL.Add('WHERE ID=(SELECT HOUSE_ID FROM USER_HOUSE WHERE USER_ID='+quotedstr(DBEdit15.TEXT)+')');
ExecSQL;
end;
我的这些东西的类型都是文本
各位大哥看看,怎么不能修改呢
with Q_HouseTiao do
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE="1" ');
SQL.Add('WHERE ID IN ''(SELECT HOUSE_ID FROM USER_HOUSE WHERE USER_ID)
~~~~~~~~~~
='+''''+DBEdit15.TEXT+'''');
ExecSQL;
end;
谢谢
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE=''1'' ');
with Q_HouseTiao do
begin
CLOSE;
SQL.Clear;
SQL.Add('UPDATE HOUSE_INFO SET STATE="1" ');
SQL.Add('WHERE ID IN (SELECT HOUSE_ID FROM USER_HOUSE WHERE USER_ID
~~~~~~~~~~
='''+trim(DBEdit15.TEXT)+''' ');
ExecSQL;
end;