Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Stored Procedure HELP!
0 views
Skip to first unread message
YaoJun WEI
Sep 23, 2000, 3:00:00 AM9/23/00
to
Hi,
This code is error,Why? How?
Database:MS SQL Server 6.5 + ODBC
------------------------------------------------------
string p1,p2
p1 = 'ok'
p2 = 'yjwei'
DECLARE chang_passwd_proc PROCEDURE FOR Sp_password
@old = NULL, @new = :p1, @loginame = :p2;
SQLca.AutoCommit = TRUE
EXECUTE chang_passwd_proc;
SQLca.AutoCommit = false
if SQLCA.sqlcode = -1 then
MessageBox("Stored Procedure Error!",SQLCA.sqlerrtext)
end if
-------------------------------------------------------
Any help would be greatly appreciated. Thank you.
0 new messages