[Paradox 7, BDE, Delphi 4. Want SQL to be compatible with IB/MS-SQL or
whatever]
When you retrieve a floating point value of 10^307 from the database you get
1E307, but you can't use the same format to insert such a value!
The only way I found of doing it is
insert into mloc_spa_alrm_rg (min_amplitude) VALUES (CAST("1E307" as float))
These do not work
insert into mloc_spa_alrm_rg (min_amplitude) VALUES (1E307)
insert into mloc_spa_alrm_rg (min_amplitude) VALUES ("1E307")
insert into mloc_spa_alrm_rg (min_amplitude) VALUES ("1.00E+307")
min_amplitude is of type "NUMBER" 1e307 is within the range of this data
type.
There is no help on scientific notation in the LOCAL SQL help.
Any sage advice? ... other than:
insert into mloc_spa_alrm_rg (min_amplitude) VALUES
(100000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000
00000)
!!!
PS. is DUG-DB dead, or am I just not getting any of the messages?
Mike
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
