I don't know why you should have to change it. Numeric 18,0 should get
mapped to
a FmtBCD and you should have no problem accessing it as a Float. If you
do, then
let Martijn know so he can fix it. I reported several problems with the
MetaData
stuff and he had it all fixed within 48 hrs. I have been waiting over
a year for Borland
to fix some bugs in the Oracle driver.

gnajar wrote:

>Thank you Thomas,
>
>Yes, by an email Martijn mentioned me that the driver should be ready
>soon. My problem is that I'm kind of stucked in my project with this
>Numeric(18,0)-FmtBCD issue, since all my Primary Keys in all tables
>are of this type and with this problem. I had them DOUBLE PRECISION
>before, but to avoid the precision or rounding problems I switched to
>Numeric(18,0) which gets the GUID I generate from Delphi for every
>record OID. Changing the OID type again would be painful...
>
>Regards,
>Guillermo
>www.gnsis.net
>
>
>--- In ib-support@y..., Thomas Miller <tmiller@b...> wrote:
>
>
>>Have you tried the new FB driver yet? Martijn is making lots of
>>progress on it and it should
>>be ready for prime time shortly. It just needs some pounding at
>>
>>
>this point.
>
>
>>Guillermo Najar-Arreola wrote:
>>
>>
>>
>>>Hi,
>>>I'm using Firebird 1.0, with dbExpress (Interbase driver) - Delphi
>>>
>>>
>6 UP2. I
>
>
>>>know that the UP2 Interbase driver has some bugs related to BCD
>>>
>>>
>data fields
>
>
>>>that come from Firebird types like Numeric(18,0). I just want to
>>>
>>>
>check wtih
>
>
>>>you if it is another driver bug or I'm doing something wrong.
>>>For a table where I have random values on a OID Primary Key field
>>>Numeric(18,0) , I was happy inserting,deleting, updating from my
>>>
>>>
>Delphi
>
>
>>>Client. Then, I had to change key values so each record started at
>>>
>>>
>OID
>
>
>>>289349199046620160, to follow with 289349199046620161,
>>>
>>>
>289349199046620162,
>
>
>>>289349199046620163 and so on.
>>>I made the change using a stored proc in Firebird, and then
>>>
>>>
>committed
>
>
>>>succesfully those changes. The funny thing is that now in my
>>>
>>>
>Delphi app
>
>
>>>after ApplyUpdates on any update I want to do over the changed
>>>
>>>
>table, I get
>
>
>>>"Record not found or changed by another user".
>>>Checking the SQL Monitor, the SQL UPDATE statement is generated
>>>
>>>
>correctly
>
>
>>>when I modified field "DescripcionServicio" on the SERVICIO table:
>>>
>>>update "SERVICIO" set
>>>"DescripcionServicio" = ?
>>>where
>>>"OID_SERVICIO" = ?
>>>
>>>The only theing I see is that for other tables where OID records
>>>
>>>
>are random
>
>
>>>numbers, everything works fine. But when the OID has a pattern of
>>>
>>>
>say 16
>
>
>>>digits, and just the last 2 changed from record to record, I get
>>>
>>>
>this error
>
>
>>>from the corresponding SQLDataSet-Provider-ClientDataSet.
>>
>>
>>>Any help?
>>>Guillermo Nájar
>>>www.gnsis.net
>>>
>>>
>>>
>>>
>>>To unsubscribe from this group, send an email to:
>>>ib-support-unsubscribe@e...
>>>
>>>
>>>
>>>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/
>
>
>
>
>

--
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]