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
; 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,
; put some initial data in the table
p INSERT INTO customer VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?);
s 1,'Craig','J','Wynn','PO Q','301 1st Ave.
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,,,,,;
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.
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?
ps using VisualAge for Java 3.02 jvm 1.2
To unsubscribe from this mailing list, send email to firstname.lastname@example.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 email@example.com.