{{tag>category:"OpenInsight 32-Bit" author:"Loren Henry" author:"Sean FitzSimons"}}

[[https://www.revelation.com/the-works|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: ===
 
 
<QUOTE>
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?
</QUOTE>
----

=== At 05 FEB 2003 08:46AM Sean FitzSimons wrote:  ===

<QUOTE>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



</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=CB75CE3871198B0785256CBF00761D22|View this thread on the Works forum...]]