How do you go about creating a parameter in a view? In Access SQL, I know it is done like this:
parameter @.monthSelect as int;
SELECT tbl_xlat_beg.HCNumber, tbl_xlat_beg.LocationID, tbl_xlat_beg.BegValue, tbl_xlat_beg.Unit, tblbeg.use_id,
tbl_xlat_beg.Month_id
FROM tbl_xlat_beg
WHERE (((tbl_xlat_beg.Month) = [@.monthSelect]))
where monthSelect is requested. I'm trying to set up a group of queries to gather info but am not sure how to do this or for that matter test this in SQL. Any ideas would be great.You really shouldn't cross post
http://www.dbforums.com/t970215.html
Friday, March 9, 2012
Parameters in a VIEW
Labels:
access,
creating,
database,
intselect,
microsoft,
monthselect,
mysql,
oracle,
parameter,
parameters,
server,
sql,
thisparameter,
view
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment