>>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.
Brandon Harker
Sebae Data Solutions