>>select * FROM ji!job WHERE (vcWhere)

You can check this code if applicable to you...

nCRMID=Thisform.search.value&& input box for customer to get from sql db
= SQLSETPROP(lnConnHandle, 'asynchronous', .F.)
= SQLEXEC(lnConnHandle, 'SELECT * FROM CRMPML1 WHERE ID = ?nCRMID','RV_CRMPML')
= SQLCANCEL(lnConnHandle)
= SQLDISCONNECT(lnConnHandle)
SELECT RV_CRMPML

I used this code to retrieve a certain customer from a sql server table then show the result to a form...

If your retrieving a record from sql table, you can make a code similar to this code..