Decimal precision change - MySQL & MS-Access
- From: "MomentisMan" <rstoffiere@xxxxxxxxxxxxxxxx>
- Date: 15 Jan 2007 10:25:11 -0800
I have an app with a MySQL backend and MS-Access frontend. I have a
table on the database (tblTime) with three Decimal columns. When I
connect to the table through ODBC in Access, the precision comes
through correct (13,2). I created a view of a subset of the data from
the tblTime table. However, when I connect to this view through
Access, the precision of the decimal columns keeps setting to (14,0),
which results in a data truncation error. Does anyone have an idea how
to correct this?
.
- Prev by Date: RE: Multiple Backend MDBs
- Next by Date: Re: Cross-ref IDs and de-dupe
- Previous by thread: RE: Multiple Backend MDBs
- Next by thread: Re: Cross-ref IDs and de-dupe
- Index(es):
Relevant Pages
|
