Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Datawindow Insert Bug!!!!!

2 posts in DataWindow .NET Last posting was on 2004-11-23 00:10:46.0Z
lfenceroy Posted on 2004-11-22 21:36:44.0Z
Sender: 2608.41a25b31.846930886@sybase.com
From: lfenceroy
Newsgroups: sybase.public.datawindow.net
Subject: Datawindow Insert Bug!!!!!
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41a25bec.2627.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Nov 2004 13:36:44 -0800
X-Trace: forums-1-dub 1101159404 10.22.241.41 (22 Nov 2004 13:36:44 -0800)
X-Original-Trace: 22 Nov 2004 13:36:44 -0800, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:782
Article PK: 125209

I am using PB 6.5 and trying to insert new rows using the
datawindow. I am receiving 'Cannot contain NULL' on insert.
The problem is one column, which is the key is being dropped
from the 'INSERT' statement. This is weird. I can see the
values from the script that does a setitem to that column,
so the data is there; but when the Update() gets called, the
'INSERT' statement no longers has that one column.

Any thoughts......


dfish Posted on 2004-11-23 00:10:46.0Z
From: dfish@_no_spam_sybase.com (Dave Fish [Team Sybase])
Newsgroups: sybase.public.datawindow.net
Subject: Re: Datawindow Insert Bug!!!!!
Organization: Sybase Professional Services
Reply-To: nospam_dfish@sybase.com_nospam
Message-ID: <41a27f69.252479346@forums.sybase.com>
References: <41a25bec.2627.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vpn-dub-091.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-091.sybase.com
Date: 22 Nov 2004 16:10:46 -0800
X-Trace: forums-1-dub 1101168646 10.22.120.91 (22 Nov 2004 16:10:46 -0800)
X-Original-Trace: 22 Nov 2004 16:10:46 -0800, vpn-dub-091.sybase.com
Lines: 27
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:785
Article PK: 125213

Please post this question in the PowerBuilder.DataWindow newsgroup.
This group is for DataWindow .NET questions and issues.

(But check to see that the column is selected in the DataWindow
painter when you do a Rows\Update Properties menu option selection.)

Regards,
Dave Fish
Sybase

TeamSybase blogs: http://www.teamsybase.net/blogs

DataWindow.NET code examples available on CodeXchange:
http://datawindownet.codexchange.sybase.com

On 22 Nov 2004 13:36:44 -0800, lfenceroy wrote:

>I am using PB 6.5 and trying to insert new rows using the
>datawindow. I am receiving 'Cannot contain NULL' on insert.
>The problem is one column, which is the key is being dropped
>from the 'INSERT' statement. This is weird. I can see the
>values from the script that does a setitem to that column,
>so the data is there; but when the Update() gets called, the
>'INSERT' statement no longers has that one column.
>
>Any thoughts......