On Tuesday, December 6, 2005, 4:20:27 AM, Darsana wrote:

> Bisa saja anda gunakan LIKE , dengan query (contoh) :
> syarat="%" & inputan & "%"  ( % dapat diubah tgt DBMS)

> set MyRec=conn.execute("select * from tabel where alamat like '" &
>     syarat & "';")
>  
> Pencarian di 2 tabel, tinggal direlasikan saja.  Apakah data
> disimpan di file teks atau field ; saya rasa sangat tergantung dari
> struktur data yang dimiliki.

nah, ini contoh sempurna dari apa yang saya sebutkan sebagai
table-scan tanpa index sebelumnya.

-- 
Salam,

-Jaimy Azle
===========================================================
|| Personal Weblogs: http://jaim.log.web.id ||
|| Personal Delphi Weblogs: http://delphi.log.web.id ||
* Pengantar Pemrograman Database C/S, Delphi dan Firebird
    http://delphi.log.web.id/blogs/delphi/000152.html
===========================================================

“You make a lot of money by moving from number two to number one.”
      -- Larry Ellison, CEO Oracle Corp.




------------------------ Yahoo! Groups Sponsor --------------------~--> 
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/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/
 



Kirim email ke