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.

How to find all DW's, which are not updateable

2 posts in DataWindow Last posting was on 2008-05-16 09:57:01.0Z
Andreas Holz Posted on 2008-05-16 09:08:10.0Z
From: Andreas Holz <aswood@t-online.de>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: How to find all DW's, which are not updateable
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <482d4efa@forums-1-dub>
Date: 16 May 2008 02:08:10 -0700
X-Trace: forums-1-dub 1210928890 10.22.241.152 (16 May 2008 02:08:10 -0700)
X-Original-Trace: 16 May 2008 02:08:10 -0700, vip152.sybase.com
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86869
Article PK: 416127

Since we have approx. 2000 DW's and a developer might forget to update
the DW's update properties after modifying it's data source is there a
way to find all DW's, which "Allow Update" property is NOT set.

Andreas


fisher Posted on 2008-05-16 09:57:01.0Z
From: "fisher" <fisherNOatwckp.SPAM.lodz.PLEASE.pl>
Newsgroups: sybase.public.powerbuilder.datawindow
Organization: 193.121.160.68
References: <482d4efa@forums-1-dub>
X-Newsreader: AspNNTP 1.50 (JodoHost)
Subject: Re: How to find all DW's, which are not updateable
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <482d5a6d$1@forums-1-dub>
Date: 16 May 2008 02:57:01 -0700
X-Trace: forums-1-dub 1210931821 10.22.241.152 (16 May 2008 02:57:01 -0700)
X-Original-Trace: 16 May 2008 02:57:01 -0700, vip152.sybase.com
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86870
Article PK: 416128

Have you looked at any of :
DataWindow.Table.UpdateWhere
DataWindow.Table.UpdateTable
DataWindow.Table.Update.Type
DataWindow.Table.Update.Method
DataWindow.Table.Update.Arguments??

You can go through all your dw and check it's properties.
Use GetLibraryList to get list of libraries (or use your own static list) then
LibraryDirectory to get list of DW

Regards
On 16 May 2008 02:08:10 -0700,
in sybase.public.powerbuilder.datawindow

Andreas Holz <aswood@t-online.de> wrote:
>Since we have approx. 2000 DW's and a developer might forget to update
>the DW's update properties after modifying it's data source is there a
>way to find all DW's, which "Allow Update" property is NOT set.
>
>Andreas