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.

Updating Datawindow

4 posts in DataWindow Last posting was on 2009-11-30 10:11:56.0Z
Ranjith Posted on 2009-11-30 06:32:04.0Z
From: Ranjith <ranjithpremkumar@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Updating Datawindow
Date: Sun, 29 Nov 2009 22:32:04 -0800 (PST)
Organization: http://groups.google.com
Lines: 46
Message-ID: <8de456c7-ab48-4677-a40f-482d1661a1a0@g1g2000pra.googlegroups.com>
NNTP-Posting-Host: 86.96.161.11
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1259562724 12795 127.0.0.1 (30 Nov 2009 06:32:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 30 Nov 2009 06:32:04 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g1g2000pra.googlegroups.com; posting-host=86.96.161.11; posting-account=R53KSgoAAAAuXOIrb-Y2IAsg9cqvv8jN
User-Agent: G2/1.0
X-HTTP-Via: 1.1 ISA
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeed.news2me.com!nx02.iad01.newshosting.com!newshosting.com!198.186.194.249.MISMATCH!news-out.readnews.com!transit3.readnews.com!postnews.google.com!g1g2000pra.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90367
Article PK: 409972

Dear All,

I am getting an error message while updating a datawindow. I am using
PB 11 build 6525, let me explain the problem what I am facing rite
now.

1. I am updating a 3 datawindows in a row one by one. When I update
the 3rd datawindow I am getting foreign key constraint error which
means the 1st and 2nd datawindow is not updated.

but if I give any message box in between or if I check this in the
debugbreak it is working absolutely fine.

Also one more interesting thing, if I give no of days (we are into the
reservation system) less than 18 it works fine anything goes more than
that it is throwing eror in the normal execution but the same works
fine in the debugbreak or with messageboxes in between.

Please find the below given code....

ll_Ret = dw_head.Update(True,True)
If ll_Ret = -1 Then
MessageBox("Failed Updation ","Failed Mainguest
Updation~r"+sqlca.sqlerrtext)
Rollback;
Return -1
End If

//Update HMDReservationGuest DataStore

ll_Ret = dw_detail.Update(True,True)
If ll_Ret = -1 Then
MessageBox("Failed Updation","Failed Reservationguest Updation")
Rollback;
Return -1
End If

If dw_Rate.Update(True,True) = -1 Then
MessageBox("Failed Updation","Failed Rate
Updation~r"+SQLCA.SQlErrText)
Rollback;
Return -1
End If


Thanks in advance for any help...


Jeremy Lakeman Posted on 2009-11-30 09:16:16.0Z
From: Jeremy Lakeman <jeremy.lakeman@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Updating Datawindow
Date: Mon, 30 Nov 2009 01:16:16 -0800 (PST)
Organization: http://groups.google.com
Lines: 57
Message-ID: <c4ea0c6b-9338-4d2d-9c94-02b63b83ec7b@f20g2000prn.googlegroups.com>
References: <8de456c7-ab48-4677-a40f-482d1661a1a0@g1g2000pra.googlegroups.com>
NNTP-Posting-Host: 219.90.235.209
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1259572576 19244 127.0.0.1 (30 Nov 2009 09:16:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 30 Nov 2009 09:16:16 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f20g2000prn.googlegroups.com; posting-host=219.90.235.209; posting-account=euaBtgoAAAC_vDxfsxmpMKlBxHaHpmRS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!f20g2000prn.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90368
Article PK: 409974


On Nov 30, 4:32 pm, Ranjith <ranjithpremku...@gmail.com> wrote:
> Dear All,
>
> I am getting an error message while updating a datawindow. I am using
> PB 11 build 6525, let me explain the problem what I am facing rite
> now.
>
> 1. I am updating a 3 datawindows in a row one by one. When I update
> the 3rd datawindow I am getting foreign key constraint error which
> means the 1st and 2nd datawindow is not updated.
>
> but if I give any message box in between or if I check this in the
> debugbreak it is working absolutely fine.
>
> Also one more interesting thing, if I give no of days (we are into the
> reservation system) less than 18 it works fine anything goes more than
> that it is throwing eror in the normal execution but the same works
> fine in the debugbreak or with messageboxes in between.
>
> Please find the below given code....
>
> ll_Ret  =       dw_head.Update(True,True)
> If              ll_Ret  =       -1      Then
>         MessageBox("Failed Updation ","Failed Mainguest
> Updation~r"+sqlca.sqlerrtext)
>         Rollback;
>         Return -1
> End If
>
> //Update        HMDReservationGuest DataStore
>
> ll_Ret  =       dw_detail.Update(True,True)
> If ll_Ret       =       -1      Then
>         MessageBox("Failed Updation","Failed Reservationguest Updation")
>         Rollback;
>         Return -1
> End If
>
> If dw_Rate.Update(True,True)    =       -1      Then
>         MessageBox("Failed Updation","Failed Rate
> Updation~r"+SQLCA.SQlErrText)
>         Rollback;
>         Return -1
> End If
>
> Thanks in advance for any help...

How are you setting up the transaction objects on the datawindows?
settrans or settransobject?
Which dbms is this?

I'm guessing each dw is getting it's own separate connection to the
database, and the dbms is caching the changes and processing them in a
different order than you might think.


Ranjith Posted on 2009-11-30 10:02:19.0Z
From: Ranjith <ranjithpremkumar@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Updating Datawindow
Date: Mon, 30 Nov 2009 02:02:19 -0800 (PST)
Organization: http://groups.google.com
Lines: 75
Message-ID: <3145057a-8eba-4196-a843-04688ea0b276@v15g2000prn.googlegroups.com>
References: <8de456c7-ab48-4677-a40f-482d1661a1a0@g1g2000pra.googlegroups.com> <c4ea0c6b-9338-4d2d-9c94-02b63b83ec7b@f20g2000prn.googlegroups.com>
NNTP-Posting-Host: 86.96.161.6
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1259575340 3083 127.0.0.1 (30 Nov 2009 10:02:20 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 30 Nov 2009 10:02:20 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v15g2000prn.googlegroups.com; posting-host=86.96.161.6; posting-account=R53KSgoAAAAuXOIrb-Y2IAsg9cqvv8jN
User-Agent: G2/1.0
X-HTTP-Via: 1.1 ISA
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!v15g2000prn.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90369
Article PK: 409973


On Nov 30, 1:16 pm, Jeremy Lakeman <jeremy.lake...@gmail.com> wrote:
> On Nov 30, 4:32 pm, Ranjith <ranjithpremku...@gmail.com> wrote:
>
>
>
>
>
> > Dear All,
>
> > I am getting an error message while updating a datawindow. I am using
> > PB 11 build 6525, let me explain the problem what I am facing rite
> > now.
>
> > 1. I am updating a 3 datawindows in a row one by one. When I update
> > the 3rd datawindow I am getting foreign key constraint error which
> > means the 1st and 2nd datawindow is not updated.
>
> > but if I give any message box in between or if I check this in the
> > debugbreak it is working absolutely fine.
>
> > Also one more interesting thing, if I give no of days (we are into the
> > reservation system) less than 18 it works fine anything goes more than
> > that it is throwing eror in the normal execution but the same works
> > fine in the debugbreak or with messageboxes in between.
>
> > Please find the below given code....
>
> > ll_Ret  =       dw_head.Update(True,True)
> > If              ll_Ret  =       -1      Then
> >         MessageBox("Failed Updation ","Failed Mainguest
> > Updation~r"+sqlca.sqlerrtext)
> >         Rollback;
> >         Return -1
> > End If
>
> > //Update        HMDReservationGuest DataStore
>
> > ll_Ret  =       dw_detail.Update(True,True)
> > If ll_Ret       =       -1      Then
> >         MessageBox("Failed Updation","Failed Reservationguest Updation")
> >         Rollback;
> >         Return -1
> > End If
>
> > If dw_Rate.Update(True,True)    =       -1      Then
> >         MessageBox("Failed Updation","Failed Rate
> > Updation~r"+SQLCA.SQlErrText)
> >         Rollback;
> >         Return -1
> > End If
>
> > Thanks in advance for any help...
>
> How are you setting up the transaction objects on the datawindows?
> settrans or settransobject?
> Which dbms is this?
>
> I'm guessing each dw is getting it's own separate connection to the
> database, and the dbms is caching the changes and processing them in a
> different order than you might think.- Hide quoted text -
>
> - Show quoted text -

Hello Jeremy,

I am connecting to SQL Server 2005 and using Settransobject(SQLCA) as
a connection method. As per the above code, it is in order only, I was
able to save if I give messages boxes in between. I couldnt catch
anything even if I use debugbreak.

Thanks

Ranjith T


Ranjith Posted on 2009-11-30 10:11:56.0Z
From: Ranjith <ranjithpremkumar@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Updating Datawindow
Date: Mon, 30 Nov 2009 02:11:56 -0800 (PST)
Organization: http://groups.google.com
Lines: 100
Message-ID: <651e13a0-ecc5-42a0-a9a0-87a3cd01992b@z3g2000prd.googlegroups.com>
References: <8de456c7-ab48-4677-a40f-482d1661a1a0@g1g2000pra.googlegroups.com> <c4ea0c6b-9338-4d2d-9c94-02b63b83ec7b@f20g2000prn.googlegroups.com> <3145057a-8eba-4196-a843-04688ea0b276@v15g2000prn.googlegroups.com>
NNTP-Posting-Host: 86.96.161.8
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1259575917 6275 127.0.0.1 (30 Nov 2009 10:11:57 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 30 Nov 2009 10:11:57 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z3g2000prd.googlegroups.com; posting-host=86.96.161.8; posting-account=R53KSgoAAAAuXOIrb-Y2IAsg9cqvv8jN
User-Agent: G2/1.0
X-HTTP-Via: 1.1 ISA
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!z3g2000prd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90370
Article PK: 409975


On Nov 30, 2:02 pm, Ranjith <ranjithpremku...@gmail.com> wrote:
> On Nov 30, 1:16 pm, Jeremy Lakeman <jeremy.lake...@gmail.com> wrote:
>
>
>
>
>
> > On Nov 30, 4:32 pm, Ranjith <ranjithpremku...@gmail.com> wrote:
>
> > > Dear All,
>
> > > I am getting an error message while updating a datawindow. I am using
> > > PB 11 build 6525, let me explain the problem what I am facing rite
> > > now.
>
> > > 1. I am updating a 3 datawindows in a row one by one. When I update
> > > the 3rd datawindow I am getting foreign key constraint error which
> > > means the 1st and 2nd datawindow is not updated.
>
> > > but if I give any message box in between or if I check this in the
> > > debugbreak it is working absolutely fine.
>
> > > Also one more interesting thing, if I give no of days (we are into the
> > > reservation system) less than 18 it works fine anything goes more than
> > > that it is throwing eror in the normal execution but the same works
> > > fine in the debugbreak or with messageboxes in between.
>
> > > Please find the below given code....
>
> > > ll_Ret  =       dw_head.Update(True,True)
> > > If              ll_Ret  =       -1      Then
> > >         MessageBox("Failed Updation ","Failed Mainguest
> > > Updation~r"+sqlca.sqlerrtext)
> > >         Rollback;
> > >         Return -1
> > > End If
>
> > > //Update        HMDReservationGuest DataStore
>
> > > ll_Ret  =       dw_detail.Update(True,True)
> > > If ll_Ret       =       -1      Then
> > >         MessageBox("Failed Updation","Failed Reservationguest Updation")
> > >         Rollback;
> > >         Return -1
> > > End If
>
> > > If dw_Rate.Update(True,True)    =       -1      Then
> > >         MessageBox("Failed Updation","Failed Rate
> > > Updation~r"+SQLCA.SQlErrText)
> > >         Rollback;
> > >         Return -1
> > > End If
>
> > > Thanks in advance for any help...
>
> > How are you setting up the transaction objects on the datawindows?
> > settrans or settransobject?
> > Which dbms is this?
>
> > I'm guessing each dw is getting it's own separate connection to the
> > database, and the dbms is caching the changes and processing them in a
> > different order than you might think.- Hide quoted text -
>
> > - Show quoted text -
>
> Hello Jeremy,
>
> I am connecting to SQL Server 2005 and using Settransobject(SQLCA) as
> a connection method. As per the above code, it is in order only, I was
> able to save if I give messages boxes in between. I couldnt catch
> anything even if I use debugbreak.
>
> Thanks
>
> Ranjith T- Hide quoted text -
>
> - Show quoted text -

Hello Jermy,

I have done following things to check how it is working and I am
attaching the list of results with it.

1. If I enter any no of nights(a column with long declaration in the
backend) less than 18 it is working fine, if anything goes more than
18 i am getting problem.
2. I tried to remove the constratint from the 3rd datawindow table, it
doesnt show any error but both header and detail tables are not
storing.
3. The same table and Datawindow I am able to update without any
problem from other screens.

Thanks & Regards,

Ranjith T