|
|
Posted by GANESH NAIDU on 03/09/06 14:07
i need help in sql query my coding is as under
Dim MRUNYEAR As String
MRUNYEAR = "0405"
Set fgrs = New Recordset
fgrs.Open "select CT3HDR.CT3ID, CT3HDR.CT3NO,
format(CT3HDR.ct3date,'dd/mm/yyyy'), suppmast.suppname FROM CT3HDR INNER
JOIN suppmast ON CT3HDR.suppID=suppmast.suppid WHERE
CT3HDR.RUNYEAR=MRUNYEAR ORDER BY CT3HDR.CT3NO", db, dbopenstatic,
adLockOptimistic
i am receiving error "no value given for one or more required parameter"
if i give '0405' directly in the query than it is running fine. so how
to give mrunyear variable in the query.
thanks,
ganesh
*** Sent via Developersdex http://www.developersdex.com ***
Navigation:
[Reply to this message]
|