Menu
▾
▴
mdbtools-dev
This list is closed, nobody may subscribe to it.
| 2000 |
Jan
|
Feb
(1) |
Mar
(53) |
Apr
(28) |
May
(5) |
Jun
(7) |
Jul
(16) |
Aug
(15) |
Sep
(10) |
Oct
(1) |
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(9) |
Feb
(7) |
Mar
(1) |
Apr
(7) |
May
(6) |
Jun
|
Jul
(15) |
Aug
(10) |
Sep
(2) |
Oct
(12) |
Nov
(3) |
Dec
(2) |
| 2002 |
Jan
(2) |
Feb
(12) |
Mar
(33) |
Apr
(30) |
May
(5) |
Jun
(18) |
Jul
(18) |
Aug
(47) |
Sep
(8) |
Oct
(7) |
Nov
(8) |
Dec
(13) |
| 2003 |
Jan
(48) |
Feb
(8) |
Mar
(10) |
Apr
(30) |
May
(6) |
Jun
(8) |
Jul
(19) |
Aug
(36) |
Sep
(19) |
Oct
(16) |
Nov
(11) |
Dec
(17) |
| 2004 |
Jan
(11) |
Feb
(22) |
Mar
(52) |
Apr
(45) |
May
(18) |
Jun
(72) |
Jul
(14) |
Aug
(31) |
Sep
(19) |
Oct
(27) |
Nov
(19) |
Dec
(25) |
| 2005 |
Jan
(16) |
Feb
(46) |
Mar
(50) |
Apr
(3) |
May
(21) |
Jun
(3) |
Jul
(24) |
Aug
(33) |
Sep
(25) |
Oct
(23) |
Nov
(30) |
Dec
(20) |
| 2006 |
Jan
(12) |
Feb
(11) |
Mar
(8) |
Apr
(15) |
May
(27) |
Jun
(15) |
Jul
(19) |
Aug
(5) |
Sep
(9) |
Oct
(1) |
Nov
(2) |
Dec
(3) |
| 2007 |
Jan
|
Feb
(3) |
Mar
(18) |
Apr
(5) |
May
(9) |
Jun
|
Jul
(10) |
Aug
(3) |
Sep
(8) |
Oct
(1) |
Nov
(7) |
Dec
(9) |
| 2008 |
Jan
(2) |
Feb
|
Mar
(10) |
Apr
(4) |
May
|
Jun
(5) |
Jul
(9) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
(8) |
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(11) |
Nov
(1) |
Dec
(20) |
| 2010 |
Jan
|
Feb
(2) |
Mar
|
Apr
(7) |
May
|
Jun
(23) |
Jul
(3) |
Aug
(6) |
Sep
(1) |
Oct
(4) |
Nov
(1) |
Dec
|
| 2011 |
Jan
(1) |
Feb
(26) |
Mar
(25) |
Apr
(11) |
May
(5) |
Jun
(5) |
Jul
(2) |
Aug
(39) |
Sep
(12) |
Oct
(6) |
Nov
|
Dec
|
| 2012 |
Jan
(19) |
Feb
(5) |
Mar
|
Apr
|
May
|
Jun
(7) |
Jul
|
Aug
(8) |
Sep
|
Oct
(3) |
Nov
(2) |
Dec
(3) |
| 2013 |
Jan
(6) |
Feb
|
Mar
(1) |
Apr
|
May
(7) |
Jun
(5) |
Jul
(2) |
Aug
|
Sep
(1) |
Oct
(2) |
Nov
|
Dec
|
| 2014 |
Jan
(4) |
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(5) |
Feb
|
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
|
From: Brian B. <ca...@um...> - 2000-03-15 12:29:25
|
Ok, weird list problems I apologize if that post twice... The thought occurred to me, there seems to be one byte at the end for each 8 columns as would be the case in a bitmask. So, 1-8 columns 1 byte, 9-16 columns 2 bytes. I have not tested this theory yet, but if anyone has conflicting data let me know. I believe I've found the required field also. In text types (only) byte 4 of the 18 byte column records has a 1 to denote that the field is required. And again the memo field has upto 244 bytes (256-12byte overhead) inline with the data and additional should go to an overflow page, but I'm not sure how all that works yet. So, all the problems are solved, we just have to code it...which won't be until at least tonight (EST) if I'm doing it. Otherwise patches are appreciated :-) Brian On Tue, 14 Mar 2000, Brian Bruns wrote: > > On Tue, 14 Mar 2000 kn...@gr... wrote: > > > I've encountered a problem I haven't been able to solve yet. Here's a > > relatively small instance. > > > > A couple things - the variable string data doesn't seem to quite be > > laid out in the same manner as other data. Some of the variable > > length data in the middle exists, while other data exists via some (as > > yet unclear to me) pointer mechanism. Also, the current code > > calculates the number of variable columns all wrong in this instance. > > > > I have hard-coded a 5 in (4 varchar fields and one "memo" field, which > > appears to be somewhat equivalent to a varchar (64K)) - this could be > > wrong, but is closer than the value that comes from the code or the > > HACKERS file description. I was wondering whether it might not be > > more beneficial to parse the data by column (0 .. 11) and select a > > data parse based upon column type, rather than parse by column type > > (fixed columns first, then variable columns), but I haven't been able > > to get past that pointer to the varchar data (in ?? below). The > > actual data does start 31 (decimal) bytes from the end of the data, > > but I can't map a length, unless it's that <0c> sitting at the > > beginning of the data. > > > > The access data: > > > > 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, > > > > prtable reports (correctly): > > > > number of datarows = 6 > > number of columns = 12 > > number of datapages = 1 > > first data page = 30 > > 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: Varchar(30) > > column 4 Name: CREATE_DATE Type: Varchar(26) > > column 5 Name: LAST_MOD_DATE Type: Varchar(26) > > column 6 Name: EXPIRY_DATE Type: Varchar(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(0) > > > > Ok, three things seem to be happening here. one is that there is an extra pad > character at the end of the row (I wish I could figure out the rules that > this follows...it seems to happen on some tables and not on others...anyway > you'll see it on page 0x001f of the mdb file you sent me, rows end 0xbf 0x0f > instead of the normal 0x0f). So, that's one problem. > > Problem two is that only INDENTIFIER and DESCRIPTION are treated as variable > length (perhaps the required field controls this?)...somthing to look at > anyway, but no answers as of yet. I can't find anything in the column > definition that my be used, but I'll keep looking. > > The third problem is the memo field preprends some info on the front of the > text. 12 bytes it appears... the first 2 seem to indicate length (0x04 for > "None") > > Brian > > > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev > |
|
From: <kn...@gr...> - 2000-03-15 03:58:00
|
I wanted to take a minute to describe what I'm trying to do with this software and describe another couple utilities that I've generated today. Our group receives a bunch of C header files from another group that is derived from the data which that group maintain in the Access database. We have to parse these header files and do some data massaging to generate a whole bunch of internal structures that we use. A royal pain. We've recently rewritten that software to use lex / yacc to improve parsing performance by two orders of magnitude (yes - a factor of 100 improvement), but it still has quirks. We wanted to get our data from the source. I have generated a little utility that basically generates C header files that mimic the structure of the database and another one that takes a CSV (Comma Separated Values) dump from the Access database and creates the arrays of data. We're not really interested in creating a database to update, just having a read-only copy of the data on the UNIX side of the house, as opposed to having to work on the PC in some Windows environment. Then we can do the data massaging upon data that is more of a "first class citizen" than upon derived data. Eventually, I hope to be able to generate both files from the .MDB file, but for the moment, getting the header files automatically and having to FTP over the CSV files and convert them isn't so bad (we get files about once a month or so). I'm going to shake this software out with some older databases (I've only worked with the latest release so far) before submitting it to be included among the tools. -- Karl -- |
|
From: Brian B. <ca...@um...> - 2000-03-15 03:09:44
|
On Tue, 14 Mar 2000 kn...@gr... wrote: > I've encountered a problem I haven't been able to solve yet. Here's a > relatively small instance. > > A couple things - the variable string data doesn't seem to quite be > laid out in the same manner as other data. Some of the variable > length data in the middle exists, while other data exists via some (as > yet unclear to me) pointer mechanism. Also, the current code > calculates the number of variable columns all wrong in this instance. > > I have hard-coded a 5 in (4 varchar fields and one "memo" field, which > appears to be somewhat equivalent to a varchar (64K)) - this could be > wrong, but is closer than the value that comes from the code or the > HACKERS file description. I was wondering whether it might not be > more beneficial to parse the data by column (0 .. 11) and select a > data parse based upon column type, rather than parse by column type > (fixed columns first, then variable columns), but I haven't been able > to get past that pointer to the varchar data (in ?? below). The > actual data does start 31 (decimal) bytes from the end of the data, > but I can't map a length, unless it's that <0c> sitting at the > beginning of the data. > > The access data: > > 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, > > prtable reports (correctly): > > number of datarows = 6 > number of columns = 12 > number of datapages = 1 > first data page = 30 > 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: Varchar(30) > column 4 Name: CREATE_DATE Type: Varchar(26) > column 5 Name: LAST_MOD_DATE Type: Varchar(26) > column 6 Name: EXPIRY_DATE Type: Varchar(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(0) > Ok, three things seem to be happening here. one is that there is an extra pad character at the end of the row (I wish I could figure out the rules that this follows...it seems to happen on some tables and not on others...anyway you'll see it on page 0x001f of the mdb file you sent me, rows end 0xbf 0x0f instead of the normal 0x0f). So, that's one problem. Problem two is that only INDENTIFIER and DESCRIPTION are treated as variable length (perhaps the required field controls this?)...somthing to look at anyway, but no answers as of yet. I can't find anything in the column definition that my be used, but I'll keep looking. The third problem is the memo field preprends some info on the front of the text. 12 bytes it appears... the first 2 seem to indicate length (0x04 for "None") Brian |
|
From: Brian B. <ca...@um...> - 2000-03-15 02:17:43
|
My understanding is that this can only happen like this (forgive the SQL syntax): create atable (col1 int, col2 varchar(20)) now populate it insert atable values(1,"test 1"); insert atable values(2,"test 2"); insert atable values(3,"test 3"); then go back and add a column alter table atable add col3 int null; so all rows already present in the database have 2 columns of data. The third column being null is not present. if I then do this: update atable set col3 = col1 where col1 <= 2; then rows 1 and 2 have 3 rows and the unmodified rows (row 3) has 2. So, you can't actually have pieces of rows stored in two locations, but you may have less than the current number of columns in a particular row. Most of this, I am guessing at based on how Sybase/MS SQL/Oracle/et al. act and from what appears to be otherwise extraneous overhead in each row (why have a column count in each row if there is no other possible value but the number of columns for that table). This change (with the slight mod) is in CVS. Brian On Tue, 14 Mar 2000 kn...@gr... wrote: > Date: Tue, 14 Mar 2000 08:27:41 -0500 (EST) > From: Brian Bruns <ca...@um...> > List-Id: MDB Tools development <mdbtools-dev.lists.sourceforge.net> > > 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). > > I was toying with that. I didn't understand if there were the possibility > that there were less than table->num_cols on a page. In that case, there > might be an instance where the index (j, in this case) were not to start at > 0 (e.g., one page has the first 4 columns, another page has the next 5, and > a third page has the last 3; these would start 0, 4, 9, with corresponding > changes in num_cols). That would complicate the algorithm somewhat. > > -- Karl -- > > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev > |
|
From: Carl S. <cgs...@wo...> - 2000-03-14 23:21:40
|
in mdb_get_objtype_string "Unknown 0x0b" in the type_name array is associated with the database properties located under the File menu. |
|
From: Carl S. <cgs...@wo...> - 2000-03-14 23:10:47
|
http://msdn.microsoft.com/library/default.htm when this page opens, on the left side, click on books, then microsoft jet database engine programmers guide. There are 13 chapers & 5 appendices. Here's a couple of links that talk about the size of some of the objects: http://msdn.microsoft.com/library/books/dnjet/apa_body.htm http://msdn.microsoft.com/library/books/dnjet/c1_body_17.htm http://msdn.microsoft.com/library/books/dnjet/c1_body_18.htm |
|
From: <kn...@gr...> - 2000-03-14 14:08:52
|
Date: Tue, 14 Mar 2000 08:27:41 -0500 (EST) From: Brian Bruns <ca...@um...> List-Id: MDB Tools development <mdbtools-dev.lists.sourceforge.net> 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). I was toying with that. I didn't understand if there were the possibility that there were less than table->num_cols on a page. In that case, there might be an instance where the index (j, in this case) were not to start at 0 (e.g., one page has the first 4 columns, another page has the next 5, and a third page has the last 3; these would start 0, 4, 9, with corresponding changes in num_cols). That would complicate the algorithm somewhat. -- Karl -- |
|
From: Brian B. <ca...@um...> - 2000-03-14 13:32:26
|
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 --
|
|
From: <kn...@gr...> - 2000-03-14 13:05:39
|
Date: Tue, 14 Mar 2000 07:07:54 -0500 (EST) From: Brian Bruns <ca...@um...> List-Id: MDB Tools development <mdbtools-dev.lists.sourceforge.net> The only problem I see it that the number of rows present may not match the number defined for the table (if you add a column to the table, it does not go back and modify existing data). Can you post the row dump for one where the existing algo fails? It may be the padding problem that someone else saw. Brian Sure. It's attached. -- Karl -- I've encountered a problem I haven't been able to solve yet. Here's a relatively small instance. A couple things - the variable string data doesn't seem to quite be laid out in the same manner as other data. Some of the variable length data in the middle exists, while other data exists via some (as yet unclear to me) pointer mechanism. Also, the current code calculates the number of variable columns all wrong in this instance. I have hard-coded a 5 in (4 varchar fields and one "memo" field, which appears to be somewhat equivalent to a varchar (64K)) - this could be wrong, but is closer than the value that comes from the code or the HACKERS file description. I was wondering whether it might not be more beneficial to parse the data by column (0 .. 11) and select a data parse based upon column type, rather than parse by column type (fixed columns first, then variable columns), but I haven't been able to get past that pointer to the varchar data (in ?? below). The actual data does start 31 (decimal) bytes from the end of the data, but I can't map a length, unless it's that <0c> sitting at the beginning of the data. The access data: 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, prtable reports (correctly): number of datarows = 6 number of columns = 12 number of datapages = 1 first data page = 30 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: Varchar(30) column 4 Name: CREATE_DATE Type: Varchar(26) column 5 Name: LAST_MOD_DATE Type: Varchar(26) column 6 Name: EXPIRY_DATE Type: Varchar(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(0) When running prdata: Pg 31 Row 0 bytes 1916 to 2047 077c <0c> //<52> <00>// //<63> <00> <00> <00>// //<08> <00> <00> <00>// ??<31>?? <39> <39> <36> <2d> .R.c.......1996- //82// //99// //8// ??pointer to "UPDATE_ID_LEN" somehow?? //1996- version id_value create_date max_length 078c <30> <35> <2d> <31> <39> <2d> <30> <30> <2e> <30> <30> <2e> <30> <30> <2e> <30> 05-19-00.00.00.0 05-19-00.00.00.0 create_date, contd. 079c <30> <30> <30> <30> <30>// //<31> <39> <39> <36> <2d> <30> <35> <2d> <31> <39> <2d> 000001996-05-19- 00000// //1996-05-19- end create_date last_mod_date 07ac <30> <30> <2e> <30> <30> <2e> <30> <30> <2e> <30> <30> <30> <30> <30> <30>// //<00> 00.00.00.000000. 00.00.00.000000// //(null) end last_mod_date expiry_date 07bc <00> <00> <00> <00> <00> <00> <00> <00> <00> <00> <00> <00> <00> <00> <00> <00> ................ expiry_date, contd. 07cc <00> <00> <00> <00> <00> <00> <00> <00> <00>// //<01> <00>// //<01> <00>// //<01> <00>// //<00> ................ // //1// //1// //1// //0 end of expiry_date defined_version last_mod_version status descoped_ind 07dc <00>// //<55> <50> <44> <41> <54> <45> <5f> <49> <44> <5f> <4c> <45> <4e>// <04> <00> .UPDATE_ID_LEN.. // //UPDATE_ID_LEN// end of descoped_ind identifier 07ec <00> <80> <00> <00> <00> <00> <00> <00> <00> <00> //<4e> <6f> <6e> <65>// <7e> <6e> ..........None~n //None// description 07fc <61> <02> <bf> <0f> a... num_cols = 1916, 12 #cols: 12 #varcols 5 EOD 110 fixed col VERSION = 82 fixed col ID_VALUE = 99 fixed col MAX_LENGTH = 8 fixed col DEFINED_VERSION = 14641 fixed col LAST_MOD_VERSION = 13881 fixed col STATUS = 12333 fixed col DESCOPED_IND = 11573 coltype 10 colstart 2 len 95 var col IDENTIFIER = coltype 10 colstart 97 len 13 var col CREATE_DATE = UPDATE_ID_LEN coltype 10 colstart 110 len 16 var col LAST_MOD_DATE = coltype 10 colstart 126 len -25 var col EXPIRY_DATE = (oops) column 1 is 82 column 2 is 99 column 3 is 8 column 4 is column 5 is UPDATE_ID_LEN column 6 is column 7 is (oops) column 8 is 14641 column 9 is 13881 column 10 is 12333 column 11 is 11573 column 12 is ... And the database: begin 644 db1.mdb M``$``%-T86YD87)D($IE="!$0@``````M6X#8F`)PE7IJ6=R0#\`G'Z?D/^% MFC'%>;KM,+S?S)UCV>W'GT;[BKQ.AOOL-UU$G/K&7BCF$[:*8%24>S:V?=^Q M=_030\^OL3,T87E;DK5\*@7Q?)D!&YC]$D]*E&P^8"9?E?C0B22%9\8?)T32 M[L]E[?\'QT:A>!8,[>DM```````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````!P$'`0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$` M`0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`! M``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$` M`0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`! M``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$` M`0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`! M``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$` M`0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`! M``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$` M`0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`! M``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$` M`0`!``$``0`!``$``0`!``$``0`!``$!`>@&`0````(`>P?V!F5T($1"```` M``"U;@-B8`G"5>FI9W)`/P"<?I^0_X6:,<5YNNTPO-_,G6/9[<>?1ON*O$Z& M^^PW742<^L9>*.83MHI@5)1[-N=\W[%W]!-#SZ^Q,S1A>5N2M7PJ!?%\F0$; MF/T23TJ4;#Y@)E^5^-"))(5GQA\G1-+NSV7M_P?'1J%X%@SMZ2T````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````!`:D#``$``0`!``$``0`! M``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$` M`0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`! M``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$` M`0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`! M``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$``0`!``$` M`0`!``$````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````_O__________________________________________ M____________________________________________________________ M____________________________________________________________ M_P(!5D,`````Q`(``!(`````````4Q$`"P`1``(````"``````8```$&```` M````$@`````````2````!```````````"03D!!,```0`!`$`````````"03D M!!,$``0`"@(`````````"03D!!(``/\``P,``0``````"03D!!,(``(`"`0` M`0``````"03D!!,*``@`"`4``0``````"03D!!,2``@`"08``0``````"03D M!#+_8_\`!`<``@``````"03D!!,:``0`#`@``@``````"03D!!)C=```#`D` M`P``````"03D!!(!`@``"@H`!```````"03D!!)J__\`"0L`!0``````"03D M!!(``/\`"PP`!@``````"03D!!(13P``"PT`!P``````"03D!!(%````"PX` M"```````"03D!!(`````"P\`"0``````"03D!!($````"Q``"@``````"03D M!!+__P```DED"%!A<F5N=$ED!$YA;64$5'EP90I$871E0W)E871E"D1A=&55 M<&1A=&4%3W=N97(%1FQA9W,(1&%T86)A<V4'0V]N;F5C=`M&;W)E:6=N3F%M M90Q2;71);F9O4VAO<G0+4FUT26YF;TQO;F<"3'8&3'90<F]P"$QV36]D=6QE M!TQV17AT<F$!``$"``'__W/__V7__W3__V[__VG______P#__P``"```"0`` M``$```'__P#__P#__P#__P#__P#__P;__]C__P#__\8`"@``"P````$!```` M`0````#_____``````0$`0```````````/____\`````!`0``DED#%!A<F5N M=$ED3F%M90D`!`8```4&```(``(&```#!@``#0`(!@``"08``!``#@8````' M```/``P&```-!@``#@`*!@``"P8```P`!@8```<&``#__P`````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````,J^`@`#`````````/__________________________`````$U2 M15!/4P`````````````````````````````````````````````````````` M`````````````````````````P````8````````````````````````````` M```````````````````````````````````````````````````````````` M```````#```````````````````````````````````````````````````` M``````````````````````````````````````````````````,````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````P`````````````````````````` M```````````````````````````````````````````````````````````` M```````````````#```````````````````````````````````````````` M``````````````````````````````````````````````````````````,` M````````'@````T````Z`@``.0$`````````````_____P$```#*O@(``P`` M``````#__________________________P````!-4D503U,````````````` M```````````````````````````````````````````````````````````` M``````,````&```````````````````````````````````````````````` M`````````````````````````````````````````````````P`````````` M```````````````````````````````````````````````````````````` M```````````````````````````````#`````0`````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````````````/S_________________ M____________________________________________________________ M____________________________________________________________ M________________________________`@%60P````#?````-@````````!3 M!``!``0``0````$`````#````0P````````2````!```````````"03D!!,` M``0`"0$`````````"03D!#($`/\`!`(``0``````"03D!!,$``0``0,``0`` M````"03D!!,```$`"$]B:F5C=$ED`U-)1`-!0TT,1DEN:&5R:71A8FQE```! M__\`__\`__\`__\`___D__\%__\`__]B__]C`@P```T````(```````````` M_____P`````$!``(3V)J96-T263__P`````````````````````````````` M``!_`'\````!``````0```H`?P-_`````0`````$```*!7\%?P````$````` M!```"@-_!G\````!``````0```H"?PA_`````0`````$```*!'__?TM+1``A M````@``(`%)E<75I<F5D!@!&:6QT97('`$]R9&5R0GDB`````0`3````#0!2 M15!/4TE43U)97TE$"0`!`0```0`!)0````$`%@```!``3D585%]615)324]. M7TM%60D``0$```$``28````!`!<````1`%9%4E]"05-%7TE$5D%,544P"0`! M`0```0`!)@````$`%P```!$`5D527T)!4T5?241604Q513$)``$!```!``%+ M2T0`VP```(``"0!/<F1E<D)Y3VX+`$-O;'5M;E=I9'1H"P!#;VQU;6Y/<F1E M<@P`0V]L=6UN2&ED9&5N#0!$96-I;6%L4&QA8V5S"`!297%U:7)E9`X`1&ES M<&QA>4-O;G1R;VP/`$%L;&]W6F5R;TQE;F=T:`X`5F%L:61A=&EO;E)U;&4. M`%9A;&ED871I;VY497AT!@!&:6QT97('`$]R9&5R0GD+`$1E<V-R:7!T:6]N M!@!&;W)M870)`$EN<'5T36%S:P<`0V%P=&EO;@P`1&5F875L=%9A;'5E%0`` M````!@``````"0```0```0``4`````$`#0````<`5D524TE/3@P```,!``0` M_____PP```,"``0```````D```$#``$```D``0($``$`_PD``0$%``$```H` M`0,&``(`;0!1`````0`.````"`!)1%]604Q510P```,!``0`_____PP```," M``0```````D```$#``$```D``0($``$`_PD``0$%``$```H``0,&``(`;0!3 M`````0`0````"@!)1$5.5$E&2452#````P$`!`#_____#````P(`!``````` M"0```0,``0``"0`!`04``0``"0`!`0<``0``"@`!`P8``@!M`$T````!``H` M```$`$Y!344,```#`0`$`/____\,```#`@`$```````)```!`P`!```)``$! M!0`!```)``$!!P`!``$*``$#!@`"`&T`5@````$`$P````T`14Y$7TU%7U1! M1U])1`P```,!``0`_____PP```,"``0```````D```$#``$```D``0($``$` M_PD``0$%``$```H``0,&``(`;0!8`````0`5````#P!$149)3D5$7U9%4E-) M3TX,```#`0`$`/____\,```#`@`$```````)```!`P`!```)``$"!``!`/\) M``$!!0`!```*``$#!@`````````````````````!```````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````````````````````````````!@```````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````````@``````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````(`````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```"`59#`````#\!`````````````%,'``0`!P`!`````0````,,```$#``` M```````````$```````````)!.0$$P``!``"`0`````````)!.0$$P0``0`) M`@`````````)!.0$$@0`_P`*`P`!```````)!.0$$@0`_P`*!``"```````) M!.0$$@0`_P`,!0`#```````)!.0$$O\````#!@`$```````)!.0$$P4``@`( M3V)J96-T260)071T<FEB=71E!4]R9&5R!4YA;64Q!4YA;64R"D5X<')E<W-I M;VX$1FQA9P```0$``0(``?__:?__;/__;O__>O__:O__=/__>@<,```.```` M`0```````````/____\`````!`0!$4]B:F5C=$ED071T<FEB=71E!0`%#``` M!@P``/__```````````#3P````````4``D\````````'``1/````````__\` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````````#*O@(``P````````#__________________________P````!- M4D503U,````````````````````````````````````````````````````` M``````````````````````````,````&```````````````````````````` M```````````````````````````````````````````````````````````` M`````````P`````````````````````````````````````````````````` M```````````````````````````````````````````````````#```````` M```````````````````````````````````````````````````````````` M``````````````````````````````````,````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````P`````````````````````````````````````````` M```````````````````````````````````````````````````````````# M`````````!X````-````.@(``#D!`````````````/____\!````RKX"``,` M````````__________________________\`````35)%4$]3```````````` M```````````````````````````````````````````````````````````` M```````#````!@`````````````````````````````````````````````` M``````````````````````````````````````````````````,````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````P`````````````````````````` M```````````````````````````````````````````````````````````` M```````````````#```````````````````````````````````````````` M``````````````````````````````````````````````````````````,` M```````````````````````````````````````````````````````````` M````````````````````````````````"$U3>7-$8@(````"``````````$` M```B"````%4````````C(R,7$P\+!P$(/P(!5D,`````#@(````````````` M4P@`!0`(``,````#````"`P```D,```````````````````````````````` M```*```````````)!.0$$@``_P`$`0`!```````)!.0$$P``!``$`@`!```` M```)!.0$$P0`!``$`P`!```````)!.0$$P@`!``*!``!```````)!.0$$@`` M_P`*!0`"```````)!.0$$@``_P`*!@`#```````)!.0$$@``_P`*!P`$```` M```)!.0$$@``_P`.<WI296QA=&EO;G-H:7`%9W)B:70'8V-O;'5M;@=I8V]L M=6UN"'-Z3V)J96-T"'-Z0V]L=6UN$G-Z4F5F97)E;F-E9$]B:F5C=!)S>E)E M9F5R96YC961#;VQU;6X```'__P#__P#__P#__P#__P#__P#__P#__P#__P`* M#```#P````($``'__P#__P#__P#__P#__P#__P#__P#__P#__P`+#```$``` M``(&``'__P#__P#__P#__P#__P#__P#__P#__P#__P`,#```$0````(!```` M`0````#_____``````0$``(````"`````/____\`````!`0````````````` M_____P`````$!``(<WI/8FIE8W02<WI2969E<F5N8V5D3V)J96-T#G-Z4F5L M871I;VYS:&EP__\``````````!,H?X```#L``!,I?X```#X``!,J?X```#X` M`!,K?X```$```!,T?X```$(``!,L?X```$(``!,M?X```$8``!,N?X```$8` M`!,O?X```$D``!,P?X```$D``!,Q?X```$P``!,R?X```$P``!,S?X\```$` M`!,$?X\```$``!,%?X\```$``!,.?X\```(``!,(?X\```,``!,&?X\```,` M`!,'?X\```,``!,/?Y```````!,)?Y```````!,*)0+_`0D!````^`F-'36, MX4#X"8T=-8SA0`````````````````````!486)L97-54T525D52,BLE`O\! M"0$```#?!'T=-8SA0-\$?1TUC.%``````````````````````%1A8FQE<U53 M15(O*R4"_P$)`0```'->BATUC.%`))6+'36,X4`````````````````````` M5&%B;&5S5%E0151!1TXS*R4"_P$)`0```*#IB!TUC.%`H.F('36,X4`````` M````````````````5&%B;&5S5%A.35-',2LE`O\!"0$```#OLH<=-8SA0.^R MAQTUC.%``````````````````````%1A8FQE<U183D-!5$<R*R4"_P$)`0`` M`!/G@!TUC.%`$^>`'36,X4``````````````````````5&%B;&5S5%A.+BLE M`O\!"0$```#2V[)F,XSA0-+;LF8SC.%``````````(```````````%1A8FQE M<TU3>7-296QA=&EO;G-H:7!S/"LE`O\!"0$```#2V[)F,XSA0-+;LF8SC.%` M`````````(```````````%1A8FQE<TU3>7-1=65R:65S-BLE`O\!"0$```#2 MV[)F,XSA0-+;LF8SC.%``````````(```````````%1A8FQE<TU3>7-/8FIE M8W1S-BLE`O\!"0$````P6=N?-(SA0."/W)\TC.%```````(````````````` M`%1A8FQE<TU3>7--;V1U;&5S,C<K)0+_`0D!````M`3>GS2,X4"T!-Z?-(SA M0``````"``````````````!486)L97--4WES36]D=6QE<S8K)0+_`0D!```` M*8&Z_O60X4"M++W^]9#A0``````"``````````````!486)L97--4WES24U% M6%-P96-S."LE`O\!"0$```"!H;[^]9#A0(&AOO[UD.%```````(````````` M`````%1A8FQE<TU3>7-)34580V]L=6UN<SHK)0+_`0D!````TMNR9C.,X4#2 MV[)F,XSA0`````````"```````````!486)L97--4WES04-%<S,K)0+_`0D! M````))6+'36,X4`DE8L=-8SA0`````````````````````!486)L97--4T=0 M051(,BLE`O\!"0$```"@Z8@=-8SA0'->BATUC.%````````````````````` M`%1A8FQE<TU31TU%5$%',RLE`O\!"0$````5R6L=-8SA0$JK;QTUC.%````` M`````````````````%1A8FQE<TU215!/4S$K)0+_`0D!````EY*#'36,X4"7 MDH,=-8SA0`````````````````````!486)L97--15194$4Q*R4"_P$)`0`` M`.=;@ATUC.%`EY*#'36,X4``````````````````````5&%B;&5S345404<P M*R4"_P$)`0```!/G@!TUC.%`YUN"'36,X4``````````````````````5&%B M;&5S34534T%'13(K)0+_`0D!````:P>%'36,X4!K!X4=-8SA0``````````` M``````````!486)L97-,14Y'5$@Q*R4"_P$)`0```/@)C1TUC.%`^`F-'36, MX4``````````````````````5&%B;&5S0U185%9!3#(K)0+_`0D!````'#Z& M'36,X4`</H8=-8SA0`````````````````````!486)L97-#5%A45$%',BLE M`O\!`0$-```````/`'L']@9Q!NP%9P7B!%T$V`-3`\X"20+$`3\!N@`U``(` M`/__```````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````$``````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````!`````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````````````````````````````````````````````````0````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````$```````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````!`6\'``````$`>P<D```````` M`%,1``L`$0`"`````@`````&```!!@```````"0`````````)`````0````` M```!``D$Y`03```$``0!```````!``D$Y`03!``$``H"```````!``D$Y`02 M``#_``,#``$````!``D$Y`03"``"``@$``$````!``D$Y`03"@`(``@%``$` M```!``D$Y`03$@`(``D&``$````!``D$Y`0R_V/_``0'``(````!``D$Y`03 M&@`$``P(``(````!``D$Y`028W0```P)``,````!``D$Y`02`0(```H*``0` M```!``D$Y`02:O__``D+``4````!``D$Y`02``#_``L,``8````!``D$Y`02 M$4\```L-``<````!``D$Y`02!0````L.``@````!``D$Y`02``````L/``D` M```!``D$Y`02!`````L0``H````!``D$Y`02__\```))9`A087)E;G1)9`1. M86UE!%1Y<&4*1&%T94-R96%T90I$871E57!D871E!4]W;F5R!49L86=S"$1A M=&%B87-E!T-O;FYE8W0+1F]R96EG;DYA;64,4FUT26YF;U-H;W)T"U)M=$EN M9F],;VYG`DQV!DQV4')O<`A,=DUO9'5L90=,=D5X=')A`0`!`@`!__\`__\` M__\`__\`__\`__\`__\`__\```@```D````!```!__\`__\`__\`__\`__\` M__\`__\`__\`__\```H```L````!`0````$`````_____P`````$!`$````` M``````#_____``````0$``))9`Q087)E;G1)9$YA;64)``0&```%!@``"``" M!@```P8```T`"`8```D&```0``X&````!P``#P`,!@``#08```X`"@8```L& M```,``8&```'!@``__\````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````$!;P<``````0![!P```````````````!``$`!```!````!``0`"``0 M`$````$``@`(``@`$``@```!``0`(```@```@```(```$```!````0``$``$ M`!``(````8````(`!``0`"```!``(``````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````````````````?X\```!_9&!W8&%@=F9V```` M$@%_CP```']G<G5O=@```!((?X\```!_;W)D>&UF=@```!()?X\```!_=69M M8'=J<G!V:6IS=@```!("?X\```!_=69S<G5W=@```!(*?X\```!_=F)U:G-W M=@```!(+?X\```!_=GUV=69M````$@Q_CP```']W8&%M9G8````2`'^/```! M?V)W?'=W8&@````2#G^/```!?V)W?'=Z8&T````2#W^/```!?VUF<&AW:0`` M`!(0?X\```%_;V9V=F!H9@```!(1?X\```%_;V9W8&@````2$G^/```!?V]F M=WUS9@```!(3?X\```%_;W5F<W)V````$A1_CP```7]O=FAO9G=@:````!(5 M?X\```%_;W9H<V!W:0```!(6?X\```%_;W9]=F!B9G8````2!7^/```!?V]V M?79J;V9\8G)M>&]P=@```!(7?X\```%_;W9]=FIO9GQV<V9B=@```!(8?X\` M``%_;W9]=F]R9'AM9G8````2&7^/```!?V]V?79O<F1X;69V6````!(:?X\` M``%_;W9]=G)A:V9B=W8````2!'^/```!?V]V?79T>&9U:F9V````$@9_CP`` M`7]O=GUV=69M8'=J<G!V:6IS=@```!('?X\```%_=WQP````$AM_CP```7]W M?'!B8'=H````$AQ_CP```7]W?'!O=F@````2'7^/```!?W=]<V9W8&AP```` M$AY_CP```7]X=F9U````$A]_CP```7]X=F9U>F9U````$B!_CP```7]Z9G5D M9G,````2(7^/```!?WIF=79J<G`````2(G^/```!?WIZ8&UX9@```&(`?X\` M``)_8&)B9G9V;6!]<GAW````$@U_CP```G]O=GUV9&$````2`Q(-?X\```)_ M;W9]=F1A````$@,````2#7^/```"?V]V?79D80```!(#$@U_CP```G]O=GUV M9&$````2`P-X=P```!(-?X\```)_;W9]=F1A````$@-`?_$S</>0X4`````` M````````````````5&%B;&5S5%A.+BLE`O\!"0$````<,@M:]Y#A0!PR"UKW MD.%``````````(```````````%1A8FQE<TU3>7-296QA=&EO;G-H:7!S/"LE M`O\!"0$````<,@M:]Y#A0!PR"UKWD.%``````````(```````````%1A8FQE M<TU3>7-1=65R:65S-BLE`O\!"0$````<,@M:]Y#A0!PR"UKWD.%````````` M`(```````````%1A8FQE<TU3>7-/8FIE8W1S-BLE`O\!"0$```![.=ES]Y#A M0'LYV7/WD.%```````(``````````````%1A8FQE<TU3>7--;V1U;&5S,C<K M)0+_`0D!````*W#:<_>0X4`K<-IS]Y#A0``````"``````````````!486)L M97--4WES36]D=6QE<S8K)0+_`0D!````$U2.?O>0X4##BH]^]Y#A0``````" M``````````````!486)L97--4WES24U%6%-P96-S."LE`O\!"0$```"7_Y!^ M]Y#A0)?_D'[WD.%```````(``````````````%1A8FQE<TU3>7-)34580V]L M=6UN<SHK)0+_`0D!````'#(+6O>0X4`<,@M:]Y#A0`````````"````````` M``!486)L97--4WES04-%<S,K)0+_`0D!````WV@]</>0X4"0GSYP]Y#A0``` M``````````````````!486)L97--4T=0051(,BLE`O\!"0$````,]#MP]Y#A M0`ST.W#WD.%``````````````````````%1A8FQE<TU31TU%5$%',RLE`O\! M"0$```#2DA9P]Y#A0-*2%G#WD.%``````````````````````%1A8FQE<TU2 M15!/4S$K)0+_`0D!````4V8U</>0X4!LA:_:]Y#A0``````````````````` M``!486)L97--15194$4Q*R4"_P$)`0```%-F-7#WD.%`!EQJU_>0X4`````` M````````````````5&%B;&5S345404<P*R4"_P$)`0```'_Q,W#WD.%`?_$S M</>0X4``````````````````````5&%B;&5S34534T%'13(K)0+_`0D!```` M`YTV</>0X4!@.Z)^]Y#A0``````````````````````````"```````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````````````````!`&>!0(````````````````` M````````$``0`$```$````$`!``(`!``(````0!````@```(```"```@`$`` M`!````0````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````!_CP```']D8'=@86!V9G8````2`7^/````?V=R=6]V````$@Q_CP`` M`']O<F1X;69V````$@]_CP```']U9FU@=VIR<'9I:G-V````$@)_CP```']U M9G-R=7=V````$@U_CP```']V8G5J<W=V````$@Y_CP```']V?79U9FT````2 M$'^/````?W=@86UF=@```!(`?X\```%_;69P:'=I````$A%_CP```7]O=GUV M8&)F=@```!(%?X\```%_;W9]=F]R9'AM9G8````2"W^/```!?V]V?79O<F1X M;69V6````!(*?X\```%_;W9]=G)A:V9B=W8````2!'^/```!?V]V?79T>&9U M:F9V````$@9_CP```7]O=GUV=69M8'=J<G!V:6IS=@```!('?X\```)_;W9] M=F1A````$@-_CP```G]V>&]O8'5]:G!G<@```!((?X\```)_>'9F=61F9VIP M9F0````2"0`````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````0```````````````$`````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````(`````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````````````````@````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````!`6\'``````$`>P<```````````````($"!`@0(```0($"!`@0(`` M`0($"!`@0(```0($"!`@0(```0($"!`````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````````'\````````2"'\````!```2 M"7\````"```2"G\````#```2"W\````$```2#'\````%```2#7^````"```2 M!'^````#```2!7^````$```2!G^````%```2!W^````3```2#G^````6```2 M#W^````9```2$'^````=```2$7^````@```2$G^````D```2$W^````I```2 M%'^````M```2%7^````P```2%G^````S```2%W^````W```2&'^````Z```2 M&7^````\```2&G^```!$```2&W^```!'```2''^```!*```2'7^```!-```2 M'G^```!3```2'W^```!7```2('^```!:```2(7^```!=```2(G^```!@``!B M`'^/```!```2`'^/```"```2`7^/```#```2`G^0```````2`W^0```````2 M`W^0```````2`W^0```````2`W^0```````2`P`````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````0``````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````(````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````````````````````````````"``````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````````````````````````````````````0!9@8"```````````````` M`````````@0($"!`@``!`@0($"!`@``!`@0````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````?P```````!((?P````$``!()?P````(``!(,?P````,``!(-?P`` M``0``!(.?P````4``!(/?P````8``!(0?X````(``!($?X````,``!(%?X`` M``0``!(&?X````4``!('?X```!4``!(*?X```!@``!(+?X```!T``!(1?X\` M``$``!(`?X\```(``!(!?X\```,``!("?Y```````!(#```````````````` M``````````````````````````````````````````````````$````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````````````````(`````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````````$`````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````(``````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````````````````@``````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````)`````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````0$;`0`````-`'L']@9Q!NP%9P7B!%T$V`-3`\X"20+$`3\!```` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````````````````````````````````````!_````"'__?P````$````` M!```<P%_````"'__?P````$`````!```<P%_````"'__?P````$`````!``` M<P%_````"'__?P`````````"```````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````0`````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````@``````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````0``````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````@```` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````$```` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````(!``````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````$`2(%`P`````````````` M``````````($"!`@0(```0($"!`@0(```0($"!`@0(```0($"!`@0(```0($ M"!`@0(```0($"!`@0(```0($"!`@0``````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````'\````````3%W\````!```3&'\````"```3'W\````"```3('\` M```"```3(7\````"```3(G\````#```3(W\````#```3)'\````#```3)7\` M```#```3)G\````$```3)W\````$```3*'\````$```3*7\````$```3*G\` M```%```3*W\````%```:`'\````%```:`7\````%```:`G\````&```:`W\` M```&```:!'\````&```:!7\````&```:!G^````"```3`'^````"```3#'^` M```"```3$G^````#```3`7^````#```3#7^````$```3`G^````$```3#G^` M```$```3#W^````%```3`W^````%```3$'^````%```3$7^````5```3&7^` M```5```3&G^````5```3&W^````8```3''^````8```3'7^````8```3'G^` M```=```:!W^````=```:"'^````=```:"7^/```!```3!'^/```!```3!7^/ M```!```3$W^/```!```3%'^/```"```3"'^/```#```3!G^/```#```3!W^/ M```#```3%7^/```#```3%G^0```````3"7^0```````3"G^0```````3"P!- M4T=-151!1P,!C@``0"P6````````-34U*2DI*2DI*2<?"_]``!$X`````0`` M#P$`6[TZ</>0X4`,]#MP]Y#A0`````!46$Y-4T<#`:P``$`H%@```````#,S M,R<G)R<G)R<E'PO_0``1-0````$```\!`(A(.7#WD.%`6[TZ</>0X4`````` M5%A.0T%41P,!;```0",6````````-#0T*"@H*"@H*"8?"_]``!$R`````0`` M#P$`UQ$X</>0X4"(2#EP]Y#A0`````!65D%,544#`<4``$`@%@```````#,S M,R<G)R<G)R<E'PO_0``1+P````$```\!`-<1.'#WD.%`UQ$X</>0X4`````` M0U185%1!1P,!;```0!H6````````-#0T*"@H*"@H*"8?"_]``!$L`````0`` M#P$``YTV</>0X4#7$3AP]Y#A0`````!,14Y'5$@#`8L``$`7%@```````#,S M,R<G)R<G)R<E'PO_0``1*0````$```\!`%-F-7#WD.%``YTV</>0X4`````` M345465!%`P%L``!`$Q8````````S,S,G)R<G)R<G)1\+_T``$28````!```/ M`0!39C5P]Y#A0%-F-7#WD.%``````$U%5$%'`P&(``!`$!8````````R,C(F M)B8F)B8F)!\+_T``$2,````!```/`0!_\3-P]Y#A0'_Q,W#WD.%``````$U% M4U-!1T4#`6P``$`,%@```````#0T-"@H*"@H*"@F'PO_0``1(`````$```\! M`,^Z,G#WD.%`?_$S</>0X4``````5%A.`P%P``!`"18````````P,#`D)"0D M)"0D(A\+_T``$1T````!```/`0#[13%P]Y#A0/M%,7#WD.%``````%9%4E-) M3TX#`4T``$`&%@```````#0T-"@H*"@H*"@F'PO_0``1&0````$```\!`$*X M*G#WD.%`0K@J</>0X4``````55-%4@,!,P``0`06````````,3$Q)24E)24E M)2,?"_]``!$4`````0``#P$`TI(6</>0X4#2DA9P]Y#A0`````!-4D503U,# M`:<``$`#%@```````#,S,R<G)R<G)R<E'PO_0``1!0````$```\!`!PR"UKW MD.%`'#(+6O>0X4````"`35-Y<U)E;&%T:6]N<VAI<',"`S(R,C(R,C(R,C(P M'PO_```1!`````$``````````````````````0`````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````````0!"`<$```````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````````````````````?X````(``!,`?X````(` M`!,-?X````,``!,!?X````0``!,"?X````0``!,+?X````4``!,#?X````4` M`!,,?X```!0``!,0?X```!0``!,1?X```!D``!,2?X```!D``!,3?X```!T` M`!,4?X```!T``!,5?X```"```!,6?X\```$``!,$?X\```$``!,%?X\```$` M`!,.?X\```(``!,(?X\```,``!,&?X\```,``!,'?X\```,``!,/?Y`````` M`!,)?Y```````!,*```````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````(``````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````````````````````!`$(!P4````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````PL``@`,````"03D!`->``(`#`P``@`-````"03D!`(````` M!U9%4E-)3TX(241?5D%,544*241%3E1)1DE%4@1.04U%#45.1%]-15]404=? M240+0U)%051%7T1!5$4-3$%35%]-3T1?1$%410M%6%!)4EE?1$%410]$149) M3D5$7U9%4E-)3TX03$%35%]-3T1?5D524TE/3@935$%455,,1$530T]0141? M24Y$"T1%4T-225!424].```!`0`!__\`__^.__\!__\`__\`__]T__]F__]H M!!0``!4````)````````````_____P`````$!`$'4%))34M%60P``A0```,4 M``#__P````````````````#_____``````0$`0=04DE-2T59#``"/````SP` M`/__```````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``%+2T0`$````(``"`!297%U:7)E9!P````!``T````'`%9%4E-)3TX)``$! M```!``$=`````0`.````"`!)1%]604Q510D``0$```$``1\````!`!`````* M`$E$14Y4249)15()``$!```!``%+2T0`$````(``"`!297%U:7)E9!P````! M``T````'`%9%4E-)3TX)``$!```!``$=`````0`.````"`!)1%]604Q510D` M`0$```$``1P````!``T````'`%194$5?240)``$!```!``$>`````0`/```` M"0!,3U=?5D%,544)``$!```!``$?`````0`0````"@!(24=(7U9!3%5%"0`! M`0```0`!'P````$`$`````H`241%3E1)1DE%4@D``0$```$``4M+1``0```` M@``(`%)E<75I<F5D'`````$`#0````<`5D524TE/3@D``0$```$``1T````! M``X````(`$E$7U9!3%5%"0`!`0```0`!'P````$`$`````H`241%3E1)1DE% M4@D``0$```$``4M+1``0````@``(`%)E<75I<F5D'`````$`#0````<`5D52 M4TE/3@D``0$```$``1T````!``X````(`$E$7U9!3%5%"0`!`0```0`!'P`` M``$`$`````H`34%87TQ%3D=42`D``0$```$``1\````!`!`````*`$E$14Y4 M249)15()``$!```!``%+2T0`$````(``"`!297%U:7)E9!P````!``T````' M`%9%4E-)3TX)``$!```!``$=`````0`.````"`!)1%]604Q510D``0$```$` M`1\````!`!`````*`$E$`0```````````````````(`````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````!```````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````0`````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````$`0@'!0`````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M`````````````````````````````````````````'^````"```3`'^````" M```3#7^````#```3`7^````$```3`G^````$```3"W^````%```3`W^````% M```3#'^````4```3$'^````4```3$7^````9```3$G^````9```3$W^````= M```3%'^````=```3%7^````@```3%G^````@```3%W^````C```3&'^````C M```3&7^````F```3&G^````F```3&W^````I```3''^````I```3'7^````L M```3'G^````L```3'W^````O```3('^````O```3(7^````R```3(G^````R M```3(W^````U```3)'^````U```3)7^````X```3)G^/```!```3!'^/```! M```3!7^/```!```3#G^/```"```3"'^/```#```3!G^/```#```3!W^/```# M```3#W^0```````3"7^0```````!2TM$`!````"```@`4F5Q=6ER960<```` M`0`-````!P!615)324]."0`!`0```0`!&P````$`#`````8`5%A.7TE$"0`! M`0```0`!'P````$`$`````H`34534T%'15])1`D``0$```$``2$````!`!(` M```,`$U%4U-!1T5?34]$10D``0$```$``4M+1``0````@``(`%)E<75I<F5D M'`````$`#0````<`5D52`!$X`````0``#P$`6[TZ</>0X4`,]#MP]Y#A0``` M``!46$Y-4T<#`:P``$`H%@```````#,S,R<G)R<G)R<E'PO_0``1-0````$` M``\!`(A(.7#WD.%`6[TZ</>0X4``````5%A.0T%41P,!;```0",6```````` M-#0T*"@H*"@H*"8?"_]``!$R`````0``#P$`UQ$X</>0X4"(2#EP]Y#A0``` M``!65D%,544#`<4``$`@%@```````#,S,R<G)R<G)R<E'PO_0``1+P````$` M``\!`-<1.'#WD.%`UQ$X</>0X4``````0U185%1!1P,!;```0!H6```````` M-#0T*"@H*"@H*"8?"_]``!$L`````0``#P$``YTV</>0X4#7$3AP]Y#A0``` M``!,14Y'5$@#`8L``$`7%@```````#,S,R<G)R<G)R<E'PO_0``1*0````$` M``\!`%-F-7#WD.%``YTV</>0X4``````345465!%`P%L``!`$Q8````````S M,S,G)R<G)R<G)1\+_T``$28````!```/`0!39C5P]Y#A0%-F-7#WD.%````` M`$U%5$%'`P&(``!`$!8````````R,C(F)B8F)B8F)!\+_T``$2,````!```/ M`0!_\3-P]Y#A0'_Q,W#WD.%``````$U%4U-!1T4#`6P``$`,%@```````#0T M-"@H*"@H*"@F'PO_0``1(`````$```\!`,^Z,G#WD.%`?_$S</>0X4`````` M5%A.`P%P``!`"18````````P,#`D)"0D)"0D(A\+_T``$1T````!```````` M````(````````````````````P`````"`"````````)```0````````````` M```'``````````$`````_P````````````````````````````````````,` M``````$````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M``````````````````````````````````````````````````````!````` M```````````````````````````````````````````````````````````` M``````````````!`2O3\`````/W_W_\`````_;__^P````````#_____`/@` M````````_@#__P```````````````````/____\`````````````?``````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````( M```````````````````````````````````````````````````````````` M``````````"U"P#_____`````/____\`````_________P````#_`/______ M__\`_P``_P#_________________`````/____________\`______\`#P`` M``````````````````````````````````````````0!"`<%```````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````?X!2?X```/\``)D'````B'^`4G^```'U``"J"0```(E_@%)_ M@``"_P``W@````"Q?X!2?X```_\``1(`````Q7^`4G^```3_``$E!P```/%_ M@%)_@``%_P`!.`L```#^?X!2?X``!OX``6H-```!"G^`4G^```?.``&``0`` M`7!_@%)_@`!.(@`!E0<```%Q?X!2?X`P`3@``:D"```!<G^`4G^`0`"D``'4 M"@```;!_@%)_@$`!T``!]0````'8?X!2?X!``OP``A`$```!V7^`4G^`0`2Z M``(K`@```=I_@%)_@$`&20`"0@,```';?X!2?X!@`0,``G<#```!W'^`4G^` M8`'_``*1!@```=U_@%)_@)``6``"J`8```'>?X!2?X"0`/\``K4````!WW^` M4G^`D`'_``+/!0```KA_@%)_@.``2P`"XP(```*Y"D0``'\+10``?PQ&``!_ M#4<``'\.2```@`!)``"``4H``(`"2P``@`-,``"`!$T``(`%3@``@`9/``"` M!U```(`(40``@`E2``"`"E,``(`+5```@`Q5``"`#58``(`.5P``@0!8``"! M`5D``($"6@``@0-;``"!!%P``($%70``@09>``"!!U\``($(8```@0EA``"! M"F(``($+8P``@0QD``"!#64``($.9@``@P!G``"#`6@``(,":0``@P-J``"# M!&L``(,%;```@P9M``"#!VX``(,(;P``@PEP``"#"G$``(,+<@``@PQS``"# M#70``(,.=0``D`!V``"0`7<``)`">```D`-Y``"0!'H``)`%>P``D`9\``"0 M!WT``)`(?P``D`F```"0"H$``)`+@@``D`R#``"0#80``)$`A0``D0&&``"1 M`H<``)$#B```D02)``"1!8H``)$&BP``D0>,``"1"(T``)$)C@``D0J/``"1 M"Y```)$,D0``D0V2``"1#I,``)(`E```D@&5``"2`I8``)(#EP``D@28``"2 M!9D``)(&F@``D@>;``"2")P``)()G0``D@J>``"2"Y\``)(,H```D@VA``"3 M`*(``),!HP``DP*D``"3`Z4``),$I@``DP6G``"3!J@``),'J0``DPBJ``"3 M":L``),*K```DPNM``"3#*X``),-KP``E`"P``"4`;$``)0"L@``E`.S``"4 M!+0``)0%M0``E`:V``"4![<``)0(N```E`FY``"4"KH``)0+NP``E`R\``"4 M#;T``)0.O@``E0"_``"5`<```)4"P0``E0/"``"5!,,``)4%Q```E0;%``"5 M!\8``)4(QP``E0G(``"5"LD``)4+R@``E0S+``"5#<P``)8`S0``E@'.``"6 M`L\``)8#T```E@31``"6!=(``)8&TP``E@?4``"6"-4``)8)U@``E@K7``"6 M"]@``)8,V0``E@W:``"7`-L``)<!W```EP+=``"7`]X``)<$WP``EP7@``"7 M!N$``)<'X@``EPCC``"7">0``)<*Y0``EPOF``"7#.<``)<-Z```EP[I``"8 M`.H``)@!ZP``F`+L``"8`^T``)@$[@``F`7O``"8!O```)@'\0``F`CR``"8 M"?,``)@*]```F`OU``"8#/8``)@-]P``F`[X``"9`/D``)D!^@``F0+[``"9 M`_P``)D$_0``F07^``"9!O\``)D'?X!2?X```&P``(,&?X!2?X```&T``(,' M?X!2?X```&X``(,(?X!2?X```&\``(,)?X!2?X```'```(,*?X!2?X```'$` M`(,+?X!2?X```'(``(,,?X!2?X```',``(,-?X!2?X```'0``(,.?X!2?X`` M`'4``)``?X!2?X```'8``)`!?X!2?X```'<``)`"?X!2?X```'@``)`#?X!2 M?X```'D``)`$?X!2?X```'H``)`%?X!2?X```'L``)`&?X!2?X```'P``)`' M?X!2?X```'T``)`(?X!2?X```'\``)`)?X!2?X```(```)`*?X!2?X```($` M`)`+?X!2?X```((``)`,?X!2?X```(,``)`-?X!2?X```(0``)$`?X!2?X`` M`(4``)$!?X!2?X```(8``)$"?X!2?X```(<``)$#?X!2?X```(@``)$$?X!2 M?X```(D``)$%?X!2?X```(H``)$&?X!2?X```(L``)$'?X!2?X```(P``)$( M?X!2?X```(T``)$)?X!2?X```(X``)$*?X!2?X```(\``)$+?X!2?X```)`` M`)$,?X!2?X```)$``)$-?X!2?X```)(``)$.?X!2?X```),``)(`?X!2?X`` M`)0``)(!?X!2?X```)4``)("?X!2?X```)8``)(#?X!2?X```)<``)($?X!2 M?X```)@``)(%`0&8`P(````2`,D'CP=1!PX'T@:9!ET&&P;3!9<%6@4>!>@$ ML`1X!$`$"03&`P```````````"@````$```````````)!.0$$P``!``$`0`` M```````)!.0$$P0`!``*`@`````````)!.0$$@``_P`#`P`!```````)!.0$ M$P@``@`(!``!```````)!.0$$PH`"``(!0`!```````)!.0$$Q(`"``)!@`! M```````)!.0$,@``_P`$!P`"```````)!.0$$QH`!``,"``"```````)!.0$ M$@`````,"0`#```````)!.0$$@`````*"@`$```````)!.0$$@``_P`)"P`% M```````)!.0$$@``_P`+#``&```````)!.0$$@`````+#0`'```````)!.0$ M$@`````+#@`(```````)!.0$$@`````+#P`)```````)!.0$$@`````+$``* M```````)!.0$$@`````"260(4&%R96YT260$3F%M9014>7!E"D1A=&5#<F5A M=&4*1&%T955P9&%T905/=VYE<@5&;&%G<PA$871A8F%S90=#;VYN96-T"T9O M<F5I9VY.86UE#%)M=$EN9F]3:&]R=`M2;71);F9O3&]N9P),=@9,=E!R;W`( M3'9-;V1U;&4'3'9%>'1R80$``0(``?__`/__`/__`/__`/__`/__`/__`/__ M```(```)`````0```?__`/__`/__`/__`/__`/__`/__`/__`/__```*```+ M`````0$````!`````/____\`````!`0!````````````_____P`````$!``" M260,4&%R96YT261.86UE"0`$!@``!08```@``@8```,&```-``@&```)!@`` M$``.!@````<```\`#`8```T&```.``H&```+!@``#``&!@``!P8``/__```` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M```````````````````````````````````````````````````````````` M````````````````````````````````````````$1T````!```/`0#3HGE* MU-[A0+?%A4K4WN%``````$Q%3D=42`,!X```0`44````````,S,S)R<G)R<G M)R4?"_]``!$&``"`````#P,`4L292-3>X4!2Q)E(U-[A0`````!3>7-296P# M`2<G)R<G)R<G)R<E'PO_```1!0``@`````\#`%+$F4C4WN%`4L292-3>X4`` M````36]D=6QE<P,!*"@H*"@H*"@H*"8?"_\``!$$``"`````#P,`4L292-3> MX4!2Q)E(U-[A0`````!38W)I<'1S`P$H*"@H*"@H*"@H)A\+_P``$0,``(`` M```/`P!2Q)E(U-[A0%+$F4C4WN%``````%)E<&]R=',#`2@H*"@H*"@H*"@F M'PO_```1`@``@`````\#`%+$F4C4WN%`4L292-3>X4``````1F]R;7,#`28F M)B8F)B8F)B8D'PO_```1&`````$```\!`%+$F4C4WN%`4L292-3>X4`"```` M35-Y<TUO9'5L97,#`2PL+"PL+"PL+"PJ'PO_```1%0````$```\!`%+$F4C4 MWN%`4L292-3>X4`"````35-Y<TUO9'5L97,R`P$M+2TM+2TM+2TM*Q\+_P`` M$0$``(`"```/"X"AC9A(U-[A0*&-F$C4WN%``````%5S97)$969I;F5D`P$L M+"PL+"PL+"PL*A\+_P``$0```(`"```/"X"AC9A(U-[A0*&-F$C4WN%````` M`%-U;6UA<GE);F9O`P%@``!``Q0````````X.#@L+"PL+"PL*A\+_T``$04` M```!```/`0#.&)=(U-[A0,X8ETC4WN%`````@$U3>7-296QA=&EO;G-H:7!S M`@,R,C(R,C(R,C(R,!\+_P``$00````!```/`0#.&)=(U-[A0,X8ETC4WN%` M````@$U3>7-1=65R:65S`@,L+"PL+"PL+"PL*A\+_P``$0,````!```/`0#. M&)=(U-[A0,X8ETC4WN%`````@$U3>7-!0T5S`@,I*2DI*2DI*2DI)Q\+_P`` M$0(````!```/`0#.&)=(U-[A0,X8ETC4WN%`````@$U3>7-/8FIE8W1S`@,L M+"PL+"PL+"PL*A\+_P``$0```!`"```/`@#.&)=(U-[A0,X8ETC4WN%````` M@$U3>7-$8@,!10``0`04````````,S,S)R<G)R<G)R4?"_]``!$#```/```` M#P,`SAB72-3>X4#.&)=(U-[A0````(!296QA=&EO;G-H:7!S`@,N+BXN+BXN M+BXN+!\+_P``$0(```\````/`P#.&)=(U-[A0,X8ETC4WN%`````@$1A=&%B M87-E<P(#*BHJ*BHJ*BHJ*B@?"_\``!$!```/````#P,`SAB72-3>X4#.&)=( MU-[A0````(!486)L97,"`R<G)R<G)R<G)R<E'PO_```!`5H``P```"P`\0?B M!],'Q`>U!Z8'EP>(!WD':@=;!^@&=08"!H\%@`4-!?X$[P1\!&T$^@/K`]P# MS0.^`TL#/`,M`[H"JP*<`BD"&@(+`OP!B0%Z`6L!7`'I`-H`RP"\```````` M```````````````````````````````````````````````````````````` M``````````````````````````````````````````````````````0%``"` M__\/``(!"PD!#P0$``"`__\/``($"PD!#P0$``"`__\/``,!"PD!#P0$``"` M__\/``';AY,@@4^K.-]6&A<C:DL1#+IH0L53&!!HR8(HK&+4NM]6&A<C:DL1 MWU8:%R-J2Q'?5AH7(VI+$3IF^^=%)PZ6'[/3[6+;,Z<*VRH4+\ZU+=]6&A<C M:DL1WU8:%R-J2Q'?5AH7(V\)`0\$!```@/__#P`"`0L)`0\$`P``@/__#P`" M!`L)`0\$`P``@/__#P`#`0L)`0\$`P``@/__#P`!VX>3((%/JSC?5AH7(VI+ M$0RZ:$+%4Q@0:,F"**QBU+K?5AH7(VI+$=]6&A<C:DL1WU8:%R-J2Q$Z9OOG M12<.EA^ST^UBVS.G"MLJ%"_.M2W?5AH7(VI+$=]6&A<C:DL1WU8:%R-O"0$/ M!`,``(#__P\``@$+"0$/!`(``(#__P\``@0+"0$/!`(``(#__P\``P$+"0$/ M!`(``(#__P\``=N'DR"!3ZLXWU8:%R-J2Q$,NFA"Q5,8$&C)@BBL8M2ZWU8: M%R-J2Q'?5AH7(VI+$=]6&A<C:DL1.F;[YT4G#I8?L]/M8MLSIPK;*A0OSK4M MWU8:%R-J2Q'?5AH7(VI+$=]6&A<C;PD!#P0"``"`__\/``(!"PD!#P08```` M``````(!"PD!#P08``````````';AY,@@4^K.-]6&A<C:DL1#+IH0L53&!!H MR8(HK&+4NM]6&A<C:DL1WU8:%R-J2Q'?5AH7(VI+$3IF^^=%)PZ6'[/3[6+; M,Z<*VRH4+\ZU+=]6&A<C:DL1WU8:%R-J2Q'?5AH7(V\)`0\$&``````````# M`0L)`0\$%0```/0````"`0L)`0<$%0```/0````!VX>3((%/JSC?5AH7(VI+ M$0RZ:$+%4Q@0:,F"**QBU+K?5AH7(VI+$=]6&A<C:DL1WU8:%R-J2Q$Z9OOG M12<.EA^ST^UBVS.G"MLJ%"_.M2W?5AH7(VI+$=]6&A<C:DL1WU8:%R-O"0$' M!!4```#T`````P$+"0$'!`$``(````$``@$+"0$'!````(````$``@$+"0$' M!`,```___P\``@$+"0$/!`,```___P\``=N'DR"!3ZLXWU8:%R-J2Q$,NFA" MQ5,8$&C)@BBL8M2ZWU8:%R-J2Q'?5AH7(VI+$=]6&A<C:DL1.F;[YT4G#I8? ML]/M8MLSIPK;*A0OSK4MWU8:%R-J2Q'?5AH7(VI+$=]6&A<C;PD!#P0!```/ M__\/``(!"PD!#P0!```/__\/``';AY,@@4^K.-]6&A<C:DL1#+IH0L53&!!H MR8(HK&+4NM]6&A<C:DL1WU8:%R-J2Q'?5AH7(VI+$3IF^^=%)PZ6'[/3[6+; M,Z<*VRH4+\ZU+=]6&A<C:DL1WU8:%R-J2Q'?5AH7(V\)`0\$`@```!0````" M`0L)`0<$!0```!0````"`... [truncated message content] |
|
From: Brian B. <ca...@um...> - 2000-03-14 12:12:38
|
The only problem I see it that the number of rows present may not match
the number defined for the table (if you add a column to the table, it
does not go back and modify existing data). Can you post the row dump
for one where the existing algo fails? It may be the padding problem that
someone else saw.
Brian
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++)
> {
> 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 --
>
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev
>
|
|
From: <kn...@gr...> - 2000-03-14 04:15:50
|
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++)
{
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 --
|
|
From: Brian B. <ca...@um...> - 2000-03-14 00:55:18
|
Does this mean Memo is 0x0c (along with Hyperlink) or 0x0d?
Brian
On Mon, 13 Mar 2000 kn...@gr... wrote:
> I ran across this in one of my databases. It can be up to 64,000 characters
> in length. Changes to libmdb/table.c:
>
> "Unknown 0x0b"
> --> "Hyperlink",
> --> "Memo"
> };
>
> --> if (col_type > 12) {
> return NULL;
>
> -- Karl --
>
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev
>
|
|
From: Carl S. <cgs...@wo...> - 2000-03-13 23:42:15
|
I created an access database with the datatypes and this was the result
of the datatypes. It looks to fill in a few of the unknowns.
static char *type_name[] = {"Unknown 0x00",
"yesno",
"byte",
"integer",
"long integer",
"currency",
"single",
"double",
"datetime",
"Unknown 0x09",
"text",
"ole",
"memo/hyperlink",
"Unknown 0x0d",
"Unknown 0x0e",
"replication id"
};
|
|
From: <kn...@gr...> - 2000-03-13 19:33:11
|
The declaration of buffer_dump in include/mdbtools.h and in dump.c should be changed to reflect the fact that it is being passed an "unsigned" char*. This will eliminate a bunch of "ffff"s in the debugging display. void buffer_dump(const unsigned char* buf, int start, int end); -- Karl -- |
|
From: <kn...@gr...> - 2000-03-13 18:43:55
|
I ran across this in one of my databases. It can be up to 64,000 characters
in length. Changes to libmdb/table.c:
"Unknown 0x0b"
--> "Hyperlink",
--> "Memo"
};
--> if (col_type > 12) {
return NULL;
-- Karl --
|
|
From: Brian B. <ca...@um...> - 2000-03-13 02:21:01
|
Wow, you must have grabbed it during the 10 minutes that it was messed up! yes, it's fixed now...along with some other things. On Sun, 12 Mar 2000, Carl Seutter wrote: > I checked the code out of CVS this afternoon and mdbtools.h presented > errors when I tried to compile the code. The file was missing some ';' > at the end of some of the forward declarations. I don't know if this > has been fixed or not. > |
|
From: Carl S. <cgs...@wo...> - 2000-03-13 01:09:48
|
I checked the code out of CVS this afternoon and mdbtools.h presented errors when I tried to compile the code. The file was missing some ';' at the end of some of the forward declarations. I don't know if this has been fixed or not. |
|
From: Brian B. <ca...@um...> - 2000-03-12 18:40:20
|
Hi all, I've created a data export program 'mdb-export' which is in CVS now. The current version exports a CSV (comma seperated value) stream to stdout. There are some fairly large changes in libmdb to support this: The binding routines are finished look at mdb-export.c or mdb_data_dump() for an example of how to bind values and loop on data rows. To do this, I changed the columns array from GArray to GPtrArray and updated schema.c to use this as well. I ifdef'd a bunch of debugging stuff in data.c change the define MDB_DEBUG to 1 to re-enable. mdb-export will have support for different delimiters and stuff but the current version doesn't in its first pass. Brian Now for a teaser: [camber@cyrix166 util]$ ./mdb-export /home/root/soluti~1.mdb ExampleTopics TopicID,Description,SortOrder,Type 1,"Build a Microsoft Windows interface.",1,"General" 2,"Work with forms and controls.",3,"Forms" 3,"Work with combo boxes, list boxes, subforms, and subreports.",4,"Forms" 4,"Query by form.",5,"Queries" 6,"Sample reports.",8,"Reports" 7,"Control what you print on reports.",10,"Reports" 8,"Calculate totals on reports.",11,"Reports" 9,"Use multiple databases.",12,"General" 11,"Sample forms.",2,"Forms" [camber@cyrix166 util]$ |
|
From: Brian B. <ca...@um...> - 2000-03-12 13:04:41
|
Done. looking at that, it made no sense...a holdover from something else I guess. Brian On Sun, 12 Mar 2000 kn...@gr... wrote: > Line 104 to 107 show: > > 104 if (var_cols_found==var_cols) > 105 len=eod - col_start; > 106 else > 107 len=col_start - mdb->pg_buf[row_end-1-var_cols_found-1]; > > Change line 107 to: > > len=mdb->pg_buf[row_end-1-var_cols_found-1] - col_start; > > -- Karl -- > > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev > |
|
From: <kn...@gr...> - 2000-03-12 05:09:16
|
Line 104 to 107 show: 104 if (var_cols_found==var_cols) 105 len=eod - col_start; 106 else 107 len=col_start - mdb->pg_buf[row_end-1-var_cols_found-1]; Change line 107 to: len=mdb->pg_buf[row_end-1-var_cols_found-1] - col_start; -- Karl -- |
|
From: Brian B. <ca...@um...> - 2000-03-12 00:44:34
|
Hi all, I've checked in the AUTHORS, so everyone gets credit where credit is due. As soon as I'm done screwing up....er fixing data.c an application program (like one of the utilities) will be able to bind column values to variables and we can get on to writing the data export routines. After that I think it would be a good idea to release a new version. Brian |
|
From: Brian B. <ca...@um...> - 2000-03-12 00:37:34
|
Cool! You can send it directly to me...or you can get an account on sourceforge.net I'll give you CVS write access. BTW, those Unknown 0x01's will go away in the newest version with Georg's patch. (they are MDB_BOOLs) Brian On Sat, 11 Mar 2000 kn...@gr... wrote: > I have written a little program to generate a strawman output file for > export of a database. Here's the output on the "Solutions" database > provided by Brian. Of course, it will need customization for specific > target databases. > > -- Karl -- > > p.s. Brian - how do I send in the necessary changes? It's about 11K - a > change to a Makefile, a new .c file and a change to mdbtools.h. > > DROP TABLE Animations; > CREATE TABLE Animations > ( > AnimationValue Long Integer (4), > AnimationDescription Varchar (255) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE Examples; > CREATE TABLE Examples > ( > TopicID Long Integer (4), > ExampleID Long Integer (4), > Description Varchar (125), > ObjectID Long Integer (4) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE ExampleTopics; > CREATE TABLE ExampleTopics > ( > TopicID Long Integer (4), > Description Varchar (100), > SortOrder Integer (2), > Type Varchar (50) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE Links; > CREATE TABLE Links > ( > recnum Long Integer (4), > Description Varchar (255), > HyperLink (null) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE SalesGoals; > CREATE TABLE SalesGoals > ( > EmployeeID Long Integer (4), > Year DateTime (Short) (8), > Goal Long Integer (4) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE tbl_CommandBars; > CREATE TABLE tbl_CommandBars > ( > CommandBarID Long Integer (4), > CommandBarName Varchar (255), > CommandBarType Varchar (255) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE tbl_ControlTypes; > CREATE TABLE tbl_ControlTypes > ( > ControlID Long Integer (4), > Description Varchar (50) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE tbl_MemberControls; > CREATE TABLE tbl_MemberControls > ( > ControlID Long Integer (4), > MemberControlID Long Integer (4), > ControlCaption Varchar (255), > ControlType Varchar (255), > Visible Unknown 0x01 (1), > ID Long Integer (4) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE USysRegInfo; > CREATE TABLE USysRegInfo > ( > Subkey Varchar (255), > Type Long Integer (4), > ValName Varchar (255), > Value Varchar (255) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE ExampleObjects; > CREATE TABLE ExampleObjects > ( > ObjectID Long Integer (4), > ObjectName Varchar (60), > ObjectType Varchar (10) > > ); > -- CREATE ANY INDEXES ... > > DROP TABLE tbl_CommandBarMembers; > CREATE TABLE tbl_CommandBarMembers > ( > MemberControlID Long Integer (4), > CommandBarID Long Integer (4), > MemberControlName Varchar (255), > MemberControlType Varchar (255), > Visible Unknown 0x01 (1), > ID Long Integer (4) > > ); > -- CREATE ANY INDEXES ... > > > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev > |
|
From: <kn...@gr...> - 2000-03-11 22:59:44
|
I have written a little program to generate a strawman output file for export of a database. Here's the output on the "Solutions" database provided by Brian. Of course, it will need customization for specific target databases. -- Karl -- p.s. Brian - how do I send in the necessary changes? It's about 11K - a change to a Makefile, a new .c file and a change to mdbtools.h. DROP TABLE Animations; CREATE TABLE Animations ( AnimationValue Long Integer (4), AnimationDescription Varchar (255) ); -- CREATE ANY INDEXES ... DROP TABLE Examples; CREATE TABLE Examples ( TopicID Long Integer (4), ExampleID Long Integer (4), Description Varchar (125), ObjectID Long Integer (4) ); -- CREATE ANY INDEXES ... DROP TABLE ExampleTopics; CREATE TABLE ExampleTopics ( TopicID Long Integer (4), Description Varchar (100), SortOrder Integer (2), Type Varchar (50) ); -- CREATE ANY INDEXES ... DROP TABLE Links; CREATE TABLE Links ( recnum Long Integer (4), Description Varchar (255), HyperLink (null) ); -- CREATE ANY INDEXES ... DROP TABLE SalesGoals; CREATE TABLE SalesGoals ( EmployeeID Long Integer (4), Year DateTime (Short) (8), Goal Long Integer (4) ); -- CREATE ANY INDEXES ... DROP TABLE tbl_CommandBars; CREATE TABLE tbl_CommandBars ( CommandBarID Long Integer (4), CommandBarName Varchar (255), CommandBarType Varchar (255) ); -- CREATE ANY INDEXES ... DROP TABLE tbl_ControlTypes; CREATE TABLE tbl_ControlTypes ( ControlID Long Integer (4), Description Varchar (50) ); -- CREATE ANY INDEXES ... DROP TABLE tbl_MemberControls; CREATE TABLE tbl_MemberControls ( ControlID Long Integer (4), MemberControlID Long Integer (4), ControlCaption Varchar (255), ControlType Varchar (255), Visible Unknown 0x01 (1), ID Long Integer (4) ); -- CREATE ANY INDEXES ... DROP TABLE USysRegInfo; CREATE TABLE USysRegInfo ( Subkey Varchar (255), Type Long Integer (4), ValName Varchar (255), Value Varchar (255) ); -- CREATE ANY INDEXES ... DROP TABLE ExampleObjects; CREATE TABLE ExampleObjects ( ObjectID Long Integer (4), ObjectName Varchar (60), ObjectType Varchar (10) ); -- CREATE ANY INDEXES ... DROP TABLE tbl_CommandBarMembers; CREATE TABLE tbl_CommandBarMembers ( MemberControlID Long Integer (4), CommandBarID Long Integer (4), MemberControlName Varchar (255), MemberControlType Varchar (255), Visible Unknown 0x01 (1), ID Long Integer (4) ); -- CREATE ANY INDEXES ... |
|
From: <kn...@gr...> - 2000-03-11 22:50:21
|
Hmmmm, the data does appear on the wrong page. I have no idea why.
Also, the code in data.c reads:
for (pg_num=1;pg_num<=table->num_pgs;pg_num++) {
mdb_read_pg(mdb,table->first_data_pg + pg_num);
This should read (methinks):
for (pg_num = 0; pg_num < table->num_pgs; pg_num++) {
mdb_read_pg (mdb, table->first_data_pg + pg_num);
-- Karl --
|
|
From: Brian B. <ca...@um...> - 2000-03-11 20:41:08
|
Karl, It looks like we are using the same version (or at least close enough) of mdb files. Your data starts on page 0x34 instead of 0x30 as my (possibly naive) algorithm expects. Everything else seems to be in agreement. How were you computing the first datapage again? This seems to be where the confusion lies. Brian |
26 messages has been excluded from this view by a project administrator.
