Question on numeric and decimal columns

tolson68 · Post by **tolson68** » Fri 04 May 2007 20:13

I am evaluating SDAC for a client. We need a dataset solution that will see a decimal(30,15) as a TFMTBCDField. In the testing I have done I the MSQuery and MSTable comonents see it as a TFloatField or TBCDField depending on the setting of EnableBCD. Is there a way to get the components to use the TFMTBCDField instead? If not TFMTBCDField how about a TStringField so we don't lose any precision?

Tom

tolson68 · Post by **tolson68** » Sat 05 May 2007 00:00

I found an article in the forum that mentioed the MSConnection.Options.NumericType property. I will be putting in a favorable review of SDAC to our client on Monday.

Tom