Topic: how to pass parameter to stored procedure? Posted: 31 Aug 2009 at 5:26am
hi all , i am using CR2008 with mysql database i want to take dynamic parameter from user and use that parameter on sql expression or pass it to stored procedure on database .
So can i pass parameter to sql expression ? OR how can i pass parameter to stored procedure????
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 31 Aug 2009 at 6:30am
write your stored proc with the parameter. compile it on your db box. in crystal, join to the stored proc instead of a table. Crystal will automatically create parameters. You can modify the parameter to read from the database (dynamic).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
