Arsip: cannot modify read only dataset
more 15 years ago
arjuna_1982
kenapa ya kok error
"SQLQueryDetailHasil : cannot modify read only dataset" pada hal sudah diopen;
With SQLQueryDetailHasil Do
Begin
Close;
SQL.Clear;
SQL.Add('SELECT * FROM detail_hasil');
ExecSql;
End;
SQLQueryDetailHasil.open;
SQLQueryTransaksi.Open;
SQLQueryTransaksi.First;
WHILE Not SQLQueryTransaksi.Eof Do
Begin
SQLQueryDetailHasil.Insert;
SQLQueryDetailHasil.Fields[0].AsDateTime := SQLQueryTransaksi.Fields[0].AsDateTime;
SQLQueryDetailHasil.Fields[1].AsString := SQLQueryTransaksi.Fields[2].AsString ;
SQLQueryDetailHasil.Fields[2].AsString := SQLQueryTransaksi.Fields[5].AsString ;
SQLQueryDetailHasil.Fields[3].AsString := SQLQueryTransaksi.Fields[9].AsString ;
SQLQueryTransaksi.Next;
End;
apa da yang kurang ya....
more 15 years ago
cyber_hecker
pake komponen apa yach ? karena kadang ada komponen query yang memang readonly aja. contoh: ZReadOnlyQuery pada komponen ZeoS
more 15 years ago
mas_kofa
kalo masukan data nya ke SQLQueryDetailHasil pake query aja gmn?
WHILE Not SQLQueryTransaksi.Eof Do
Begin
SQLQueryDetailHasil.SQL.Text := 'insert into ................';
SQLQueryDetailHasil.Params[0].AsDateTime := SQLQueryTransaksi.Fields[0].AsDateTime;
SQLQueryDetailHasil.Params[1].AsString := SQLQueryTransaksi.Fields[2].AsString ;
SQLQueryDetailHasil.Params[2].AsString := SQLQueryTransaksi.Fields[5].AsString ;
SQLQueryDetailHasil.Params[3].AsString := SQLQueryTransaksi.Fields[9].AsString ;
SQLQueryDetailHasil.ExecSql;
SQLQueryTransaksi.Next;
End;
more 15 years ago
AndyK
@arjuna_1982: kenapa ya kok error "SQLQueryDetailHasil : cannot modify read only dataset" pada hal sudah diopen; With SQLQueryDetailHasil Do Begin Close; [/b:ca1bf7232d] //yang ini dihapus aza SQL.Clear; SQL.Add('SELECT * FROM detail_hasil'); ExecSql; // ganti sama Open; Open; End; [b:ca1bf7232d]SQLQueryDetailHasil.open; SQLQueryTransaksi.Open; // hapus aza yah :D SQLQueryTransaksi.First; WHILE Not SQLQueryTransaksi.Eof Do Begin SQLQueryDetailHasil.Insert; SQLQueryDetailHasil.Fields[0].AsDateTime := SQLQueryTransaksi.Fields[0].AsDateTime; SQLQueryDetailHasil.Fields[1].AsString := SQLQueryTransaksi.Fields[2].AsString ; SQLQueryDetailHasil.Fields[2].AsString := SQLQueryTransaksi.Fields[5].AsString ; SQLQueryDetailHasil.Fields[3].AsString := SQLQueryTransaksi.Fields[9].AsString ; SQLQueryTransaksi.Next; End; // diinputnya pake table aza om..., gmn apa da yang kurang ya....gmn bisa g? heu.." CMIIW..
more 15 years ago
AndyK
BAGEUUSS................
yang benernya dunk tampilin lagi,lumayan buat elmu,heu.."
sukses..
more 15 years ago
arjuna_1982
skrang da permaslahan lagi nih...
td khan dari tabel detail_hasil....(dah beres)
skrang dari tabel hasil.jadi tabel hasil ini hanya meyimpan record
Tanggal,jam,no_rm,kode_ruangan,id_dokter,diagnosa
------------
Hasil
------------
Tgl
jam
No_rm
Kode_ruangan
Id_Dokter
Diagnosa
--------------
--------------
Detail_hasil
----------------
Tgl
No_Rm
Kd_jns_periksa
Hasil
jadi intinya kedua tabel tersebut berasal dri satu tabel & struktur tabelx seperti ini
-------------
ambil_pemeriksaan
-------------
Tgl
jam
No_rm
Kd_ruangan
Id_Dokter
Kd_jns_periksa
Diagnosa
Hasil
trus yang jadi permasalahan..
sya mau mengambil record pada tabel ambil_pemeriksaan untuk sy kopikan ke tabel hasil.tp yang sya ambil cuma satu record saja.dan pengambilanx/copy berdasarkan 1 tanggal yang berlaku.
more ...
- Pages:
- 1
- 2
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 3 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 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 4 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
- [help] menampilkan data lookup yg dipilih dr listbox ke....
by binyo in Lain-lain more 11 years ago - SOLUSINYA DONG !
by umarbakri in Hal umum tentang Pascal Indonesia more 17 years ago - konsolidasi data
by BorlandMania in MySQL more 16 years ago - Query bertingkat dengan ADOQuery
by xmbohx in Tip n Trik Pemrograman more 17 years ago - Coding cekeremes.
by mambamaestro in Enginering more 15 years ago - Minta Dukungan teman-teman
by Brams in OOT more 16 years ago - gambar webcam lambat
by batozai in FireBird more 17 years ago - Uppercase!
by ZeAL in MySQL more 19 years ago - membuat form otoritas user
by ridi in Tutorial & Community Project more 12 years ago - procedure dan function
by willbrig in Tip n Trik Pemrograman more 16 years ago