Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Select
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP
Network:
Novell 6.x
Database:
MS SQL Server
Miscellaneous
Thread ID:
01017040
Message ID:
01017044
Views:
26
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform