Subject Re: [ib-support] Numeric (18,0) problem
Author Thomas Miller
Guillermo Najar-Arreola wrote:

>Thank you Thomas;
>
>Where in the Firebird site can I find the fixed driver?
>
On the Borland site.

>I'd need it to have
>my application working properly by now. And of course I'll go for the
>Firebird driver when its ready.
>
>Guillermo
>
>"Thomas Miller" <tmiller@...> wrote in message
>news:3D87DCC7.6090206@......
>
>
>>This was a known bug in the driver. It was fixed but not included in
>>the UP2 by accident.
>>Find the driver on the web site. Better yet, sign up for the FB
>>dbExpress driver that is in
>>beta. So far it works fine, but we won't really put it through its
>>paces until early next week.
>>
>>Guillermo Najar-Arreola wrote:
>>
>>
>>
>>>Hi,
>>>I'm using Firebird 1.0 with Delphi 6 UP2; my problem relates with BCD
>>>
>>>
>data
>
>
>>>and I donĀ“t know if the problem resides on Delphi or Firebird, so I'm
>>>
>>>
>sorry
>
>
>>>if my post is not 100% Firebird related and If you can help me, I'd
>>>appreciate very much.
>>>
>>>I have a table field defined as Numeric(18,0) in Firebird 1.0. The table
>>>
>>>
>has
>
>
>>>about 7800 records, and that field (called OID_VENDOR) started at 1, 2,
>>>
>>>
>3
>
>
>>>... ending with vaule 7,800.
>>>On my D6 UP2 app, I have the SQLDataSet-Provider-ClientDataSet components
>>>(dbExpress),
>>>linked to VENDOR table. When the DataModule is created, I get an
>>>EDataBaseError exception: "BCD Overflow" and the application can't go on.
>>>OID_VENDOR is defined in the SQLDataSet and ClientDataSet as Persistent
>>>ftFmtBCD field.
>>>I created a test application with a DBGrid on a window to show the table,
>>>using the same components as on my main application. The program ran ok,
>>>
>>>
>but
>
>
>>>on the OID_VENDOR field I saw that the first 9 records (with OID values
>>>
>>>
>from
>
>
>>>1 to 9) show "=" or "?" instead of the actual OID values 1..9. From 10 to
>>>99, the values are show ok; from 100 to 999, it shows the first 2 digits
>>>
>>>
>of
>
>
>>>the number, but the 3rd is garbled with "=" or "?".
>>>
>>>What is happening ?
>>>
>>>Guillermo
>>>
>>>
>>>
>>>
>>>
>>>To unsubscribe from this group, send an email to:
>>>ib-support-unsubscribe@egroups.com
>>>
>>>
>>>
>>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>--
>>Thomas Miller
>>Delphi Client/Server Certified Developer
>>BSS Accounting & Distribution Software
>>BSS Enterprise Accounting FrameWork
>>
>>http://www.bss-software.com
>>
>>
>>
>>
>>
>>To unsubscribe from this group, send an email to:
>>ib-support-unsubscribe@egroups.com
>>
>>
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>>
>>
>>
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com



[Non-text portions of this message have been removed]