{{tag>category:"None Specified" author:"Dave Smith"}}

[[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]]


==== I need Data Warehousing help (None Specified) ====
=== At 30 APR 1999 03:45:32PM Dave Smith wrote: ===
 
 
<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>

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