| View previous topic :: View next topic |
| Author |
Message |
Johan
Guest
|
 Posted: Mon May 24, 2004 10:37 am Post subject: How to create floating field with a given decimal places? |
 |
|
Hello,
I create a table and add fields with the following codes:
With tblMyTable do
begin
Active:= false;
TableType:= ttDBase;
TableName := 'MyTable';
With FieldDefs do
begin
Clear;
With AddFieldDef do
begin
Name := 'EXPT';
DataType := ftFloat;
end;
...
end; //with FieldDefs
CreateTable;
active:=true;
end;//with tblGenFish
When I open the table in Excel, I always have 4 decimal places and large
collums for the floating fields with redundant spaces. I would like to have
2 decimal places and tight collums. I would be grateful if anyone could show
me how to do so.
Regards,
An
|
|
| Back to top |
|
 |
Bojidar Alexandrov
Guest
|
| Posted: Mon May 24, 2004 11:46 am Post subject: Re: How to create floating field with a given decimal places |
|
|
see numeric data type
|
|
| Back to top |
|
|
Johan
Guest
|
| Posted: Mon May 24, 2004 7:40 pm Post subject: Re: How to create floating field with a given decimal places |
|
|
"Bojidar Alexandrov" <bojo (AT) kodar (DOT) net> wrote
| Quote: | see numeric data type
|
Could you tell me more in details? Thank you
|
|
| Back to top |
|
|
Hubert Anemaat
Guest
|
| Posted: Tue May 25, 2004 10:03 pm Post subject: Re: How to create floating field with a given decimal places |
|
|
Hello Johan,
Look at ftBCD.
Hubert Anemaat
"Johan" <ececpig (AT) yahoo (DOT) com> schreef in bericht
news:40b1d047$1 (AT) newsgroups (DOT) borland.com...
| Quote: | Hello,
I create a table and add fields with the following codes:
With tblMyTable do
begin
Active:= false;
TableType:= ttDBase;
TableName := 'MyTable';
With FieldDefs do
begin
Clear;
With AddFieldDef do
begin
Name := 'EXPT';
DataType := ftFloat;
end;
...
end; //with FieldDefs
CreateTable;
active:=true;
end;//with tblGenFish
When I open the table in Excel, I always have 4 decimal places and large
collums for the floating fields with redundant spaces. I would like to
have
2 decimal places and tight collums. I would be grateful if anyone could
show
me how to do so.
Regards,
An
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
