Question and Answer Database FAQ3786B.txt BDE>=4.0, Intersolve ODBC 3.0, TQuery CachedUpdates, TUpdateSql, ApplyUpdates, null/blank string Category :Database (ODBC) Platform :Win95/NT Product : All32Bit Question: When working with BDE 4.0, Intersolve ODBC 3.0, Delphi TQuery CachedUpdates, TUpdateSql I receive the error "General SQL error. [INTERSOLV][ODBC Oracle driver]Character, decimal, and binary parameters cannot have a precision of zero. Error in parameter n." What might be causing this error? Answer: The problem does not occur when using CachedUpdates w/TTables "General SQL error. [INTERSOLV][ODBC Oracle driver]Character, decimal, and binary parameters cannot have a precision of zero. Error in parameter n." Add a new string value called "Workarounds" to: \HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\MYODBCDSN and set its value to 1048576 Currently under investigation. From /IVODBC/READ.ME (Intersolv 3.0 ODBC readme): "WorkArounds=1048576. Some applications incorrectly specify a precision of 0 for character types when the value will be SQL_NULL_DATA. This option overrides the specified precision and sets the precision to 256." 3/26/99
Last Modified: 01-SEP-99