I got the problem OUT !!
NOW, I know what's wrong with it......
when i click the "test" everything goes well but when I click ok .... recordset disappear...
if the recordset disappear.. I can't update the DAsearch.... because the wizard is not reenterable....
So... I try it again....
but this time I find that Dreamweaver make the SQL "Select #@%$^# " into one line but usually for the better understanding ... I will turn my code into several ines.... like
"select
***
***
from
***
*** ; "
that's the problem ....
thistime, I make the SQL code into one line.....
the recordset didn't disappear ....
WOW... Amazing...
SO... I solve it .....
But Still thanks for replying so fast ...