Penstar
Last Activity: Mar 4 '08, 01:03 AM
Joined: Apr 18 '07
Location: Melbourne, Australia
-
Thanks for your help -
Basic MySQL Stored Procedure Syntax Problem
I have a basic Stored proc and keep getting a Syntax error. The SQL works fine, but not in the stored proc.
CREATE DEFINER=`time`@ `%` PROCEDURE `spAppendTimesh eet`();
BEGIN
UPDATE tempam1t SET tempam1t_eventi d=4;
END
Can someone please point out where I am wrong?
Thanks
Penny -
Thank you for clearing that up for me.
I really appreciate it.
PennyLeave a comment:
-
Select/update in MySQL Stored Procedure
I'm sorry if this is a really stupid question, but I have just started using mySQL.
I have created a basic stored proc, which does the following:
SELECT * from members;
I can call it from mySQL Query Browser and return the results, but the recordset can't be edited.
Is there any way that the results from a stored procedure can be directly edited, or should I be using views?
... -
Thanks again!
After much further mucking about, I found that your initial suggestion was correct. Why it didn't work was that the Subform control in the main form had a slightly different name to to subform. I recreated the subform from scratch, and started combo box from scratch AND IT WORKED!!!...Leave a comment:
-
I have tried your suggestion. Unfortunately, the Box "Enter Parameter Value" still comes up, now with the new code.Leave a comment:
-
Combo Box in Subform
I have a Combo Box on a Subform which works perfectly when the suborm is opened on its own. However, when I open the Main form Containing the Subform, and try to use the Combo Box it comes up with box "Enter Paramater Value" Forms!KS_Orders Enter_F!KS_Orde rsEnter_SF!Prod uctID.
Main form Name
KS_OrdersEnter_ F
Subform Name
KS_OrdersEnter_ SF
Forms Linked by field [OrderID]
...
No activity results to display
Leave a comment: