Changing the code to int in convert fixed the problem. Weird, does it mean VFP converts biging to char type?

>>Hi Naomi,
>>
>>Yes, cast to decimal or float.
>>
>>MartinaJ
>>
>Can you please elaborate?
>
>I already figured that my original problem was a permission problem of some sort, so my new code is
>

>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(CONVERT (BIGINT, SIZE) * 8) AS SizeKB,
>    @MaxSize AS MaxSize, @MaxSizeDesc AS MaxSizeDesc
>	FROM sysfiles F WHERE status & 0x40 <> 0x40 -- Exclude log files
>  ENDTEXT   
>  mysqlexec(m.lcSQL, 'csrTemp', program())
>  lcSpaceWarn    = ''
>  
>  select csrTemp
>  if csrTemp.SizeKb >= .8 * csrTemp.MaxSize && 80% full

>
>Now the failing line is the last one IF ...
>
>Do you know what may be wrong here?
>
>Thanks in advance.