>>Can anyone show me the proper way to embed an SQL statement - specifically the SELECT statement - into an event (in my case the click event of a command button)
>>
>>Actually, I wanted to retrieve a login_id from my table, called tbl_staff, if the input login_id supplied by the user, in this case the login_id entered into a text box called cLoginID, exists in the table.
>>
>>I tried
>>
>>(line 1) =SELECT login_id;
>>(line 2) FROM tbl_staff;
>>(line 3) INTO cString2;
>>(line 4) WHERE login_id = ThisForm.cLoginID.value
>>
>>At Line 3, i wanted to store the return value into a variable so that i can check the variable to see whether it's a valid login_id based on whether the SELECT statement was successful or not
>>
>>When i run this particular form of mine and pressed the command button after entering a value into the text box, the program run stopped and gave me a message
>>
>> SELECT variable not found
>>
>>So...can anyone show me where i went wrong?
>
>See Paul's reply, he's got a good suggestion.
>I just want to add the reason why your SELECT don't work: the result of a SELECT must be put in a table, cursor or array. It cannot be a character variable.
>Here's the correct SELECT statement for your question:
>
>SELECT login_id;
>FROM tbl_staff;
>INTO CURSOR Temp;
>WHERE login_id = ThisForm.cLoginID.value
>
>cString2 = Temp.Login_ID
>USE
If you need only to see if the SELECT found the searched login_id, than, after the SELECT test the _TALLY system variable:
IF _TALLY > 0
*-- The login_id exist
ELSE
*-- The login_id doesn't exist
ENDIF
Vlad
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement