To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94467
User bormant changed the following:
What |Old value |New value
================================================================================
CC|'mechtilde' |'bormant,mechtilde'
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Thu Dec 25 08:24:20
+0000 2008 -------
This is prevoyance.dbf interpretation.
Header:
[code]
00000000 30 01 07 05 06 00 00 00 28 02 3b 00 00 00 00 00 |0.......(.;.....|
~1 ~~~~~~~2 ~~~~~~~~~~3 ~~~~4 ~~~~5
00000010 00 00 00 00 00 00 00 00 00 00 00 00 03 03 00 00 |................|
~6 ~7
[/code]
1 - sugnature, 0x30 - Visual FoxPro
2 - last modification YYMMDD - 01/07/05
3 - number of records, LSB_32 - 6
4 - header size/first record offset, LSB_16 - 0x0228
5 - record size, LSB_16 - 0x3b=59
6 - flags, 00000011b - 0x1 structure .cdx, 0x2 - has memo .fpt
7 - codepage mark 0x3 - 1252 -- Windows, U.S.A & West European (FP, VFP
specific)
see also: http://www.openoffice.org/issues/show_bug.cgi?id=18728
Field descriptors:
[code]
00000020 50 4b 5f 50 52 45 56 4f 59 41 00 49 01 00 00 00 |PK_PREVOYA.I....|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~1 ~2 ~~~~~~~~~~3
00000030 04 00 06 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
~4 ~5 ~7
[/code]
1 - field name - PK_PREVOYA
2 - field type - 'I' signed integer LSB_32
3 - data offset in record, LSB_32 - 0x1
4 - field size - 0x4 (fixed for 'I')
5 - precision - 0x0 (fixed for 'I')
6 - flags, 00000110b - 0x2 can be Null, 0x4 has binary data
[code]
00000040 46 4b 5f 43 4c 49 45 4e 54 53 00 49 05 00 00 00 |FK_CLIENTS.I....|
00000050 04 00 06 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00000060 46 4b 5f 45 4e 56 45 4c 4f 50 00 49 09 00 00 00 |FK_ENVELOP.I....|
00000070 04 00 06 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
00000080 44 41 54 45 53 4f 55 53 43 00 00 54 0d 00 00 00 |DATESOUSC..T....|
00000090 08 00 06 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
000000a0 4e 55 4d 50 4f 4c 49 43 45 00 00 43 15 00 00 00 |NUMPOLICE..C....|
000000b0 19 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
000000c0 43 4f 4d 4d 45 4e 54 53 00 00 00 4d 2e 00 00 00 |COMMENTS...M....|
000000d0 04 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
000000e0 4d 4f 4e 54 41 4e 54 00 00 00 00 42 32 00 00 00 |MONTANT....B2...|
000000f0 08 0e 06 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
[/code]
FK_CLIENTS, I, 0x5, 4, 0, null,bin
FK_ENVELOP, I, 0x9, 4, 0, null,bin
DATESOUSC, T, 0xd, 8, 0, null,bin
NUMPOLICE, C, 0x15, 0x19=25, 0, null
COMMENTS, M, 0x2e, 4, 0, null (4 ASCII digits - block number in fpt)
MONTANT, B, 0x32, 8, 0xe=14, null,bin (8 bytes in IEEE representation) (VFP
specific)
[code]
00000100 5f 4e 75 6c 6c 46 6c 61 67 73 00 30 3a 00 00 00 |_NullFlags.0:...|
00000110 01 00 05 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
[/code]
_NullFlags, pseudotype '0', offset 0x3a, flags 0x1 - system column
bitmap for fields to test 'IS NULL' condition (VFP specific)
http://www.foxcentral.net/microsoft/WhatsNewInVFP9_Chapter09.htm
http://www.dfpug.de/buecher/fundamentals/Hack6/S1C2.HTM
[code]
00000120 0d
[/code]
end of field descriptors marker
[code]
00000121 70 67 64 61 74 61 73 2e 64 62 63 00 00 00 00 |.pgdatas.dbc....|
00000130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
*
00000220 00 00 00 00 00 00 00 00
[/code]
"hole" between field descriptors, VFP backlink info, has database (.dbc) file
name
First record:
[code]
00000228 2a 01 00 00 00 3c 01 00 00 9b 00 00 00 5e 6a 25
~1 ~~~~~~~~~~2 ~~~~~~~~~~~3 ~~~~~~~~~~4 ~~~~~~~~
00000238 00 00 00 00 00 61 32 33 20 20 20 20 20 20 20 20
~~~~~~~~~~~~~5 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
00000248 20 20 20 20 20 20 20 20 20 20 20 20 20 20 00 00
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~6 ~~~~~
00000258 00 00 00 00 00 00 00 00 00 00 00
~~~~7 ~~~~~~~~~~~~~~~~~~~~~~~8 ~9
[/code]
1 - delete flag, 2a='*' - deleted
2 - PK_PREVOYA, 0x00000001=1
3 - FK_CLIENTS, 0x0000013с=316
4 - FK_ENVELOP, 0x0000009b=155
5 - DATESOUSC, has binary representation of date instead YYYYMMDD (bin flag was
on!)
6 - NUMPOLICE, "a23 "
7 - COMMENTS, zeroes
8 - MONTANT, 0
9 - _NullFlags, 0 - no NULL fields in record
Second record:
[code]
00000263 20 03 00 00 00 3c 01 00 00 9b 00 00 00
~1 ~~~~~~~~~~2 ~~~~~~~~~~3 ~~~~~~~~~~4
00000270 c7 69 25 00 00 00 00 00 66 64 66 64 66 64 20 20
~~~~~~~~~~~~~~~~~~~~~~5 ~~~~~~~~~~~~~~~~~~~~~~~
00000280 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
00000290 20 00 00 00 00 00 00 00 00 00 00 00 00 00
~6 ~~~~~~~~~~7 ~~~~~~~~~~~~~~~~~~~~~~~8 ~9
[/code]
1 - delete flag, 20=' ' - NOT deleted
2 - PK_PREVOYA, 0x00000003=3
3 - FK_CLIENTS, 0x0000013с=316
4 - FK_ENVELOP, 0x0000009b=155
5 - DATESOUSC, has binary representation of date instead YYYYMMDD (bin flag was
on!)
6 - NUMPOLICE, "fdfdfd "
7 - COMMENTS, zeroes
8 - MONTANT, 0
9 - _NullFlags, 0 - no NULL fields in record
and so on...
[code]
0000038a 1a
[/code]
0x1a - EOF-marker, in position number_of_records*record_size+header_size
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
