da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Errors with Demo "Numbers"

Forum List » NCOCI8 » General English

Boris
User

Fresh Boarder

Posts: 1

Karma: 0

Errors with Demo "Numbers"

Posted: 2000/07/13 14:04

Hello. Big pardon.
In all case I insert value=1

When I insert value in columns N110 or N11_
i get Error ORA-01438.

When I insert value in columns N19_ or N194
in database inserting vary vary big value (not 1).

And columns N__,N_0, N195 have type TStringField is that true?
NCOCI8 ver 0.8.1
Server 8.1.5
Client 8.0.5

Diman

Admin

Posts: 1495

Karma: 19

RE: Errors with Demo "Numbers"

Posted: 2000/07/22 08:36

Hi !

With N110, N11_, N19_, N194 fields there was a bug. I fixed it. Changes will be included into 0.8.2 version.

Columns N__, N_0, N195 have type TStringField, because if TOCIQuery.DataFormat.EnableNumbers = True, then "big" number fields will be mapped into otNumber (internal NCOCI8 data type) and it will be mapped into ftString (Delphi data type). This is because Delphi does not have data type with sufficient precision. If you will assign one field with otNumber type to parameter or backward, then NCOCI8 will not lost precision. Also you can use TStringField.AsFloat to access value as Double.

Forum List » NCOCI8 » General English