If you can't Warehouse them Join them (OpenInsight Specific)
At 30 APR 1999 11:57:42AM Dave Smith wrote:
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
At 30 APR 1999 03:55PM Cameron Revelation wrote:
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 this and that other post.
Cameron Purdy
Revelation Software
At 30 APR 1999 06:01PM Dave Smith wrote:
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?
At 30 APR 1999 06:22PM Cameron Revelation wrote:
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