SQL Execute

[idohadar]

I'm makign a program, for create account, edit and more ..
I started with create acouunt.
and i wanna check when i create account.
If the account already exist. and he is i'll send message or someing ..

I check in SQL Server 2005 this execute:

if exists (select 'idohadar' from [Account] where [UserID] = 'idohadar')
begin
    select 'Ido' from [Account] where [Name] = 'Ido'
end 

Just way to check if this account exist ..
In my C++ Program i used in this func to execute (ODBC):

sprintf(String, "if exists (select 'idohadar' from [Account] where [UserID] = 'idohadar')");
strcpy((char*)SqlQuery, String);
RetCode = SQLExecDirect(hStmt, SqlQuery, SQL_NTS);
if(RetCode)
{
    MsgBox("Exist");
}
else
{
    MsgBox("Not Exist");
} 

But I don't know what the 'RetCode' should return if its exist or not, i tried the all returns .. (SQL_SUCCESS, SQL_SUCCESS_WITH_INFO and the others ..)
Any idea :D ?

[MentaL]

[SandOfTime]

sprintf(String, "if exists (select * from [Account] where [UserID] = 'idohadar')");

try it

[idohadar]

sprintf(String, "if exists (select * from [Account] where [UserID] = 'idohadar')");

try it

NO, still not working ..

[Vusion]

That query wouldn't do at all.
Try something like this first of all.

SELET UserID FROM Account WHERE UserID = 'idohadar'

And afaik, there should be a function that contains the number of rows returned from such select statement. So, all you gotta do is to use this function to check if the query returned more than 0 rows, if so, msgbox userid exists.

[idohadar]

That query wouldn't do at all.
Try something like this first of all.

SELET UserID FROM Account WHERE UserID = 'idohadar'

And afaik, there should be a function that contains the number of rows returned from such select statement. So, all you gotta do is to use this function to check if the query returned more than 0 rows, if so, msgbox userid exists.

Thanks man :)
You really helpful ^^