ini dia coba ...= IIF(IsNull(rs(1)),"",rs(1)) ...= IIF(IsNull(rs(2)),"",rs(2))
semoga membantu --- On Fri, 10/17/08, Gege Nugroho <[EMAIL PROTECTED]> wrote: From: Gege Nugroho <[EMAIL PROTECTED]> Subject: [Programmer-VB] Jawabin : listview error "invalid use of null" To: [email protected] Date: Friday, October 17, 2008, 10:01 AM Pake IIF... Lengkapnya? Googling dwongs.... Happy hunting Regards Gege Nugroho --- On Fri, 10/17/08, Agus Sudana <[EMAIL PROTECTED]> wrote: From: Agus Sudana <[EMAIL PROTECTED]> Subject: [Programmer-VB] listview error "invalid use of null" To: "milis programmer" <[email protected]> Date: Friday, October 17, 2008, 3:50 PM dear kakak2 VB'ers, agar listview juga menampilkan record yg null dari database, bagaimana ya..? berikut potongan script'nya, errornya selalu mengarah ke subitem(2). setelah di tracking, record field 2 di database ada yg null If rs.RecordCount > 0 Then rs.MoveFirst Do While Not rs.EOF Set xListItem = lvDataAbsent. ListItems. Add(, , rs(0)) xListItem.SubItems( 1) = rs(1) xListItem.SubItems( 2) = rs(2) rs.MoveNext Loop end if need advice, salam, Agus Sudana __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
