>How come VFP limited the capacity of remote view to 255 fields when sql is capable of handling up to a thousand?

well, 255 fields is the limit for a VFP Cursor.
Neither a VFP .DBF nor a Cursor can have more than 255 fields.


>Is there any other solution aside from splitting the fields into 2 tables?

Maybe you can create a stored procedure in the backend database that returns an XML string instead of a cursor.