Solved

editable datawindow powerbuilder?

Posted on 2004-10-07
7
1,221 Views
Last Modified: 2013-12-26
long ll_newrow

ll_newrow = dw_3.InsertRow(0)

dw_3.ScrollToRow(ll_newrow)

this code is assigned to a button that i created at the form not the datawindow

at the clicked() event exists the above code.

a new line appears at the datawindow when i press the button but is not editable. I can not write in the fields.

help please!
0
Comment
Question by:stefanosn
  • 4
  • 3
7 Comments
 

Author Comment

by:stefanosn
ID: 12256637
i found out that i had to change the tab order to edit the fields so... after that i insert a new row and i press the save button that i have on the form not the datawindow...but i get a message saying that "datawindow does not have UPDATE capability"

thats the code...help!

integer rtn
rtn = dw_3.Update()
IF rtn = 1 THEN
        COMMIT USING SQLCA;
ELSE
        ROLLBACK USING SQLCA;
END IF
0
 
LVL 33

Expert Comment

by:sajuks
ID: 12256716
In datawindow object
Go to  Rows > Update Properties.
Is it checked ?
0
 

Author Comment

by:stefanosn
ID: 12256732
this option sajuks is not available/enabled=false
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 33

Accepted Solution

by:
sajuks earned 50 total points
ID: 12256745
You have to enable it
Allow Updates hsould be checked.
Selct the updataeable columns
Select the name of the table to update from the drop down
And finnaly click on the primary key button to select the pk of the table.

0
 

Author Comment

by:stefanosn
ID: 12256819
ok i did this but from the Rows>Update properties - Update option it is still disabled
0
 

Author Comment

by:stefanosn
ID: 12256824
oh i see i was wrong ok thanks sajuks!
0
 
LVL 33

Expert Comment

by:sajuks
ID: 12256844
stefanosn  i really fail to see why you continuously insist on giving b grades for perfect answers.
I wouldnt have minded if  there was some other alternatives or some thing which i'd missed/
Can you please enlighten me on this.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now