with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from MST_USER where USERID = ''11'' '); Open;
if ADOQuery1.RecordCount = 0 then
begin
MessageDlg('無データ !',mtError,[mbOK],0);
close;
end
else
begin
Close;
SQL.Clear;
SQL.Add(' update MST_USER set PASSWORD = ''crazyliyang''');
SQL.Add(' where USERID = ''11'' ');
ExecSQL;
MessageDlg('Successful !',mtError,[mbOK],0);
Close;
SQL.Clear;
SQL.Add('insert into MST_USER values(''liyang'',''liyang'') ');
ExecSQL;
MessageDlg(' Successful1 !',mtError,[mbOK],0);
end;
end;
begin
Close;
SQL.Clear;
SQL.Add('select * from MST_USER where USERID = ''11'' '); Open;
if ADOQuery1.RecordCount = 0 then
begin
MessageDlg('無データ !',mtError,[mbOK],0);
close;
end
else
begin
Close;
SQL.Clear;
SQL.Add(' update MST_USER set PASSWORD = ''crazyliyang''');
SQL.Add(' where USERID = ''11'' ');
ExecSQL;
MessageDlg('Successful !',mtError,[mbOK],0);
Close;
SQL.Clear;
SQL.Add('insert into MST_USER values(''liyang'',''liyang'') ');
ExecSQL;
MessageDlg(' Successful1 !',mtError,[mbOK],0);
end;
end;
我从07版本升级成2010版本,需不需要把所有的类型的都做以转换,还是只是注意一些特殊的类型,或者方法,
大家多多指点!