Hi,

VFP8 sp1 not fixed this VFP Engine bug

* get a SQL Connection h
text to myCommand noshow
DECLARE @an_Tipo TINYINT
--SET @an_Tipo=1
SELECT * FROM dbo.unknown
endtext
? sqlexec(m.h,m.myCommand)
AERROR(ax)
* you get
* ax [1,1] = 1526
* ax [1,2] = "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Il nome di oggetto 'dbo.unknown' non è valido."
* ax [1,3] = "[Microsoft][ODBC SQL Server Driver][SQL Server]Il nome di oggetto 'dbo.unknown' non è valido."
* ax [1,4] = "S0002"
* ax [1,5] = 208
* ax [1,6] = 1
* ax [1,7] = NULL

If you remove the TSQL comment prefix

* get a SQL Connection h
text to myCommand noshow
DECLARE @an_Tipo TINYINT
SET @an_Tipo=1
SELECT * FROM dbo.unknown
endtext
? sqlexec(m.h,m.myCommand)
AERROR(ax)
* you get
* ax [1,1] = 1526
* ax [1,2] = 'Connectivity error: Unable to retrieve specific error information.  Driver is probably out of resources'
* ... null ...

the ODBC error information are hidden by VFP engine error.

I use many DECLARED variables and set it on complex TSQL script!

Fabio