>>>>Why? Why, why, why? That hasn't been a limitation of foxpro files since the Reagan years! It certainly isn't a limitation of SQL!
>>>
>>>Cursors are limited to ten character field names because they don't live in a DBC.
>>
>>Nope. This works:
>>
>>CREATE CURSOR whatever (Thisisaverylongfieldname C(10))
>
>Yup, you're right. The function name threw me, and I what I intended to type was that the free table that (I'm pretty sure) gets created is limited to 10 char field names. I'd do a quick test to confirm this if I could get to any of my SQL Servers (arrrghhh, what happened?!).


Then they should have named it RSToUselessOutmodedFreeTable()

Does anyone know of another way to do this, other than rstodbf? (Which, despite it's name, is actually rstocursor!)