salam007
سه شنبه 16 اسفند 1390, 22:54 عصر
سلام دوستان به نظر شما کدام نوع کد بهتره برای ارسال و آپدیت جداول
کد INSERT
SQL.Add('Insert into DB (field1) values(''var'')');
ADOTable1.append; *** ADOTable1field1.AsInteger:=var *** ADOTable1.post; ;
FieldByName('field1').AsString:=var
کد Update
SQL.Add('Update DB set field1=''var'' where field1=''var''');
ADOTable1field1.AsInteger:=var *** ADOTable1.post;
کد Delete
SQL.Add('Delete from DB where field1=''var''');
ADOTable1.Delete;
کد INSERT
SQL.Add('Insert into DB (field1) values(''var'')');
ADOTable1.append; *** ADOTable1field1.AsInteger:=var *** ADOTable1.post; ;
FieldByName('field1').AsString:=var
کد Update
SQL.Add('Update DB set field1=''var'' where field1=''var''');
ADOTable1field1.AsInteger:=var *** ADOTable1.post;
کد Delete
SQL.Add('Delete from DB where field1=''var''');
ADOTable1.Delete;