<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span style='font-size:14.0pt'>I’m using BDS2006 with dBase
for an order entry program that is based on Accounting for Delphi ( I have made
a large number of changes to the original AFD program). Several months ago I
created a new program that uses the same BDE alias as the “original”
order entry program. This was because the company owner wanted to be able to
track open orders whether those orders were from the “original”
order program or from the new order program that was written to accommodate a
new customer who had a whole new set of business rules in order to manufacture
the items for that customer.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:14.0pt'>Because of the way that MS OS
handles multiusers the performance takes a huge hit when the second user logs
into either of the two programs. So much so that the employee who runs the
second program comes into work a hour early so that she can print the working
documents needed by the plant to manufacture the order items. Since time is of
the essence this isn’t acceptable as this delays by a day or more when
the plant actually gets the work orders.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:14.0pt'>So my first question. If I create
a new BDE alias for the dBase files that the second program uses will I have to
“recreate” the persistent fields in the TTable components? The
TTables are on the individual forms as opposed to being on a data module. Oh I
plan on putting the files that the second program uses into a new folder. The
files that were used in common with the original program will be copied to that
folder as well and ultimately will be purged of all records except those that
pertain to the new program (new customer).<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:14.0pt'>The second question is what
challenges will I have when I create a procedure (or another small program) to
query both of the order files from each of the two programs so that I can have
a report that shows which orders are still open. I haven’t worked with
data that is “in” two different BDE alias before.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:14.0pt'>Hope the above makes sense.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:14.0pt'>Thank you for your help.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:14.0pt'>Charlie<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:14.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><b><span style='font-size:14.0pt;font-family:Consolas;
color:#365F91'>Williamson GA<o:p></o:p></span></b></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>