Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: Numeric or Decimal data type import


Juergen

The schema syntax doesn't understand DECIMAL types and unfortunately is not
reporting that fact. The best way to do imports though is to create the
table in advance and then do the IMPORT. For CSV files you can then ignore
the schema completely. See the attached script.

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "Juergen Roeder" <juergen-roeder@t-online.de>
To: <instantdb@enhydra.org>
Sent: Friday, September 08, 2000 11:51 AM
Subject: InstantDB: Numeric or Decimal data type import


Hello!
I'm trying to import numeric|decimal data types from an ascii file into a
instantdb table.

The schema-file contents:
 [stt.txt]
ColNameHeader=False
CharacterSet=ANSI
Format=CSVDelimited
Col1=nx Decimal(11,3)
Col2=mx Float
Col3=lx Float
Col4=dx Float
Col5=rx Float
Col6=naax Float
Col7=laax Float
Col8=sttnr Float
Col9=alter Float

The input ascii file contents:
12345678.123,2,3,4,5,6,7,8,9

Content of the newly created instantdb table is:

mx                lx    dx    rx naax    laax    sttnr
12.345.678    2     3     4   5         6         7

I'm wondering where the first (Col1=nx) and last column(Col9=alter) gone?

Any idea?

Thanks in advance!

Juergen Roeder



d org.enhydra.instantdb.jdbc.idbDriver;
o jdbc:idb=c:\instantdb\bugs\sample.prp;

e SET EXPORT "trace.log" TRACE 6 CONSOLE;

e DROP TABLE stt;
e CREATE TABLE stt (
	nx Decimal(11,3),
	mx Float,
	lx Float,
	dx Float,
	rx Float,
	naax Float,
	laax Float,
	sttnr Float,
	alterx Float);
e IMPORT stt FROM "stt.txt";
q SELECT * FROM stt;

c close;
c exit;