Displayed field width in DBF file

Article View: borland.public.delphi.database.bdp

Article #232

Back to borland.public.delphi.database.bdp Previous Next

#232

From: Tran Duy An
Date: Tue, 15 May 2007 12:46

20 lines
1488 bytes

Hello,

In my program, I created a dBase table from code with a lot of fields of
different field types (ftInteger, ftFloat). When I opened this table in
Excel, the width of the fields were too wide and I had to adjust them so
many times to fix them into the window. I tried to reduced the width by
using precision property as follows, but it did not work:

with FieldDefs.AddFieldDef do
begin
        Name := 'TIME';
        DataType := ftFloat;
        Precision:= 4;
end;

I would be grateful if you could show me how to reduce the displayed field
width.

Regards,
Cocu

Technical Details

Message-ID: <4649abb9$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effeb,f067c39b45277818,start
X-Google-Attributes: gid1effeb,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Tran Duy An" <duyan1972@yahoo.com>
From: "Tran Duy An" <duyan1972@yahoo.com>
Newsgroups: borland.public.delphi.database.bdp
Subject: Displayed field width in DBF file
Date: Tue, 15 May 2007 14:46:49 +0200
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 194.171.38.2
Message-ID: <4649abb9$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1179233209 194.171.38.2 (15 May 2007 05:46:49 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail