🚀 go-pugleaf

Hi;
     
        I'm using a *.DBF file to start with.  I am writing a program
that creates two output database files for every date that the users
enter when running the program. In other words - A user will open the
program and have to enter a date on the screen before they can do any
data entry or run any reports.  When the users enters a date into the
program I use the date to create the name of the two database files.  If
they do exists I will just activate the database files for user access.
If they do not exist I will create them and then activate the database
files for user access.
	I'm currently using the DOS 'system' command to copy a blank database
and assigning it the right new name.  Then I make the 'Ttable Active'
property "false", renaming the 'TableName' property of the 'TTable', and
finally I make the 'Ttable Active' property "true". Here is an example.

String date, NewFileNameI, NewFileNameII;
date = DateFromTheUser->Text;
Convert(date, NewFileNameI, NewFileNameII);
system("copy C:\\BlankFileI.dbf  C:\\NewFileNameI.dbf");
system("copy C:\\BlankFileII.dbf  C:\\NewFileNameII.dbf");
ATable->Active = false;
ATable->TableName = "NewFileNameI.dbf";
ATable->Active = true;
BTable->Active = false;
BTable->TableName = "NewFileNameII.dbf";
BTable->Active = true;

	I am able to open the new databases.  When I go to write records to
these new files I receive errors letting me know that builder can not
find certain fields within the database. It can find most of the fields
but not all of them.  If I look at the new databases through other
software I can see all the fields are there. 
	I'm happy to fix this problem working with my current code or I'm just
as happy to trash it all for another solution that will work.  For
anyone who could put me on a track that would lead to another answer I
thank you now!!!

                          Brian
------------------------------------------------------------------------