I'm trying to call a Stored Procedure in a SelectCommand on the Edit portion of an XMod Pro Form item. For some reason, the Form does not seem to be passing the parameter to the stored procedure. If I insert the raw SQL into the SelectCommand, everything works as it should. I am using the exact same stored procedure in the DetailView on the Template passing the same parameter and on the template, everything works. I also found that the Delete Command on the Template does not seem to want to pass parameters to a stored procedure. There, I too, had to insert the raw SQL instead of calling the stored procedure.

I'm using XMod Pro v 4.7.3

Someone please help. This is getting frustrating and I don't want to have to maintain SQL code in two different places. I'd much rather use stored procedures everywhere.

Thanks