SEO

#1 (**permalink**) 02-29-2008, 06:39 PM

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 ***

#2 (**permalink**) 02-29-2008, 06:39 PM

Should be more something like:

....CT3HDR.RUNYEAR=" & MRUNYEAR & "ORDER BY ...

HTH, jens Suessmeyer.

#3 (**permalink**) 02-29-2008, 06:40 PM

GANESH NAIDU (ganeznaidu@yahoo.com) writes:
> 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.

I'm a little surprised over the error; I would rather expect something
about an unknown column.

You would say

RUNYEAR = ?

And then you should use the Command object to define the query, and
the .CreateParameter method to add the parameter.

By the way, judging from the appearance of the Format function, it
appears that you are using Access. This is a newsgroup for SQL
Server, so you may not get the best advice here.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

sql query in vb