Hi Naomi,

Yes, cast to decimal or float.

MartinaJ

>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.