View Full Version : A DATABASE WHICH IS BASED ON BOTH SQL AND DBASE!
I tend to write Database applications which are based on MS SQL Server . sometimes we need to create a single-user version of the program (for instance we need to deliver limitted [Demo]) versions) . It take us much time to convert the program so that it works with DBASE files. Is it possible to write the program in a way that it can work with both SQL SERVER databses and Dbase/FOXPRO or Paradox tables?
03-20-2001, 01:15 PM
There are several ways to do this. My first thought was to
use MSDE which is a basically slimmed down version of SQL7.
We did that with one of our products to put it on a demo
CD. Worked very well.
But you can also use compiler directives and constants to
perform the naming of fields and tables.
// Can only have 10 char fieldnames in dBase.
Then Build your TTable or TQuery components at run-time
and use them according to your compiler directive. You
can set your compiler directive in the Conditional Defines
section on the Directories/Conditionals tab of the Project
03-20-2001, 02:41 PM
I concur with MrBaseball.. I come from a long line of Clipper/C development and I have found that MSDE is a wonderful product that gives you an excellent, robust database for 5 or fewer users. dBase and Paradox based data should go away...they just cannot provide the data security that is available with the newer database formats. The great thing about MSDE is that, like MrBaseball said, it is a slimmed down version of SQL server, so if you want to move to more users, there is little or no work involved to make the transition.
vBulletin® v3.8.7, Copyright ©2000-2013, vBulletin Solutions, Inc.