sql & VBgreenspun.com : LUSENET : OpenKnowledge : One Thread |
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
yes it can be.
-- mits (kumarsami@rediffmail.com), December 05, 2003.
salam
-- alireza (ali_reza_z_62@yahoo.com), September 22, 2004.