How do you capture this variable from SQL Server?
Example of T-SQL code:
declare @[EMAIL PROTECTED]
varchar(20)
set @[EMAIL PROTECTED]
= 'This was a success...'
select @[EMAIL PROTECTED]
as NEW_FIELD
How do I capture the returned value "This was a success..." without
creating
a tem****ary table on the SQL Server? I am using MS Access and trying to
use
the ADO.Recordset.
Should I use a different method? Any suggestions or sample code?
--
A. Craft
Lead Programmer Analyst
