Thank you!

Yes, I missed your attachment - the 'attachment' symbol doesn't show in 
my reader, but the TXT file was at the foot of the message.

And I well recall the PHP! But, I'd forgotten how you handled the 
extraction of data from the PDox tables, and what DB structures you used 
in the PHP app.

I looked through Randy Beck's document, and it has Fl-Pt fields (on disk 
files) explicitly stated for only two data-types, Currency and Numbers.

It doesn't 'parse' the bits in Dates, Times, or TimeStamps. In one 
place, it states that these are 4-byte, 4-byte, and 8-byte fields, 
respectively, and, later on, the Pascal code just dumps them as 4-byte, 
4-byte, and 4-byte integers - which is ok - the programmer can parse out 
the bits, if needed. But, notice the TimeStamp type: 8 bytes initially, 
4 bytes later?? The '8' seems correct? I must be misreading something, 
somewhere!! The TimeStamp is probably a Double, but perhaps its a 
long-int - maybe of millisecs - since ???

Thanks, Bernie.
   - Michael


On 25/05/2022 07:32, Bernie van't Hof wrote:
> Hi Michael,
> 
> Perhaps you missed the attachment I included explaining the file 
> structure? Maybe I should have mentioned it in the body.
> 
> You'd recall I already wrote a whole bunch of stuff (in php) to load, 
> read, and convert PDOX files to sql (albeit I stopped at 4.5).
> 
> - Bernie
> 
> On 23/5/2022 5:40 am, Michael Kennedy wrote:
>> On 21/05/2022 22:48, Bernie van't Hof wrote:
>>>   I wold love to know how to examine the
>>>> contents of the db or px files
>>
>> Bernie,
>>
>> Over the decades, the internal structures of the PDox files have been 
>> mostly, or perhaps fully, unravelled already. These should be 
>> available through Google searches, and have been touched on in some 
>> PDox books. The folks who supplied/supply independent table-viewer 
>> utils, or table-repair utils, or ODBC drivers?, etc, (for PDox), 
>> needed all such info. I think the PX files are quite standard ISAM, 
>> for example.
>>
>> If you find fully-documented structures for the version of PDox tables 
>> that you use, then you could just write some code (preferably C, or 
>> similar) to parse these PDox files, and display the contents in a 
>> readable format.
>>
>> If the structures are not fully defined, then you might need a HEX 
>> viewer (and lots of coffee!) - as I mentioned elsewhere here.
>>
>> Then, regarding the actual data fields in a table, types such as 
>> strings, boolean, integers, etc, should be trivial. Fl-pt (single and 
>> double precision) can be a nightmare! But, its various formats, and 
>> error-handling, etc, etc, are documented in thousands of websites and 
>> books...
>>
>>    - Michael