Mega Code Archive

 

Categories / Delphi / ADO Database

 

Bde =4 0, intersolve odbc 3 0, tquery cachedupdates, tupdatesql, applyupdates, null-blank string

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."