...

Arsip: Meng-Copy Isi Tabel Ke Tabel Lainnya

 
user image
more 17 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 17 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 17 years ago

yayaretina

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

_aa_

pake batchmove/clone
user image
more 17 years ago

dels

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

AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now: https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD

Last Articles

Last Topic

Random Topic

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