Larry, Thank you for the suggestion. I gave it a try, but results are the same. The table will attach, listing all fields except the ones I need! (Numeric,19,0) The sad part is, these fields have no reason to be such a high precisoin number!
I even tried to set the ALIAS columns to "numeric,19,0". Rbase actually allowed me to set the fields as such! Rbase did report an error, (value must be between 1 and 15) but the 19,0 values did "keep" and even showed 19,0 in the LIST TAB command. However, the SATTACH still reported an unsupported datatype. R>list test Table: TEST No Lock(s) Descr: TEST TABLE No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 AORDUNIQ Type : NUMERIC (19, 0) 2 DISCBASE Type : DOUBLE 3 DISCAMT Type : DOUBLE 4 DUEBASE Type : DOUBLE 5 aDUEAMT Type : DOUBLE Current number of rows: 1 Unless I can get this to work, it looks like we may have several thousand manual entries to make, so any more ideas is greatly appreciated! Thanks again! -Bob > > Any other ideas on a solution for the datatype issue > > I am having? > > You might try that aliasing technique, coercing the > NUMERIC 19 fields to TEXT. Sometimes databases use > straight text storage for those very high precision > numbers (and efficiency be damned!). > -- > Larry >
