aldo
2011-08-11 01:29:44 UTC
Hi Guys,
Have connected to a gdb database and some of the currency fields have
been set to "DOUBLE PRECISION". When table is opened in Access, certain
records have #ERROR# on all fields. I have put it down to a number with
decimal places being entered into a DOUBLE PECISON field. I then receive
a "Scaling of decimal value resulted in data truncation"
Regards,
Aldo Radocchia
(02) 8863 6647
(02) 8863 6688
0412 05 05 25
***@apcd.com.au <mailto:***@apcd.com.au>
www.apcd.com.au <http://www.apcd.com.au>
16 Harbord St, Granville, 2142 NSW
PRIVATE & CONFIDENTIAL
This email and any attachments may contain confidential information,
and/or material, the copyright over which belongs to APCD PTY LTD. If
you are not the intended recipient, any use, disclosure or copying of
this email is unauthorised. If you have received this email in error,
please notify us immediately by reply email and delete the original. We
advise that this email and any attached files should be scanned to
detect viruses, and while all care is taken, we accept no liability for
loss or damage (whether caused by negligence or not) resulting from the
use of any attached files. If any problems occur in formatting or data
loss in the transfer of data which affect the accuracy of the
information contained in the email, hard copies will be provided at
request.
SAVE PAPER - THINK BEFORE YOU PRINT P
Have connected to a gdb database and some of the currency fields have
been set to "DOUBLE PRECISION". When table is opened in Access, certain
records have #ERROR# on all fields. I have put it down to a number with
decimal places being entered into a DOUBLE PECISON field. I then receive
a "Scaling of decimal value resulted in data truncation"
Regards,
Aldo Radocchia
(02) 8863 6647
(02) 8863 6688
0412 05 05 25
***@apcd.com.au <mailto:***@apcd.com.au>
www.apcd.com.au <http://www.apcd.com.au>
16 Harbord St, Granville, 2142 NSW
PRIVATE & CONFIDENTIAL
This email and any attachments may contain confidential information,
and/or material, the copyright over which belongs to APCD PTY LTD. If
you are not the intended recipient, any use, disclosure or copying of
this email is unauthorised. If you have received this email in error,
please notify us immediately by reply email and delete the original. We
advise that this email and any attached files should be scanned to
detect viruses, and while all care is taken, we accept no liability for
loss or damage (whether caused by negligence or not) resulting from the
use of any attached files. If any problems occur in formatting or data
loss in the transfer of data which affect the accuracy of the
information contained in the email, hard copies will be provided at
request.
SAVE PAPER - THINK BEFORE YOU PRINT P