Arsip: import record dari foxpro

more 8 years ago
idhiel
para master delphi ....
kenapa yah aq import record dari tabel foxpro ke database yang juga dari foxpro sangat lambat....malah boleh aq katakan komputer aq langsung hank..? apa ada yang salah dengan kode programnya..
nih kode programnya..
dm.Dbf2.TableName := sedit1.Text ;
dm.Dbf2.FilePathFull := sedit2.Text ;
dm.Dbf2.Active := true;
while NOT dm.Dbf2.Eof do
begin
dm.Table1.Open ;
dm.Table1.Append ;
dm.Table1['noref'] := dm.Dbf2['Wbno'];
dm.Table1['cycle'] := dm.Dbf2['cycle'];
dm.Table1['nama'] := dm.Dbf2['nama'];
dm.Table1['addrs'] := dm.Dbf2['addr'];
dm.Table1['kodepos'] := dm.Dbf2['kodepos'];
dm.Table1['upload'] := dm.Dbf2['Pudt'];
dm.Table1['bank'] := sedit3.Text ;
dm.Table1.Post ;
dm.Table1.Close ;
dm.Table1.Open ;
end;
tolong bantuannya para master...
more 8 years ago
theodorusap
Kalo copy/import seluruh isi tabel dengan catatan jumlah, jenis dan ukuran field pada kedua tabel sama, (tabel identik) bisa pake source ini :
Function CopyDataset(Src,Dst:TDataset):Integer;
var
I:Integer;
Err:Boolean;
begin
result:=0;
Err:=false;
src.first;
while (not src.Eof) and (not Err) do begin
dst.Append;
try
for i:=0 to dst.FieldCount-1 do
dst.Fields.Fields[i].Value:=src.Fields.Fields[i].Value;
dst.Post;
inc(result);
except
on E:Exception do begin
dst.Cancel;
err:=true;
end;
end;
src.Next;
end;
end;
Terus buat manggilnya :
CopyDataset(dm.Dbf2,dm.Table1);
more 8 years ago
theodorusap
Bener tuh denmasdanang...
code itu sama aja artinya looping sampai hang... :lol:

more 8 years ago
idhiel
aq coba dulu yah master solusinya...
but sebelumnya aku maksih atas solusinya....
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
- Lazarus Release 2.0.12
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 6 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 6 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 7 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 7 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 7 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 7 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- struktur forum
by simba in Kritik & Saran more 15 years ago - Select LIMIT PLEASE HELP URGENT........
by Tyu_alone in MySQL more 9 years ago - tentang printer
by Arjomb in Tip n Trik Pemrograman more 13 years ago - Solusi Dong !
by umarbakri in Hal umum tentang Pascal Indonesia more 13 years ago - mo nanya lagi
by alfian in MsSQL more 15 years ago - Cara Penulisan SELECT FORMAT(Uang,2) FROM tablebank ,Sukses
by faridx in MsSQL more 13 years ago - Creating a good form....
by RoenZ in Multimedia & Graphic Enhancement more 13 years ago - Manggil perintah dalam DLL yang di buat C++
by aandrie77 in Enginering more 10 years ago - logika pengisian pulsa, gmn ya....?
by coacoac in Tip n Trik Pemrograman more 13 years ago - Mengkonfersi hasil scan barcode ke aplikasi..
by mully in MySQL more 14 years ago