View Single Post
  #1 (permalink)  
Old June 20th, 2003, 01:17 AM
PeteS PeteS is offline
Registered User
 
Join Date: Jun 2003
Location: Tucson, AZ, .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Setting a Variable = Result of a SQL Query

I want to retreive one piece of text data from the database and assign it to a String variable. The SQL statement that would successfully retreive the correct piece of data would be something like:

"SELECT FirstName FROM Employee WHERE EmpID = x"

where x would be a value set in the VB application.
How would I set a variable, say "CurrentEmp", = to the result of that query?

TIA,
Pete S - Tucson, AZ
Reply With Quote