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

Craig

I tried the script that you supplied and everything looked fine - including
the date format. Note that the SET DATE command only affects tables created
after it has been issued. Existing tables use the date format that was in
effect when they were created. Could this be part of the problem?

Regards

Peter Hearty
Lutris Technologies UK


-----Original Message-----
From: owner-instantDB@Enhydra.ORG [mailto:owner-instantDB@Enhydra.ORG]On
Behalf Of Craig Wynn
Sent: 20 June 2000 19:57
To: instantdb@enhydra.org
Subject: InstantDB: Sample output


1st: My guess is (correct me) that when 1st posted this same message on
June 14 it didn't get listed because it contained a JPEG snap shot that
illustrated the IDB table output. Y/N?

e SET EXPORT "export0.txt" FIXEDLENGTH COLNAMEHEADER ROWNUMBERS
CONTROLCOL SUMMARYHEADER;

; Create the table and its index
e SET DATE FORMAT 'mmm/dd/yyyy';
e DROP TABLE customer;
e CREATE TABLE customer (
        id       int      NOT NULL PRIMARY KEY,
 FName   CHAR(30),
 MI   CHAR(2),
 LName   CHAR(30),
        BoxRt    CHAR(10),
        Street   CHAR(20),
        City     CHAR(20),
        State    CHAR(2),
 Zip1  int,
 Zip2  int,
 DegreeDay  int,
 CutOffDate  date,
 FillByDate date,);

; put some initial data in the table
p INSERT INTO customer VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?);

s 1,'Craig','J','Wynn','PO Q','301 1st Ave.
W','Velva','ND',58790,0301,2500,03/11/2000,,;
s 2,'Bob','T','Jones','PO T','2nd ST','Velva','ND',58790,,,,,;
s 3,'Marial','','LeMui','445','Main St.','Pingree','ND',58550,,,,,;
s 4,'Guss','J','Tynn','PO X','301 1st Ave. W','Velva','ND',58790,,,,,;
s 5,'Bob','T','Bones','227','22nd ST','Williston','ND',58780,,,,,;
s 6,'Marial','','Blue','PO M','Main St.','Tengreen','ND',58000,,,,,;
s 7,'Bobby','C','McVee','454','Prospect
Ave.','Timbuckto','ND',58232,0454,,,,;


c close

the sql1 code has only one record, the 1st record, with data in the
fields "DegreeDay" and
"CutOffDate". The included jpg screen shot indicates that all records
without data in these same
fields are filled with the same data from a previous record as in this
case the 1st record. If a
field like "Zip2" has data and it encounters a subsequent record with
data in this field it does
not overwrite it.

update: June20
I guess I don't really care if the  "insert into "works here at this
stage of development. It will concern me though if in the program I'm
developing the effects seen here are repeated.

What does still puzzle me is the date output to my fields in my project
"program". The results of the date data that was stored in the resulting
table when retreived and displayed is in reverse order. In other words
instead of dd/mm/yyyy the retreived date data is ending up as
yyyy/mm/dd. and why is this?

thank you
Craig

ps using VisualAge for Java 3.02 jvm 1.2

----------------------------------------------------------------------------
-
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.


-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.