Foxpro suppports up to 255 (254 with nulls) fields per table only.
> I trying to select records from my table in sql server and I am getting the following error:
>
>Too Many Columns.
>
>Here is the code I am using to retrive the records:
>
>lcSqlCmd="Select * from Meet376.dbo.DLFile order by regno"
>
>IF sqlexec(Cn,lcSqlCmd,'c_download')<1
> =MESSAGEBOX(SUBSTR(aErrorArray[1,3],xStrLoc,255),16,"SQL Server Error")
> RETURN
>ENDIF
>
>What do I need to do?
>
>Thanks
--sb--