fungsi split itu u. bikin array of variant dari string input di
dijadikan parameter.
misalnya kita punya string "A;B;C;D", nah kadangkala u. mempermudah
kita ngambil nilai didalam string itu, yg masing2 nilai dipisahkan
oleh suatu string (dlm contoh ";"), kita bikin aja string itu jadi
array. jadi kl mau ngambil nilainya cukup pake indexnya aja.
oya, ingat bahwa ini array of variant, jadi var arraynya harus bertipe
variant! dan arraynya ini basisnya 0, kecuali kalo dibagian module
kita ubah pake syntax:
Option Base 1 ato 2 dll. (pokoknya array standarnya vb lah)
Sub Test()
Dim aContoh As Variant, sContoh As String
sContoh = "A;B;C;D"
aContoh = Split(sContoh, ";")
MsgBox aContoh(1)
End Sub
trus u. pertanyaan kedua, saya juga ga hapal hehehe...
tapi ada cara gampang kalo kita mau tau connection string buat connect
ke database apapun :D
# bikin aja file kosong berextensi .UDL (universal data link cmmiw)
# trus klik 2 kali file tadi, n muncul data link properties
# setting koneksi ke database servernya di situ, ikutin aja, sama
persis kalo kita pake ADODC kok. kalau perlu lakukan tes koneksi.
# save.
# buka lagi file tadi pake notepad, and voila, here it is... the
connection string we need it right there :P
best regards
[wwn]
Y! : purwedi_k
On 8/23/05, August sudana <[EMAIL PROTECTED]> wrote:
> ada yang tahu fungsi dari "split"?
> contoh penggunaan sbb: temp = Split(currLine, ",")
> apa hasil dari temp tersebut??
> kmdian, sy ingin bertnya, connection string utk connect ke SQL server spt
> apa?
> kemarin saya coba, tapi sudah lupa.krn skrg menggunakan FireBird.
> "provider=sqloledb;initial catalog=.." (lanjutannya saya lupa).
> help please...
> thanx,
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
>
>
> ________________________________
> 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.
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> ________________________________
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12h8isjtk/M=362329.6886308.7839368.1510227/D=groups/S=1705115364:TM/Y=YAHOO/EXP=1124780165/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</a>.</font>
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> 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/