[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1372
  • Last Modified:

editable datawindow powerbuilder?

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
stefanosn
Asked:
stefanosn
  • 4
  • 3
1 Solution
 
stefanosnAuthor Commented:
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
 
sajuksCommented:
In datawindow object
Go to  Rows > Update Properties.
Is it checked ?
0
 
stefanosnAuthor Commented:
this option sajuks is not available/enabled=false
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
sajuksCommented:
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
 
stefanosnAuthor Commented:
ok i did this but from the Rows>Update properties - Update option it is still disabled
0
 
stefanosnAuthor Commented:
oh i see i was wrong ok thanks sajuks!
0
 
sajuksCommented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now