Arsip: RecordCount
more 17 years ago
Yudho
mass2 delphier
mau nanya nich!
Ngambil recordcount di delphi pake komponen SQLQuery dan koneknya pake SQLConnection di DBExpress koq gak bisa ya
Tiap kali ri jalankan keluar pesan
DBExpress Error:Operatin Not Supported.
Supaya bisa gimana ya?
apa aku ngeset di SQLQuery nya yang masih kurang!!
Trus seumpanya gak bisa, aku kalo mau lihat record countnya gimana ya!
Mohon pencerahanya
more 17 years ago
irosyidi
pake perintah query aja mas......
"select count(nama_field) as jumlah from tabel"
more 17 years ago
jarangkonek
[quote:9dd9985d65=""]apa aku ngeset di SQLQuery nya yang masih kurang!![/quote:9dd9985d65]
aku gak tau apa km udah peke komponen TDatasetprovider dan Tclientdataset belom untuk memudahkan ngmbil data recordcount.
setting properti :
SQLQuery1 --> SQL = Select * from nm_table
Active = True;
(jgn lupa properti SQLConnectionnya)
DataSetProvider1 --> DataSet = SQLQuery1
ClientDataSet1 --> ProviderName = DataSetProvider1
Active = True
bisa juga ditambahkan DataSource untuk memudahkan data ditampilkan ke DBGrid
nah untuk nampilin recordCount tinggal panggil aja
co :
Label1.Caption := inttostr(ClientDataSet2.RecordCount);
semoga membantu.
more 17 years ago
Akuna-Matata
DBExpress merupakan komponen yang mempunyai sifat unidirectional. kapabilitasnya bila dibandingkan dengan komponen dataset lainnya memang terbatas. Tapi ini merupakan kompromi antara speed dan kemampuan directional.
Memakai TClientDataset bisa memberikan solusi yg baik, lebih2 clientdataset bisa di-remote.
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 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
- Tertarik Programming
by danial in Lain-lain more 14 years ago - Menampilkan Hasil Perintah DOS di Memo
by myCorro in Tip n Trik Pemrograman more 17 years ago - MS SQL Server dengan ADODB (ADO connection)
by ben_gtm in Tutorial & Community Project more 14 years ago - bagaimana perintah sql untuk update 2 tabel yang berbeda
by ricky_seldjatem in Tip n Trik Pemrograman more 16 years ago - cara baca string per karakter
by yoppie in Hal umum tentang Pascal Indonesia more 16 years ago - <newbie> tanya tentang DBGrid
by n3wb1e in Tip n Trik Pemrograman more 17 years ago - photo-box
by s1n6a_ws in Multimedia & Graphic Enhancement more 16 years ago - Bikin form login...
by pikachu in Hal umum tentang Pascal Indonesia more 17 years ago - install shield gagal
by am4tiranDelphian in Paradox more 15 years ago - sub report Quick report
by keylock in Reporting more 14 years ago