HI
     In vb6.o to get a data from MS-Access d.base we wl use the below coding..
        rs!fieldname..
            For Sql2000
                  what is the corrresponding syntax..
                 help me..

hi there...

if you are still in vb6 is the same syntaxis, it only change if you change your language, not your database.


HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========