>I'm inserting records into an Oracle database via a straight ODBC connection. The problem is that when the records are inserted, the decimal is truncated from my numerical values. Can anyone give me an idea why this is happening and how to fix it. Thanks in advance.
>
>MEH
Can you give us an idea what your SQL looks like? Also, are you using the Oracle ODBC driver or Microsoft's? IF MS, try using the Oracle driver. An example SQL should look like:
SET field1 = ?cTextValue, field2 = ?nNumericValue, ...
declare PRIVATE variables for cTextValue, nNumericValue, etc. You can RTRIM() the text values first so your varchar2 data types will be useful to you later on.
Mark McCasland
Midlothian, TX USA