[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== If you can't Warehouse them Join them (OpenInsight Specific) ====
=== At 30 APR 1999 11:57:42AM Dave Smith wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I am trying to warehouse a simple table (following the guidelines set

in the OpenInsight 3.7 Microsoft SQL 7.0 Knowledge base article).

I have no problems warehousing the data if I chose to drop/create the

table. If I choose to not drop or clear the table (what I need to be able to do) it will not work,(error messages in error log "Error processing "record number") I have searched other postings and followed the suggestions therein. 

The line that creates the problem in the warehouse program is:

 Ret=DSMethod(Handle[i], DS_EXECUTE$)



I used Cameron's suggestion to capture the error:

  DSMethod(Handle[i], DS_GETERROR$, "","","","",Text)

   Send_Info("WP Error: ":TEXT)



And the error I get is:

 A non-null DataSet column can not be bound to a nullable result   set column



The question I have is, what is the command( Ret=DSMethod(Handle[i], DS_EXECUTE$) doing? is it trying to use the data set to do

a select on the SQL table? 

Any help/suggestions would be appreciated.

TIA.

Davesmith@idcomm.com


</QUOTE>
----

=== At 30 APR 1999 03:55PM Cameron Revelation wrote:  ===

<QUOTE>Hi Dave,



Yes, it is doing a select based on the options you gave it (not to clear the tables).  I notice you asked previously about updates-only warehousing.  That is what is occurring here.  Please see also [url=http://www.revelation.com/THEWORKS/OIdiscuss.nsf/4539f515a2139aa98525652c004759c0/7e1f50aa18c76500852566f0004622c2?OpenDocument]this[/url] and [url=http://www.revelation.com/WEBSITE/DISCUSS.NSF/09d90959a1a106db8525652c0042cb86/417f51abb7b648c385256729006878fa?OpenDocument]that[/url] other post.



Cameron Purdy

Revelation Software

</QUOTE>

----

=== At 30 APR 1999 06:01PM Dave Smith wrote:  ===

<QUOTE>Cameron, I am still confused, are you saying the program needs to be modified? Or ar the Select and Insert scripts wrong? I have tested 

the scripts in SQL Server, and they seem to work. Any suggestions?

</QUOTE>

----

=== At 30 APR 1999 06:22PM Cameron Revelation wrote:  ===

<QUOTE>Hi Dave,



Oh, you want an answer ;-)



One of the columns in the DataSet is marked as not null, but it is null when the SQL Server returns it.  That could be a 32-bit ODBC thunking problem (if you are using a 32-bit ODBC driver from OI) or it could be null data in your database.



If the former ... see if you can use a direct connection object (SQL Server for example).  If the latter, just change the DataSet definition (Client/Server Workspace, Open, DataSet, WP_...) to allow nulls ... probably its a key column.



Cameron Purdy

Revelation Software

</QUOTE>


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