John,
You're probably not getting a row back because SQL Server detects that you're doing the variable assignment.
If you're trying to retrieve the account number and name, you'll have to mark the parameters as OUTPUT and call the stored procedure using the ODBC escape syntax.
Make the stored procedure look like this:
CREATE Procedure VerifyLogin
@userid varchar(50),
@Password varchar(50),
@AccountID int OUTPUT,
@Name varchar(100) OUTPUT
As
Call it like this
LOCAL lnAccount, lcName, lhConn, lnResult
lhConn = SQLCONNECT(...)
lnResult = SQLEXEC(lhConn, "{CALL VerifyLogin ('user', 'password', ?@lnAccount, ?@lcName)}")
-Mike