di loop saja
tgl_awal=now() 'misal
for i=1 to 3
sInsert="insert into tablenya values('DC','" & format(tgl_awal+i,"yyyy-mm-dd") & "'1001',2)
next
kalau tgl awal gak bisa di + , pake perintah dateadd
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| "Didi Cendana"
<[EMAIL PROTECTED]>
Sent by: [email protected] 03/02/2006 01:54 PM
|
|
D/h.
Bagaimana command untuk entry data secara periode?
Contoh:
USER TGL CODE JAM
DC 02/02/2005 10001 2
DC 03/02/2005 10001 2
DC 04/02/2005 10001 2
Jadi data diatas hanya di entry 1 kali saja dan berdasarkan tanggal kegiatan ... s/d...
Mohon bantuannya dari rekan-rekan sekalian.
Terima kasih.
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB"
on the web.
- To unsubscribe from this group, send an email
to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
