hmm itu sedikit salah code

harusnya

=====
s= "select stok from obat where kodeobat like = '"& txt1.text&"'"
rs.open s, conn
if rs.eof = false then
   label1.caption = iif( isnull(rs!stok)=false,"", trim(rs!stok) )
endif
rs.close
=====

rs itu adalah record set
conn itu adalah connection dengan database

semoga berhasil

--- In [email protected], tepupunk <[EMAIL PROTECTED]> wrote:
>
> all mo  tanya dong..gmn caranya biar label bisa di
> pakein script....
> 
> exp...
> 
> gw mo pake script gini...
> 
> s= "select stok form obat where kodeobat like = '"&
> txt1.text&"'"
> 
> nah si S itu pengen gw masukin di label...
> 
> apakah jadi nya gini ?
> label1.caption=S >>>> gw coba klo gtu yg kluar script
> nya bkn hasil SQL nya...please ya guys...help me
> 
> 
>      
____________________________________________________________________________________
> Be a better friend, newshound, and 
> know-it-all with Yahoo! Mobile.  Try it now. 
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>


Kirim email ke