Главная страница | назад





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

 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