Paradox Community

Items in pnews.paradox-dos

Subject:Re: qbe to sql
Date:Sat, 14 Oct 2017 14:18:45 +1000
From:Bernie van't Hof <berniev@bje.com.au>
Newsgroups:pnews.paradox-dos
Hi Larry,

Thanks for the interest.

Main goal is, as an old bloke, to have a bit of fun and just maybe 
resurrect some old pdox dos code I still use to this day.

The other goal then is to translate pdox dos pal code and provide an 
environment that will run the converted code.

The goal is to read completely unadulterated, unmodified, PDOX DOS 4.5 
PAL SC files. I realised early that fiddling with source quickly leads 
to mess. My 40K line app converts in a blink.

Target is php.

Written in php. Because that's what I'm familiar with.

Data is converted from db and px files into sql format, including 
secondary indexes. Set and Val files also interrogated to get the full 
picture.

Run-time/interpreter layer fixes up variable scope etc etc.

First convert the main script(s) and run as necessary to generate LIBs.

SC files can be converted individually or by directory.

User invokes via web page which talks to websocket server (php cli) 
which in turn creates instances of php cli which run the converted app.

Currently targeting mysql.

Scripts called (PLAY'ed) are converted on the fly if current converted 
version is out of date.

Form structures are decoded from Fxx files. Reports not looked at yet, 
but if everything else can be made to work then reports should not be 
impossible.

Current stage is query image conversion.

A l-o-n-g (!) way to go but the structure is stumbling in the right 
direction, even if some big chunks are no more than concepts.

Wanna help?

- Bernie
On 14/10/17 2:10 am, Larry DiGiovanni wrote:
> Bernie:
> 
> Can you give more information concerning the project you announced last 
> year?  I assume this is part of that effort.
> 
> If I understand correctly, your goal is to produce a translator for PDOX 
> DOS to PHP.
> 
> What language(s) is the translator written in?
> What is the runtime environment of the converted app?
> What is the target database platform of the converted app?
> Are you trying to write something that can convert unattended, or just 
> gets you started?
> If you are handling forms and/or reports, how are you doing this?
> 
> -- 
> Larry DiGiovanni


Copyright © 2004 thedbcommunity.com