Native vs ODBC SQL connection (OpenInsight 32-Bit)
At 31 JAN 2003 04:30:07PM Loren Henry wrote:
We have an application that runs fine when we use a ODBC SQL connection. When we use the same popup to fill in a screen using a native SQL connection, we get the following message: "A non-null dataset column can not be bound to a nullable result set column." Any clues?
At 05 FEB 2003 08:46AM Sean FitzSimons wrote:
Loren,
Try having the Native SQL think that the fields you are requesting are calculated fields, so that the SQL will not try and update the fields.
For example, instead of:
SELECT key FROM table try
tryu
SELECT key + "" from table.
Sean