Datawindow UPDATE #5

I am using PB12.1 & MS SQL Server 2008 R2 Express
I have datawindow has 4 tables I alreay check for allow
Update and Table to update is EmpSchedule and select the
fields to be Updated but when I issue dw.Update() it gives
me error that
datawindows does not have UPDATE capability
but I have already make as Updatable datawindow
Note: In the script I use SETSQLSELECT() function

Finestraco
0
Finestraco
1/12/2011 4:59:23 PM
sybase.powerbuilder.general 62418 articles. 11 followers. Follow

3 Replies
742 Views

Similar Articles

[PageSpeed] 45

Hi Finestraco;

1)   Does the table you are trying to update have defined either: a) a 
primary key or b) a unique index?
2)  What are you doing in the SetSQLSelect ( ) command?

Regards ... Chris
President: OSUG / STD Inc.
Blog: http://chrispollach.blogspot.com
PBDJ: http://chrispollach.sys-con.com
SourceForge: http://sourceforge.net/projects/stdfndclass

"Finestraco" wrote in message news:4d2dddeb.4ff2.1681692777@sybase.com...

I am using PB12.1 & MS SQL Server 2008 R2 Express
I have datawindow has 4 tables I alreay check for allow
Update and Table to update is EmpSchedule and select the
fields to be Updated but when I issue dw.Update() it gives
me error that
datawindows does not have UPDATE capability
but I have already make as Updatable datawindow
Note: In the script I use SETSQLSELECT() function

Finestraco 

0
Chris
1/12/2011 5:08:18 PM
This is documented clearly in the Help file for the SetSQLSelect() function.

If the new SELECT statement has a different table name in the FROM clause 
and the DataWindow object is updatable, then PowerBuilder must change the 
update information for the DataWindow object. PowerBuilder assumes the key 
columns are in the same positions as in the original definition. The 
following conditions would make the DataWindow not updatable:

  a.. There is more than one table in the FROM clause

  b.. A DataWindow update column is a computed column in the SELECT 
statement


If changing the SELECT statement makes the DataWindow object not updatable, 
the DataWindow control cannot execute an Update method call for the 
DataWindow object in the future.

You can use the Modify() statement to make the datawindow updateable again, 
though.

dw_1.Modify( "DataWindow.Table.UpdateTable = ~"EmpSchedule~"")


Paul Horan[Sybase]
http://paulhoran.ulitzer.com

<Finestraco> wrote in message news:4d2dddeb.4ff2.1681692777@sybase.com...
>I am using PB12.1 & MS SQL Server 2008 R2 Express
> I have datawindow has 4 tables I alreay check for allow
> Update and Table to update is EmpSchedule and select the
> fields to be Updated but when I issue dw.Update() it gives
> me error that
> datawindows does not have UPDATE capability
> but I have already make as Updatable datawindow
> Note: In the script I use SETSQLSELECT() function
>
> Finestraco 


0
Paul
1/12/2011 5:17:59 PM
I use SetSQLSelect() to change Where Clause only not FROM
Tables
I aleardy use dw_1.modify to change updatetable and it works
now

Thanks for reply
Finestraco


> This is documented clearly in the Help file for the
> SetSQLSelect() function.
>
> If the new SELECT statement has a different table name in
> the FROM clause  and the DataWindow object is updatable,
> then PowerBuilder must change the  update information for
> the DataWindow object. PowerBuilder assumes the key
> columns are in the same positions as in the original
> definition. The  following conditions would make the
> DataWindow not updatable:
>
>   a.. There is more than one table in the FROM clause
>
>   b.. A DataWindow update column is a computed column in
> the SELECT  statement
>
>
> If changing the SELECT statement makes the DataWindow
> object not updatable,  the DataWindow control cannot
> execute an Update method call for the  DataWindow object
> in the future.
>
> You can use the Modify() statement to make the datawindow
> updateable again,  though.
>
> dw_1.Modify( "DataWindow.Table.UpdateTable =
> ~"EmpSchedule~"")
>
>
> Paul Horan[Sybase]
> http://paulhoran.ulitzer.com
>
> <Finestraco> wrote in message
> news:4d2dddeb.4ff2.1681692777@sybase.com... >I am using
> > PB12.1 & MS SQL Server 2008 R2 Express I have datawindow
> > has 4 tables I alreay check for allow Update and Table
> > to update is EmpSchedule and select the fields to be
> > Updated but when I issue dw.Update() it gives me error
> > that datawindows does not have UPDATE capability
> > but I have already make as Updatable datawindow
> > Note: In the script I use SETSQLSELECT() function
> >
> > Finestraco
>
>
0
Finestraco
1/13/2011 5:46:18 AM
Reply:

Similar Artilces:

update powerbuilder 10.0 to powerbuilder 10.5
hi, I need update powerbuilder ver 10.0 to powerbuilder 10.5. by the way, my company already buy pb ver 10.00 and need to update to ver 10.5. the question : if update pb from ver 10.00 to ver 10.5, is it free of charge ? if no, How I found the price ? best regards, alim 10.5 is considered a major release, you would need to purchase an upgrade. This is what I found on Sybase's own eshop: http://eshop.sybase.com/eshop/buy_detail?id=92023&prodId=9281&bid=17856 You may find better through an online merchant, partner or local retailer. This is also the Ent...

Datawindow Plugin for PowerBuilder 6.5 in IE5.5 SP2?
We have been using datawindow plugin Npdwe60.dll for a long time now and it worked just fine in both IE and NS. However, starting from IE5.5 SP2, Microsoft decided NOT to support plugins any more. Is there any news on how to overcome this problem? ActiveX version of plugin? Any other solution? Thanks in advance for any response. Leonid Borisov Tefensoft Where did you find out that MS doesn't support plugins anymore? -- Terry Dykstra (TeamSybase) Please state PB / OS / DB versions in your post. MySybase http://my.sybase.com/mysybase Search Deja: http://www.pfcguide...

Datawindow update #5
Hi friends, I have got one datawindow with more than one table,with outer join. I want to update only one table of these.But when i give update. It is giving me Error - rows cahnged between retrieve and update. I need some help please... Thank you Kiran padiyar@usa.net Ambassador's Sky Chef wrote: > Hi friends, > I have got one datawindow with more than one table,with outer join. > I want to update only one table of these.But when i give update. It is > giving me Error - rows cahnged between retrieve and update. > I need some help please... > ...

PowerBuilder 5 Update
I have PowerBuilder 5.0, Desktop (full version). How do I install PowerBuilder 5.0. Professional Update w/o Powerbuilder 4? Thankyou, John Casimir ...

5.5.00 to 5.5.04 Update Problem
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> I'm getting database error "-157 Cannot convert SQLDATETIME to a date" after updating my SQL Anywhere from 5.5.00 to 5.5.04.&nbsp; The error only ocurred after updating to 5.5.04 and goes away if I go back to 5.5.00. The error is the result of an embedded SQL statement in which the timestamp is in the WHERE clause of a SELECT statement. Any ideas?</html> Can you post some DDL and DML to reproduce this with? -- Jim Egan [TeamPS] Dynamic Data Solutions, Inc. http://ww...

update 5.5.5 to 6.5 on new hardware
Hey all, I wanted to get your input as the most directy way of doing this. We want to update from GW 5.5.5 to 6.5. Currently our 5.5.5 machine is running NW5.0sp6a. We are getting ready to place a DL 380 G3 with Netware 6.5 sp1 installed on it. What would be the best way of getting groupwise installed and users grafted over to the new box. (all agents will be running on the one machine, GWIA, MTA, POA, WEBACCESS, etc) Can you also point me to some TID's and such to help me out. If anyone has done this before, can you tell me of any pitfalls to avoid? Thanks Matt ...

When updating from 3.0.15, Firefox updated to 3.5.4 instead of 3.5.5
Name: Product: Firefox Summary: When updating from 3.0.15, Firefox updated to 3.5.4 instead of 3.5.5 Comments: Possibly by design, but when autoupdating from 3.0.15, Firefox updated to 3.5.4 instead of 3.5.5. I would assume this is known, but it seems strange and was the case across a wide number of systems that I updated today. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 (.NET CLR 3.5.30729) From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but...

Groupwise 5.5 to 6.5 Update
Hi Guys, I'm likely to be doing an update on a Groupwise 5.5 SP2/3 system over the next week or so. The OS is 5.1 SP7. Is there any necessity to update all the GW components to a Higer SP (SP5 for example) before I update to 6.5. The update will be in place on the same servers but servers are at several sites seperated by large distance. I've recommended this to the client but they want to move fast (perhaps a little to fast) and don't want to waste another weekend. I've stipulated that all GW agents must be the same SP, but seems SP3 for GW55 (non ep) is no lon...

UpDate GroupwIse 5.5 to 6.5
Good Afternoon, After migrated netware Server (and messagerie) 5.1 to 6.5 I would to known how to update automatically client groupwise 5.5ep in the workstation to 6.5. Thank for your Help. Tech. TID 10051017 pretty much still applies, you'll just be using an updated version. Cheers Dave -- Dave Parkes [NSCS] Occasionally resident at http://support-forums.novell.com/ Good Afternoon, Thank for your help, but it doesn't work with the file setup.cfg in directory !. or forget something ! But i use Console to update the client. As : GroupWise System...

5.5 to 6.5 update question
This is actually a multi-part question - I have three 5.5 PO's, each running on NW5.0 sp6a servers. The domain, MTA, and GWIA are installed to a NW5.0 sp6a server that also runs Bordermanager. All (3) servers are being replaced with new hardware, and being upgraded to NW6.x. GW will be updated from 5.5 to 6.5. Additionally, a new server is being added with the intention of splitting the the GW domain, MTA, and GWIA functions apart from the bordermanager server described above. So, my questions are - 1) Is it best to perform the OS upgrades first, preserving current GW5.5 f...

Datawindow does not have UPDATE capability #5
SGkgQWxsICENCg0KV2hldGhlciBpdCBpcyBwb3NzaWJsZSB0byBjYXRjaCB0aGUgZGF0YXdpbmRv dyBlcnJvciBtZXNzYWdlICJEYXRhd2luZG93IGRvZXMgbm90IGhhdmUgVVBEQVRFIGNhcGFiaWxp dHkiDQpJbiB3aGF0IGV2ZW50IGl0IGlzIHBvc3NpYmxlIGl0IHRvIG1ha2U/DQoNCi0tIA0KVmxh ZGltaXIgVGVzbGVua28NCltDUFBdDQo= Prior to calling the Update() method, you could examine the dw_1.object.DataWindow.Table.UpdateTable value. A string will be returned, naming the table that may be update. If there is no updateable table, the value will be a question ,mark ( ? ). For example, at any event appropriate for checking: string ls_updateable l...

PowerBuilder 6.5 update
Does anyone know where to find a list of fixes that 6.5 is supposed to fix.. I cant find them anywhere Of what I've seen so far (I'm working from a failed download, which InstallShield doesn't seem to have figured out before trying to run the first Install.Exe it could find), it's not entirely clear, but it's there. From 65Maint.txt that comes with the install: >>> Thank you for choosing PowerBuilder as your development tool! Please read this document to learn about last minute updates to the product and documentation. For updated technical bulletins p...

Update PowerBuilder 6.5
Has anyone got this update and knows what is in it? How about this Mark? Preferential treatment from Sybase? Doug does not even have a [Team PS] following his signature... Roy (flying to LA tomorrow...) Doug Harding wrote: > >I got mine yesterday. > >It contains; > PowerDesigner AppModeler > PowerDynamo > Sql Anywhere > PB 6.5 > PowerSite > Jaguar CTS (NT only) > and the regular online books and infobases > On Fri, 7 Aug 1998 15:40:11 -0400, in powersoft.public.powerbuilder.general Mark Pfeifer[TeamPS] <...

PowerBuilder 5.0 Update
I have PowerBuilder 5.0, Desktop (full version). How do I install PowerBuilder 5.0. Professional Update w/o Powerbuilder 4? Thankyou, John Casimir ...

Web resources about - Datawindow UPDATE #5 - sybase.powerbuilder.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Intelligent Versus Surrogate Keys
Should I use business columns as primary key fields for tables in thedatabase, or generate artificial primary key values? When business-related ...

chevy volt
ProEXR File Description =Attributes= channels (chlist) compression (compression): Zip dataWindow (box2i): [0, 0, 5119, 2475] displayWindow (box2i): ...

Enable - A comprehensive solution for the localization of PowerBuilder applications Untitled Document ...
Enable is localization/ translation tool used by PowerBuilder developers to make their applications multilingual.Enable is a powerful tool that ...

comp.lang.clipper.visual-objects - Google Groups
comp.lang.clipper.visual-objects 1-20 von 33006 Themen werden angezeigt Integrity of a file marcosm...@gmail.com 09:35 Combobox value Lu 08:12 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
Developers can choose Win32 or newer style .Net development

PowerToTheBuilder - PowerBuilder UI Controls
HOME - COMPONENTS - PB UI DESIGNER - DOWNLOAD\PURCHASE - SUPPORT - FAQ - ABOUT Take Control of your UI with PB Ultimate Suite PowerToTheBuilder.com ...

Beautiful iPad Mini 3 Concept Reimagines Appleā€™s Tablet With iPhone 6 Design, Gold Color [Images]
The iPhone 6 may be grabbing all of the recent headlines due to its impending announcement, but spare a thought for those who prefer to stay ...

Java Networking - Real's HowTo
Real's HowTo Custom Search Java Language String and Number Applet AWT Swing Environment IO Javascript interaction JDBC Thread Networking JSP ...

Business Intelligence Products - Database Management, Data Warehousing & Mobility Software - Sybase Inc ...
Sybase offers a variety of Business Intelligence (BI) software like products for database management, data warehousing and mining, data integration ...

Resources last updated: 12/27/2015 4:49:34 PM