Hello...
Sy bukan senior loh... :))
Tp sy coba jawab...
Coba kalo gini :
1. Buat 1 group dengan definition :
ceiling( getrow() /10)
2. Pada dw_1.event retrieveend() ketikin syntax berikut :
long i
for i=1 to long(rowcount/10)
//syntax dibawah disambung terus kesamping jadi satu baris, bukan
kebawah...
modify('create text(band=foreground alignment="2" text="'+string(i)+'"
border="2"
color="33554432" x="'+string(i*90)+'" y="1400" height="56"
width="70"
html.valueishtml="0" name=tpage_'+string(i)+' visible="1"
font.face="Arial"
font.height="-8"
font.weight="400" font.family="2" font.pitch="2" font.charset="0"
background.mode="1"
background.color="1073741824" pointer="HyperLink!" )')
next
3. Trus pada dw_1.event clicked() ketikin syntax berikut :
if dwo.type='text' then dw_2.scrolltorow(long(dwo.text)*10)
4. dw_1.retrieve() --->> dimana aja
5. Jalankan aplikasi
6. Cobain klik 1 2 3 4 ... -nya
Kayak gitu bukan?
Mudah²an membantu.. ;)
Regards,
Not the best, only a www.h4rd3st.com one...
*yg ini gratisan loh... bukan promosi... :))
----- Original Message -----
From: "Firman Setiawan" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, April 11, 2007 1:52 PM
Subject: [indopb] ambil data sesuai limit
> Dear Senior PB,
>
>
>
> langsung saja ni, masih mengenai data. Saya lg buat program tp user meminta
> agar data yg
> ditampilkan dalam datawindow misal 10 data tp tidak diambil semua (seperti
> google ada 1,2,3,4,5,
> ...) jadi bila kita pilih angka 2 maka yg keluar adalah data 11 sampai 20.
> Nah situ yg saya
> bingung karena di sql server 2000 tidak ada limit. Bagaimana solusi yg dpt
> saya ambil. terima
> kasih atas bantuan n masukan Senior PB.
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indopb/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
