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.

Problem trying to Modify Datawindow.Table.Arguments

2 posts in DataWindow .NET Last posting was on 2004-09-22 15:51:58.0Z
Jon D Posted on 2004-09-22 10:53:46.0Z
Sender: 190b.4151462d.1804289383@sybase.com
From: Jon D
Newsgroups: sybase.public.datawindow.net
Subject: Problem trying to Modify Datawindow.Table.Arguments
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <415159ba.1a25.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Sep 2004 03:53:46 -0700
X-Trace: forums-1-dub 1095850426 10.22.241.41 (22 Sep 2004 03:53:46 -0700)
X-Original-Trace: 22 Sep 2004 03:53:46 -0700, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:421
Article PK: 124851

Hi,
We are using a stored procedure as the source for our
datawindow. This SP has multiple optional parameters. I’m
trying to dynamically modify Datawindow.Table.Procedure and
Datawindow.Table.Arguments. I’ve succeeded in modifying
the procedure but it keep failing when trying to modify the
arguments. The code I’m using is :

myString = "DataWindow.Table.Procedure = ""1 execute
dbo.usp_Calcs;1 @BatchNo = :BatchNo"""
dwcTest.Modify(myString)

myString = "DataWindow.Table.Arguments=((""BatchNo"",
string))"
dwcTest.Modify(myString)

Any help would be gratefully received

Thanks

Jon


Jon D Posted on 2004-09-22 15:51:58.0Z
Sender: 4e5f.415188a6.1804289383@sybase.com
From: Jon D
Newsgroups: sybase.public.datawindow.net
Subject: Re: Problem trying to Modify Datawindow.Table.Arguments
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4151a171.5064.1681692777@sybase.com>
References: <415159ba.1a25.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 22 Sep 2004 08:59:45 -0700, 10.22.241.42
Lines: 27
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Sep 2004 08:39:10 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Sep 2004 08:51:58 -0700
X-Trace: forums-1-dub 1095868318 10.22.108.75 (22 Sep 2004 08:51:58 -0700)
X-Original-Trace: 22 Sep 2004 08:51:58 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:424
Article PK: 124856

It looks as if the arguments are read only, so I may not be
able to do this.

Jon

> Hi,
> We are using a stored procedure as the source for our
> datawindow. This SP has multiple optional parameters.
I’m
> trying to dynamically modify Datawindow.Table.Procedure
> and Datawindow.Table.Arguments. I’ve succeeded in
> modifying the procedure but it keep failing when trying to
> modify the arguments. The code I’m using is :
>
> myString = "DataWindow.Table.Procedure = ""1 execute
> dbo.usp_Calcs;1 @BatchNo = :BatchNo"""
> dwcTest.Modify(myString)
>
> myString = "DataWindow.Table.Arguments=((""BatchNo"",
> string))"
> dwcTest.Modify(myString)
>
> Any help would be gratefully received
>
> Thanks
>
> Jon