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

View this thread on the Works forum...