coba query seperti ini: select (select count(*) from INVBarang b where b.kodebarang <= a.kodebarang) as Nomor, a.kodebarang, a.iduraianbarang from INVBarang a
hasil query ini akan spt ini 1 AB-AF00001 Acyclovir cream 2 AB-AF00002 Acyclovir tab 200mg 3 AB-AF00003 Acyclovir tab 400mg 4 AB-AF00004 Amcillin inj 1gr 5 AB-AF00005 Amobiotic syr 6 AB-AF00006 Amoxicillin cap 250mg 7 AB-AF00007 Amoxicillin cap 500mg 8 AB-AF00008 Amoxicillin syr 9 AB-AF00009 Amoxsan cap 500mg 10 AB-AF00010 Amoxsan F syr --- In [email protected], nur Firman <[EMAIL PROTECTED]> wrote: > > kalo pake crystal report memang bisa > tapi ... kalo pake CR saya nggak punya softwarenya n harus beli licence > sedangkan di kantor nggak boleh pake bajakan (kecuali pake VB5) > > jadi memanfaaatkan data reportnya dari vbnya. > > pasti ada cara ....... tul nggak... ? > > muhammad Taufiq wrote: > > bukannya di cristal report uda ada seperti di spesial field or buat > > aja running total field > > > > ----- Original Message ---- > > From: nur Firman <[EMAIL PROTECTED]> > > To: [email protected] > > Sent: Monday, October 2, 2006 12:26:38 AM > > Subject: Re: [Programmer-VB] buat no urut di SQL Syntaks > > __________________________________________________ > Apakah Anda Yahoo!? > Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam > http://id.mail.yahoo.com > 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/Programmer-VB/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/
