Delphi32.com -- FAQ - BDE >=4.0, Intersolve ODBC 3.0, TQuery CachedUpdates, TUpdateSql, ApplyUpdates, null/blank string

BDE >=4.0, Intersolve ODBC 3.0, TQuery CachedUpdates, TUpdateSql, ApplyUpdates, null/blank string

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?

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 048576

Currently under investigation.

From /IVODBC/READ.ME (Intersolv 3.0 ODBC readme): "WorkArounds= 048576. Some applications incorrectly specify a precision of 0 for character types when the value will be SQL_NULL_DAT This option overrides the specified precision and sets the precision to 256."

3/26/99

<< Previous Faq

Complete List

Next Faq >>