From: Carlos G. A. <car...@te...> - 2003-07-24 16:30:34
|
Hello: > Here is the stored procedure. Could you just write me code of how YOU > would execute this stored procedure? It takes in a username and > userpassword, and it returns a userloginid and a userprivilegeid. Ok i will made a test later. > I closed the reader first and then commited. It executed fine, but no > results in the database. What you mean for reslts ?? :) This SP do not made any insert, update, delete. Finally if you want to get a resultset with all the users logins, you need to execute the command as SELECT * FROM LOGINUSER(?,?). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |