Exporting a table problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CD Tom - 09 Mar 2007 22:56 GMT

I have a table that has columns setup with 3 decimals, however when I export
the file to a .txt it is only exporting out two decimals and I'm losing the
3rd decimal which is really causing a problem. Does anybody know what is
causing this and how I can fix it.
Thanks for any help.

CD

Reply to this Message

Seth Schwarm - 10 Mar 2007 06:12 GMT

CD Tom:

I suspect the values stored in the table are only to two decimal accuracy -
meaning the third decimal place is actually a zero (Ex. - .120).

You can fix this by building a query on the table instead of using the table
itself.

Seth Schwarm

> I have a table that has columns setup with 3 decimals, however when I export
> the file to a .txt it is only exporting out two decimals and I'm losing the
[quoted text clipped - 3 lines]
>
> CD

Reply to this Message

CD Tom - 10 Mar 2007 17:10 GMT

When I do the export manually, I can see the data and it shows 3 decimals ex
23.123 but when I look at the .txt file that it exports it only shows 23.12
The table def. is set to three decimal points. It really doesn't make any
sense to me. This is very important to have all 3 decimals show up in the
.txt file because I use them to restore to other databases and I'm losing
that 3rd decimal. Hopefully it's something simple that I'm just missing.

> CD Tom:
>
[quoted text clipped - 13 lines]
> >
> > CD

Reply to this Message