In the VFP7 help under Visual PoxPro System Capacities says that:
Maximum fields that can be selected by a SQL SELECT statement = 255
That's been there since VFP5 (maybe even before that) :)

HTH

>Can anyone tell me why in VFP7 when you access a SQL table with 300 columns you get an error "Too many columns"? VFP6 does not cause this error. You can't even open the table in a view in VFP7. I saw Larry Miller's work around in Thread #464652. I am wondering why the Fox team would put this limitation on VFP7.