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

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

Hi Karl,

> On Mon, 13 Mar 2000 kn...@gr... wrote:
> 
> > The calculation of number of fixed and variable columns doesn't work for
> > some database material that I have.  I have replaced a portion of
> > data.c:mdb_read_row() with the following (perhaps non-optimal, but more
> > accurate) algorithm.
> > 
> >        /* find out all the important stuff about the row */
> > 
> >        num_cols = mdb->pg_buf [row_start];
> >        var_cols = 0;
> >        fixed_cols = 0;
> >        for (j = 0; j < table->num_cols; j++)
How about if we change this  ^  to just num_cols, I think that'll take
care of my concern...I'll put this in and look at the other stuff tonight
(when I have a little more time, heading out the door now).

Also according to some doc on MS's site memo fields are stored in seperate
VC pages.  Carl, (we have a Carl and a Karl :-/) do you have the URLs to
those pages? I should add links to them from our homepage (can't directly
post them....copyrighted stuff)

Brian

> >          {
> > 	     col = g_ptr_array_index (table->columns, j);
> > 	     if (mdb_is_fixed_col (col))
> > 		 fixed_cols++;
> >              else
> > 	         var_cols++;
> > 	 }
> > 
> > I also have been finding that a mixture of int / long / varchar is causing
> > some of the varchars to be included inline and some to be "referenced"
> > outside the data stream.  As a result, I get data something like:
> > 
> >   INT	     LONG      VC    VC (26)			    INT
> > (00 00) (00 01 7c 01) (31) ("1996-xx-yy-17.54.36.000000") (00 04)
> > 
> > And the data that the VC above should have (it's a VC 30, by the way) is
> > further down, after all the rest of the fixed and variable data...
> > 
> > I'm going to see if I can generate a small database to distribute.
> > 
> > -- Karl --