Hi everybody,

Using DSN and SQLExec from SQL Server to VFP I'm running the following code:

 TEXT TO lcSQL TEXTMERGE noshow
  DECLARE @MaxSize INT, @MaxSizeDesc varchar(10)
  SELECT @MaxSize = CASE WHEN SERVERPROPERTY('ProductVersion') > '10.5' THEN 10 * 1024 * 1024 -- 10GB for SQL Server 2008 R2 Express 
			ELSE 4 * 1024 * 1024 END,
		 @MaxSizeDesc = CASE WHEN SERVERPROPERTY('ProductVersion') > '10.5' THEN '10 GB' 
			ELSE '4 GB' END

  SELECT SUM(SIZE*8) AS SizeKB, @MaxSize AS MaxSize, @MaxSizeDesc as MaxSizeDesc
   FROM sys.master_files
    WHERE DB_NAME(database_id) = <<VFP2SQL(this.cDbName)>> AND type = 0
  ENDTEXT   
  mysqlexec(m.lcSQL, 'csrTemp', program())

I receive perfect results in SQL Server, but in VFP the SizeKB field returns NULL. Is it because VFP can not handle Bigint ? Should I try converting this value to decimal instead ?

Thanks in advance.