Page 1 of 1

Question on numeric and decimal columns

Posted: Fri 04 May 2007 20:13
by tolson68
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

Posted: Sat 05 May 2007 00:00
by tolson68
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