NaN support in dbxOda

NaN support in dbxOda

Postby LeifS » Wed 23 May 2012 13:49

Hi,
does your dbExpress driver for Oracle support writing NaN (Not a Number) to a field of type BINARY_DOUBLE?
(E.g. using the literal binary_double_nan as in http://docs.oracle.com/cd/B13789_01/server.101/b10759/sql_elements003.htm#i139891
If so, can you give a simple example of how to do this?
LeifS
 
Posts: 15
Joined: Sat 02 Sep 2006 07:29
Location: Sweden

Re: NaN support in dbxOda

Postby AlexP » Thu 24 May 2012 08:18

hello,

NaN (Not a Number) - an Oracle internal notion, and there are no analogous types in Delphi, therefore using dbExpress you can insert such data only in "clean" SQL - without using parameters
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle