<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16809" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>I had problems with the source data being changed when
I used a lookup. I created a manual lookup table and found the same
problem. Looks like the record pointers got mixed up when using 2 tables. I
fixed the source file over 20 times but I could not duplicate the key
strokes that created the problem. (Delphi 4) </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I posted a problem with creating dBase3 files a few
days ago and the end result is that field names are not created correctly. (I
used Dbase as I had 15 year of programming experience with them and Excel can
read them directly) </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV>
<DIV><SPAN class=rvts8><FONT face=Arial size=2>Delphi appears to create and
integer type field instead of real numbers when using the
following:</FONT></SPAN></DIV>
<DIV><SPAN class=rvts8><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=rvts8><FONT face=Arial
size=2> if
dm.tblOper.Fields[i].Datatype=ftFloat
then<BR>
Add(trim(copy(dm.tblOper.Fields[i].Name,8,10)), ftFloat, 0,
False);</FONT></SPAN></DIV>
<DIV><SPAN class=rvts8><FONT face=Arial size=2>or </FONT></SPAN></DIV>
<DIV><SPAN class=rvts8><FONT face=Arial
size=2>
FieldDefs.Assign(dm.tblOper.FieldDefs);</FONT></SPAN></DIV>
<DIV><SPAN class=rvts8><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=rvts8><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=rvts8><FONT size=2>I have just downloaded Absolute database and
so far things have worked correctly. </FONT></SPAN></DIV>
<DIV><SPAN class=rvts8><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=rvts8><FONT
size=2>Wallace</FONT></SPAN></DIV></DIV></BODY></HTML>