Re: [mdb-dev] counting fixed / variable data rows

[<kn...@gr...>]

That's definitely better.  (Sorry I didn't have time to work on it today -
political battles...)  The date fields are still missing though.  Also, when
I tried this on the full database, it only did the first 15 items and then
quit, although prtable reports (correctly) that there are 475 rows.

-- Karl --

> > 	82,99,8,"UPDATE_ID_LEN","1996-05-19-00.00.00.000000","1996-05-19-00.00.00.000000",,1,1,1,0,"None"
> > 	82,100,26,"UPDATE_TMSTP_LEN","1996-05-19-00.00.00.000000","1996-05-19-00.00.00.000000",,1,1,1,0,"None"
> > 	82,101,40,"DEPT_NM_LEN","1996-07-11-00.00.00.000000","1996-07-11-00.00.00.000000",,1,1,1,0,"None"
> > 	82,102,3,"TTL_TP_CL_LEN","1996-07-11-00.00.00.000000","1996-07-11-00.00.00.000000",,1,1,1,0,"None"
> > 	82,6291458,4,"SIC_TP_LEN","1998-09-08-17.12.36.000000","1998-09-08-17.12.36.000000",,41,41,1,0,
> > 	82,15728641,3,"STD_ENTR_CL_LEN","2000-02-15-11.48.09.000000","2000-02-15-11.48.09.000000",,82,82,0,0,

23:03 248 util: ./mdb-export ~/databases/db1.mdb LENGTH
VERSION,ID_VALUE,MAX_LENGTH,IDENTIFIER,CREATE_DATE,LAST_MOD_DATE,EXPIRY_DATE,DEFINED_VERSION,LAST_MOD_VERSION,STATUS,DESCOPED_IND,DESCRIPTION
82,99,8,"UPDATE_ID_LEN","","","",1,1,1,0,None
82,100,26,"UPDATE_TMSTP_LEN","","","",1,1,1,0,None
82,101,40,"DEPT_NM_LEN","","","",1,1,1,0,None
82,102,3,"TTL_TP_CL_LEN","","","",1,1,1,0,None
82,6291458,4,"SIC_TP_LEN","","","",41,41,1,0,(oops)
82,15728641,3,"STD_ENTR_CL_LEN","","","",82,82,0,0,(oops)

-- prtable output

number of datarows  = 475
number of columns   = 12
number of datapages = 1
first data page     = 26
column 0 Name: VERSION              Type: Integer(2)
column 1 Name: ID_VALUE             Type: Long Integer(4)
column 2 Name: MAX_LENGTH           Type: Long Integer(4)
column 3 Name: IDENTIFIER           Type: Text(30)
column 4 Name: CREATE_DATE          Type: Text(26)
column 5 Name: LAST_MOD_DATE        Type: Text(26)
column 6 Name: EXPIRY_DATE          Type: Text(26)
column 7 Name: DEFINED_VERSION      Type: Integer(2)
column 8 Name: LAST_MOD_VERSION     Type: Integer(2)
column 9 Name: STATUS               Type: Integer(2)
column 10 Name: DESCOPED_IND         Type: Integer(2)
column 11 Name: DESCRIPTION          Type: Memo/Hyperlink(0)