RE: can't call a stored proc from another stored proc?

2004-04-03 Thread Michael Pheasant
] Sent: Saturday, 3 April 2004 8:57 PM To: [EMAIL PROTECTED] Subject: can't call a stored proc from another stored proc? Hi, 1) Can a stored procedure call another stored procedure? Ie, can you do 'call someproc()' from within a stored procedure? 2) Also, will a function ever b

RE: can't call a stored proc from another stored proc?

2004-04-03 Thread Matt Chatterley
t is now confirmed that views will be in 5.1 rather than 5.0? :) I know, I know.. I keep harping on about views... Regards, Matt. -Original Message- From: Michael Pheasant [mailto:[EMAIL PROTECTED] Sent: 03 April 2004 11:57 To: [EMAIL PROTECTED] Subject: can't call a stored proc from

can't call a stored proc from another stored proc?

2004-04-03 Thread Michael Pheasant
Hi, 1) Can a stored procedure call another stored procedure? Ie, can you do 'call someproc()' from within a stored procedure? 2) Also, will a function ever be able to issue a SELECT query? I am using mysql-5.0.1-alpha (built froms ource) , winXP & win2k. The mysql daemon crashes without an er