>I'll give it another shot. I tried the B(16) in the DBSetprop as you showed below but in my DBCX it still show B with a length of 8 ( whatever that means ) and Binary = .f.
>
>They just used float for everything, including fields that would go into the millions but with only 2 or 3 decimals and other fields with values that would never be more than 1 but could go 10 decimals.)
>
>What would be the proper data types in SQL to do the cast on the sql select in the remote view for those two cases so they would make sense to VFP?
>
>i.e. I don't need to treat them the same as there are definitely 2 categories of numbers that are using float, and each is limiited on each side of the decimal.
>
Have you tried casting them, say, as Decimal (20,10) ?
If it's not broken, fix it until it is.
My Blog