>>Well, as a workaround you always can have a separate cursor created
>>and insert data into it from the cursor created from SQL Server.
>>Would this solution work?

That's essentially what I've done as a work around.

Select ' ' as cNumericField,numericfield from SQLServerTable into mycursor

Then:
replace cNumericfield with transform(numericfield) ALL in mycursor

It's just a big PIA to have to do that every time.

This problem sounds like another one of those driver/odbc interpretation issues that Fox seems to have. I can't use varchar(max) I have to use text because I'm using Using driver={SQL Server Native Client 10.0}

If I switch to a different driver I can use varchar(max) but then date fields come across as character fields which is even worse.

I would pay $$ for a driver that actually worked with all the data types properly.


In SQL Server, Is there a way to do:
select transform(numericfield,'9,999,999.99') as cnumericfield

This would at least save me from having to do that 2 part process of select then replace.