, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

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

View this thread on the Works forum...