Recent

Author Topic: TDBF wih decimal places...  (Read 5377 times)

lublinkermi

  • New Member
  • *
  • Posts: 46
TDBF wih decimal places...
« on: November 22, 2010, 06:45:10 pm »
I saw many examples to create dbf files like :
<code>
MyDbf.FilePathFull := '/location/to/my/data';
MyDbf.TableLevel := 7;
MyDbf.TableName := 'customers.dbf'; // note: is the .dbf really required?
With MyDbf.FieldDefs do begin
  Add('Id', ftAutoInc, 0, True);
  Add('Name', ftString, 80, True);
End;
</code>

How I can generate numeric fields with 3 decimal places clipper compatible databases (level 3) ?





igorz

  • Newbie
  • Posts: 1
Re: TDBF wih decimal places...
« Reply #1 on: November 28, 2010, 11:56:46 am »
I saw many examples to create dbf files like :
<code>
MyDbf.TableName := 'customers.dbf'; // note: is the .dbf really required?
</code>
I think '.dbf' is not required.

How I can generate numeric fields with 3 decimal places clipper compatible databases (level 3) ?
From my code:
<code>
    Dbf.TableLevel := 3;
    Dbf.FieldDefs.Add('PLATSUMM',ftBCD,9,false);   // 9 digits
    with Dbf.FieldDefs do Items[Count-1].Precision := 2; // 2 digits
</code>

---
Igor

lublinkermi

  • New Member
  • *
  • Posts: 46
Re: TDBF wih decimal places...
« Reply #2 on: December 15, 2010, 09:06:36 am »
It's works!
Thank You very much!

 

TinyPortal © 2005-2018