> strSQL = " SELECT Field1, Field2, Field3, Field4 From Tabel " & _
> "WHERE (LEFT(Field2, 6) = '123456') AND
> (Joindate>='06/01/2005' and Joindate < '07/01/2005') "
>
> Set rstJoin = Nothing
> rstJoin.Open strSQL,cnnSQLServer, adOpenForwardOnly, adLockReadOnly
Kalau kaya gitu Mestinya sih gak jalan
kalau jalan, mungkin ada cript yg lupa ditulis.... :)
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| Aksan Kurdin <[EMAIL PROTECTED]>
Sent by: [email protected] 19/10/2005 11:08 AM
|
|
tapi masak bisa jalan ? bukankah rstjoin sudah bukan object recordset
lagi setelah di set nothing ?
teknik bermain recordset umumnya berpola :
'bagian deklarasi modul
dim rstjoin as adodb.recordset
'bagian on load / open form
set rstjoin = new adodb.recordset
'bagian yang membuka recordset
if rstjoin.state <> adstateclose then
rstjoin.close
endif
rstjoin.open <parameters ....?
'bagian unload form
if rstjoin.state <> adstateclose then
rstjoin.close
endif
set rstjoin = nothing
aksan kurdin
Pada tanggal 10/18/05, Agus Hanapi <[EMAIL PROTECTED]> menulis:
>
>
>
> Tolong Dunx !!!??
>
> saya punya Query untuk program saya :
>
> strSQL = " SELECT Field1, Field2, Field3, Field4 From Tabel " & _
> "WHERE (LEFT(Field2, 6) = '123456') AND
> (Joindate>='06/01/2005' and Joindate < '07/01/2005') "
>
> Set rstJoin = Nothing
> rstJoin.Open strSQL,cnnSQLServer, adOpenForwardOnly, adLockReadOnly
>
> ' Timeout Expired ' terus nih . Padahal tidak semua field saya ambil hanya
> yang diperlukan saja, ya seperti pada contoh query di atas hanya 4 field.
> Saya coba ganti operator = sama LIKE, sama aja.
>
> * Format waktu mm/dd/yyyy
> * memang data pada tabel tersebut banyak sekali and multi user.
>
> mohon di bukakan jalan menuju roma. he..he.. Tararengkyu sebelumnya.
>
>
> Regard,
> Agus
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
>
>
>
>
> 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.
>
> ________________________________
>
>
> ________________________________
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
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/
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
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.
