Arsip: Meng-Copy Isi Tabel Ke Tabel Lainnya

 
user image
more 12 years ago

doodle_doo

Salam Delphi Holic semua..... Deadline nih......... Aq mau tanya Gimana caranya mengCopy isi suatu tabe ke tabel lainnya. Tabel1 dan Tabel2 sama,tapi salah satu cuma temporary, nanti dihapus lagi kok. data utama akan dikumpulin di Tabel2 Aq ud coba looping pake timer....tapi kurang efetive coding yang aq buat adodataset1.fieldvalue['nama']:=adodataset2.fieldvalue['nama'] ... ... ... ... ....dan seterusnya Aq baru 4 hari belajar MySql.....jadi ma'af ya.......malu2in...... " onerror="this.style.display='none'"/>[/code]
user image
more 12 years ago

mas_kofa


while not table1.eof do
begin
   table2.Append;
   for i := 0 to tabl1.Fields.Count - 1 do
   table2.fields[i] := table1.fields[i];
   tbale1.Next;
   table2.Post;
end;
user image
more 12 years ago

yayaretina

[sql] INSERT INTO tabel2 SELECT * FROM tabel1; COMMIT; TRUNCATE tabel1; [/sql]
user image
more 12 years ago

_aa_

pake batchmove/clone
user image
more 12 years ago

dels

klo semisal pake ADO
SELECT * INTO table_tujuan FROM table_asal 
more ...
  • Pages:
  • 1
Share to

Random Topic

Local Business Directory, Search Engine Submission & SEO Tools FreeWebSubmission.com SonicRun.com