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
- Buat Installer Program
by RoenZ in Enginering more 15 years ago - Pakai Inno Setup
by Yudho in Hal umum tentang Pascal Indonesia more 17 years ago - Menampilkan stok barang berdasarkan tanggal
by deded in Hal umum tentang Pascal Indonesia more 12 years ago - menampilkan semua isi suatu field pada combobox
by mas_kofa in Hal umum tentang Pascal Indonesia more 17 years ago - pps,swf plugin
by brodien in Multimedia & Graphic Enhancement more 18 years ago - Open Source Entry Level Akunting
by muammar in Tutorial & Community Project more 17 years ago - Pascal Data Objects (PDO)
by Kecret in OpenSource dan Gratis more 17 years ago - Gimana bukin colom lewat aplikasi?
by anaconda in MySQL more 16 years ago - Generate even
by delphicode in Tutorial & Community Project more 14 years ago - Gimana cara tampilkan button on custom preview fastreport3?
by yoebhe in Tip n Trik Pemrograman more 17 years ago