| Author |
Message |
lela |
| Location: |
|
Post subject: nampilin per 5 pada dbGrid
 Posted: 08/Feb/2006 09:38
|
|
onSkilled
Joined: 03-Jun-2005
Posts: 109
Status: Offline
|
|
lela mo nampilin sebuah isi tabel dari mysql ke DBGrid pada delphi, tapi disini saya pengen nampilinya per 5, maksudnya buat ngeliat isi ke 6 sampai ke 10 (ke 5 yang berikutnya) musti di next dulu, disini saya menggunakan DBExpress, dengan ClientDataset,datasource.
tolong ya caranya gimana, aku bingung nih... nuhun ya... |
|
|
| |
|
|
|
 |
|
LuriDarmawan |
| Location: here |
|
|
Post subject:
Posted: 08/Feb/2006 09:51
|
|
onApaAdanya
Joined: 15-Mar-2005
Posts: 1617
Location: here
|
|
|
|
|
|
|
|
|
Post subject:
Posted: 08/Feb/2006 13:27
|
|
onMage
Joined: 06-Feb-2006
Posts: 2401
|
|
Hmm, hal ini bisa diatasi menggunakan statemen LIMIT pada MySQL.
Follow this flow:
- Deklarasikan variable global (Publik) untuk menyimpan current record start.
- Anda harus memodifikasi SQL query dengan menambahkan statemen LIMIT di akhir query
Misal: SELECT * FROM CUSTOMER LIMIT n, 5
Jika navigator Anda di Next / goto page, tinggal manipulasi variable n - nya doank.
Note: statement LIMIT di MySQL kalo nggak salah ingat gitu  silahkan cek referensinya
Ok, hope usefull
Best Regards - DelphiExpert |
_________________
Dude, if you don't understand the basics and just want to get someone else write the code for you, it means you really shouldn't study computer science. Find a different field.
 http://delphiexpert.wordpress.com
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: 08/Feb/2006 13:28
|
|
onMage
Joined: 06-Feb-2006
Posts: 2401
|
|
Hehe keduluan mas Luri. Ini aku dah nulis reply dari tadi. Ada tamu lupa belum di-post  |
_________________
Dude, if you don't understand the basics and just want to get someone else write the code for you, it means you really shouldn't study computer science. Find a different field.
http://delphiexpert.wordpress.com
|
| |
|
|
|
|
|
LuriDarmawan |
| Location: here |
|
|
Post subject:
Posted: 08/Feb/2006 15:17
|
|
onApaAdanya
Joined: 15-Mar-2005
Posts: 1617
Location: here
|
|
|
|
|
|
|
kaka-delphi |
| Location: Taziex |
|
|
Post subject:
Posted: 08/Feb/2006 15:23
|
|
onElite
Joined: 12-Oct-2005
Posts: 1050
Location: Taziex
|
|
Saya juga mo post tapi udah keduluan mas ulil, yach terpaksa dech beli coklat sendiri
wakakakakakakakakakakakkkkakkk ...........  |
|
|
| |
|
|
|
|
|
spyoff |
| Location: |
|
|
Post subject:
Posted: 09/Feb/2006 00:01
|
|
onBeginner
Joined: 06-Feb-2006
Posts: 4
Status: Offline
|
|
kalo mau cara yang sulit, hasil query dimasukin ke dataset baru, sebanyak row yang diinginkan, tapi malah jadi susah nanti, hehehe, tapi klo databasenya g support limit mungkin bisa dicoba
code : pascal function CreateTableInMemory(const AFieldDefs:TFieldDefs): TDataSet; var TempTable:TClientDataSet; begin TempTable:=nil; Result:=nil; if AFieldDefs<>nil then begin try TempTable:=TClientDataSet.Create(Application); TempTable.FieldDefs.Assign(AFieldDefs); TempTable.CreateDataSet; Result:=(TempTable as TDataSet); Except if TempTable<>nil then TempTable.Free; Result:=nil; raise; end end end;
|
|
|
| |
|
|
|
|
|
mas_kofa |
| Location: New York Arto |
|
|
Post subject:
Posted: 24/Nov/2006 14:51
|
|
onElite
Joined: 18-Mar-2006
Posts: 1753
Location: New York Arto
|
|
aku juga punya kasus mungkin agak mirip dengan lala...
ceritanya seperti ini.....
aku punya tabel mahasiswa (dgn mysql) ... tabel tidak urut berdasarkan nomor mahasiswa (tp urut berdasarkan nomor entry).......
yang saya inginkan, saya mo nampilin semua record dan urut berdasarkan nomor mahasiswa......
tapi saya harus dapat membawa record pointer ke record dengan nomor mahasiswa yang diinginkan.....misal record harus berada di record yang nomormahasiswa nya 06.23.345 .....
gmn ya caranya...????
sebelumnya makasih atas masukannya |
|
|
| |
|
|
|
|
|
|
|
Post subject:
Posted: 24/Nov/2006 15:20
|
|
onElite
Joined: 09-Oct-2005
Posts: 1313
Location: BeDeGe
|
|
|
|
|
|
|
|
