Personal DBMS Migration from Foxpro 2.5 a for DOS to Zoho Reporter
I have been using, for over 20 years, MS DOS 6.22, Foxpro for DOS v 2.5a
and Qbasic 1.1 for all my data processing - for my Medical
Practice, Retail Pharmacy, Banking and an Educational Trust.
These were good enough for me to make data entry,
retrieval, editing, report generation etc., and I have
been using them comfortably for over two decades only
moving upwards in Hardware upto P4 but still working with
the same OS - MS DOS and Flat-table DBMS - Foxpro for DOS.
I am a single user, no multitasking,no relationality,
no cross-table querying, data entry on the PC not via e-mail
etc., fields are only date, character and numeric - no
images/multimedia, maximum fields in a record less than 30,
maximum records in a table about 2000 - basically a very
simple flat-table Desktop DBMS is what I need.
When I tried to use Foxpro for DOS inside successive
versions of Windows, I encountered progressively increasing
difficulties till Windows 7 64 bit on my new Dell Alienware
Aurora ALX Desktop totally turned its back on 16 bit apps!
It Trend Watchers say that soon newer PC hardware
may also shun from processing my 16 bit apps.
So I have to migrate from MS DOS 6.22, QBasic 1.1
and Foxpro 2.5a to 64 bit Apps/OSs/PCs.
I have tried DOS emulators like DOSBOX(Mainly plays
Games), VMware (Much too complicated and unstable) and
VirtualBox (Steep learning curve and more time-consuming
than my 16 bit apps).
I looked around for Basic Compilers for Windows and
simple DBMSs to get around my handicap.
Galleon's QB64 compiles my Qbasic .bas into execut-
ables which run easily inside 64 bit systems.
Alex Nolan's DBF Viewer Plus looks helpful - I am
exploring it right now.
Zoho reports looks OK - I am just trying it now!
VFP seems to have been given a decent burial. VB
is much too complex. Freeware/Shareware .dbf readers,
editors etc., have very limited features.
MS Access seems to be an overkill .
My solution seems to lie inside a rectangle cornered
by QB64, DBF Viewer Plus, Zoho reports and MS Access.
There must be some better solutions without having
to do lot of coding / recoding.
Any help will be deeply appreciated.
Prof.Dr.K.Loga muthu krishnan, MBBS.,MS(Gen).,FRCS(Edin).,
MCh(Neuro).,PhD(Neuro)., FRSM(London).,
Senior Consultant Neurosurgeon,
CHENNAI - 600 102,
Tamil Nadu State,
India.
E-Mail: logamuthu.krishnan@gmail.com
krishnanlogamuthu@yahoo.com