Respected Sir,

I want to know that if a variable can be passed in the sql query as table name in VB programming ? Just like as : a="CS_V" recordset.Open "select * from '" & a &"' where no=0011", con, adOpenDynamic, adLockOptimistic

-- SOURABH (saurabhsapre@yahoo.co.in), November 01, 2003

Answers

yes it can be.

-- mits (kumarsami@rediffmail.com), December 05, 2003.

salam

-- alireza (ali_reza_z_62@yahoo.com), September 22, 2004.