469,923 Members | 1,785 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,923 developers. It's quick & easy.

view with parameters

can I put parameters into a view?
example
CREATE VIEW `dmz_sms`.`vwProva` AS
SELECT * FROM tb_sms where id=@ID;
I get error 1351, but I don't believe mySql don't allow parameters into
views!!!

Jun 7 '06 #1
1 9059

<pa********@gmail.com> wrote in message
news:11**********************@j55g2000cwa.googlegr oups.com...
can I put parameters into a view?
example
CREATE VIEW `dmz_sms`.`vwProva` AS
SELECT * FROM tb_sms where id=@ID;
I get error 1351, but I don't believe mySql don't allow parameters into
views!!!

My guess is that you can do this within a stored procedure, but my question
is why you are doing this. Not critizing, just interested. Your view is a
identical to the base table in terms of columns. So I'm wondering why you're
doing this.

Thanks,
Rich
Jun 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Fran?ois Bourdages | last post: by
11 posts views Thread by Paul Reddin | last post: by
19 posts views Thread by Lyle Fairfield | last post: by
6 posts views Thread by Woody Splawn | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.