Arsip: Zeos Table "is busy"?

more 16 years ago
ekosch
script looping ;
1 repeat
2 zcust.Edit;
3 zcustcust_kode.Value:= generatekey(now);
4 zcust.Post;
5 zcust.Next;
6 application.ProcessMessages;
7 progresbar.position:=zcust.recno;
8 until zcust.Eof;
proses looping diatas saya gunakan untuk mengisi kode customer secara masal
masalahnya adalah saat progresbar sudah 100%(sudah eof) kenapa proses update ke database masih berjalan/belum selesai ya?
dengan kata lain proses next(langkah 5) tidak mau menunggu proses pos (langkah 4) selesai dulu.
pertanyannya gimana caranya agar langkah ke 5 dijalankan setelah terdeteksi
proses update ke database selesai?
tambahan;
saya menggunakan zeos connection, zeos table, mysql 41 dengan delphi 6#2
akhirnya : adakah yang bisa ngebantu nih??? :idea:

more 16 years ago
julius
Coba Pakai While do :
ZCust.First;
While Not zcust.eof Do Begin
zcust.Edit;
zcustcust_kode.Value:= generatekey(now);
zcust.Post;
progresbar.position:=zcust.recno;
zcust.Next;
End;

more 16 years ago
yayaretina
sebelum repeat tambahkan..
progresbar.max:=zcust.recordcount;
soalnya max pada progressbar tidak diatur. dan defaultnya adalah 100.
boleh juga tambahin zcust.first..

more 16 years ago
ekosch
Thanks bantuannya... ternyata kesalahanku terletak di default sortingnya ..lupa matiin
jadi dengan metode looping/sequensial menjadikan kacau prosesnya karena scara otomatis
akan di sort stelah posting dan indexnya jadi amburadul...
sekali lagi thanks ya ...sudah lancar sekarang :oops:
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 3 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 3 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 11 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 11 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 11 years ago
Random Topic
- ngeprint stringgrid di fast report
by radhutz in Bedah Kasus more 13 years ago - Open ShortCut Folder
by juki in Hal umum tentang Pascal Indonesia more 15 years ago - Tanya:bgmn cara komunikasi antar form ?
by stoopid in Network, Files, I/O & System more 16 years ago - Koneksi delphi - MySQL yang paling bagus
by em052007 in Tip n Trik Pemrograman more 15 years ago - Fast Report dalam EXE ?
by himen81 in Hal umum tentang Pascal Indonesia more 16 years ago - menjumlahkan suatu field
by goodday in Enginering more 17 years ago - Convert Database Format *.PAM
by clark in OOT more 17 years ago - OOP dan Database ? //Need Help
by ruben in Tip n Trik Pemrograman more 14 years ago - tanya inno setup mentog
by jowo in Enginering more 11 years ago - [HELP] masalah cannot focus form (satu project banyak form)
by binyo in Lain-lain more 11 years ago