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

[Brian B. <ca...@um...>]

Karl,

easy fix (I just overlooked it), the old code assumes that a fixed length
column never varied in size (duh) so a long int is always 4, an int is
always 2, etc... so the code passes '0' as the size in the call to
mdb_col_to_string() this needs to changes to 'col->col_size' and all will
work.  I'm sort of stumped on why it reads only 15 items though.  Sounds
like it reads the first page and stops.  The page linkage for data pages is
definately something that needs work.

BTW, do you mind if we name the utilities 'mdb-'whatever (like changing
schema to mdb-schema, tables to mdb-tables)? I'd like them to be unambigious
so they can be put in /usr/bin on a distro and not conflict with anything
else.


Brian

On Wed, 15 Mar 2000 kn...@gr... wrote:

> 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)
> 
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev
>