tag:blogger.com,1999:blog-5874979429188093780.post4087786615890016819..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: Creating new row using CreateInsert operationAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger71125tag:blogger.com,1999:blog-5874979429188093780.post-74482369116578414372017-07-25T18:41:50.221+02:002017-07-25T18:41:50.221+02:00I have created editable table but one of my column... I have created editable table but one of my column is LOV field for which i have used 'SelectOneChoice' but wen i call 'CreateWithParams' method to get new editable row I m not getting the LOV field, filed is not at all available not even empty. Plz suggestAnonymoushttps://www.blogger.com/profile/01170439770652253600noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-25322604732777527722015-01-14T09:05:10.972+01:002015-01-14T09:05:10.972+01:00Just check if your page def holds commit operation...Just check if your page def holds commit operation in Binding section. If no, Click on Binding tab of your page , in Bindings column , click on Add , choose a Action , click OK , Select The appropriate DataControl and Select Commit as Operation.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-35582227623931568332014-06-17T00:26:49.237+02:002014-06-17T00:26:49.237+02:00hi , i want to create the same table but jobID won...hi , i want to create the same table but jobID wont be shown on table but when i insert the row to db, i will get jobid from session, is it possible to do it in adf? <br />thanks for help.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-83969203009432941582014-03-19T03:29:02.625+01:002014-03-19T03:29:02.625+01:00Hi Andrejus,
Thank you so much for the post. It ...Hi Andrejus, <br /><br />Thank you so much for the post. It helps newbies like to learn a lot from such posts.I have a question regarding similar implementation.<br /><br />Requirement:<br /><br />Page to be loaded with an empty form and a table with values. On filling in the empty form and clicking save, the row should be committed to the database and added to the table as well, but the focus on the table has to be on the newly created row. There is only one button to save as on saving the form, the form gets erased and a new form appears and the saved row is populated in the table.<br /><br />Approach Followed: In my taskflow, I made createInsert as a default view for the iterator I needed and then directed to my view with form and table. I dragged and dropped commit button as save below the form and it works fine. <br /><br />Question: My question here is I want to programatically commit the page because before committing I want to do some other logic in the page <br /><br />I used the following<br />BindingContainer dc = (BindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();<br />OperationBinding operbind= dc.getOperationBinding("Commit");<br />operbind.execute();<br /><br />On doing programatically I only see the row populating but its not getting saved. Could you please help me to programatically save on createInsertAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-89912222668484157682013-02-22T08:13:40.755+01:002013-02-22T08:13:40.755+01:00Hi,
I have two col1,col2. col2 is unique.
I want t...Hi,<br />I have two col1,col2. col2 is unique.<br />I want to insert record if it's new(col1 value is new or doesnot exist) and override col2 if the col1 value is already exist,programmatically.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-63377922865490348772012-11-21T22:11:15.912+01:002012-11-21T22:11:15.912+01:00Thanks for update.
AndrejusThanks for update.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-29119524032855359032012-11-21T19:30:12.679+01:002012-11-21T19:30:12.679+01:00Hi Andrejus,
Thanks for the post. But in one of t...Hi Andrejus,<br /><br />Thanks for the post. But in one of the comments the code you provided for adding at the end of the row <br /><br />iter.insertRowAtRangeIndex(iter.getRangeSize() - 1, newRow)<br /><br />This will throw error for out of range, so rather it should insert at the index after last row<br /><br />iter.insertRowAtRangeIndex(iter.getRangeIndexOf(lastRow) +1, newRow);Ankithanoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-27900060354442753332012-04-29T08:44:25.378+02:002012-04-29T08:44:25.378+02:00Yes, you can implement this easily with Router act...Yes, you can implement this easily with Router activity and calling different Method Actions from TF.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-26393791078064782442012-04-27T23:24:21.175+02:002012-04-27T23:24:21.175+02:00Hi Andre,
Could you please respond to my previous...Hi Andre,<br /><br />Could you please respond to my previous post.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-34479967968515436842012-04-24T20:24:53.862+02:002012-04-24T20:24:53.862+02:00Yes Andre, I have a BTF and in that i have a metho...Yes Andre, I have a BTF and in that i have a method call. So can i do something with this?? I am thiking like at the time of calling this method it should verify whetehr data is there in the table or not if there is no data then it has to show in create page(with empty fields) and if data osi there then the adf page has to show that existing data. Please provide some solution for this.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-85810284709736722142012-04-24T20:05:23.912+02:002012-04-24T20:05:23.912+02:00And how you want to insert data without Create dat...And how you want to insert data without Create data, there must be some other event?<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-25853653522520198512012-04-24T19:21:44.422+02:002012-04-24T19:21:44.422+02:00Hi,
No that solution doesn't work for me. In m...Hi,<br />No that solution doesn't work for me. In my case consider i have a table with a primary key, a varchar2(15), char(1) columns. and there is no data in that table. now i want to insert data into this table from the ADF page. my adf page contains one textbox bound to that varchar2(15) column and one checkbox bound to char(1) and one save button. now there is no create or createinsert buttons on my page. so how can i do this? i observed if there is no data in the table the textbox is not coming ine thr ui and checkbox is shown in readonly mode. please provide some code snippet. i m struggling for past 15 days. thanks in advance.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-66213471358527478332012-04-17T22:23:39.397+02:002012-04-17T22:23:39.397+02:00May be this post will help you: http://andrejusb.b...May be this post will help you: http://andrejusb.blogspot.com/2011/11/oracle-adf-11g-table-insert-with-empty.html<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-28193532379245195962012-04-17T20:35:47.159+02:002012-04-17T20:35:47.159+02:00Hi Andrejus,
Can you provide one quick code snipp...Hi Andrejus,<br /><br />Can you provide one quick code snippet for the below scenario.<br /><br />Consider I have two text boxes and a check box in my UI. and there is no data in the tables. so my landing page should contain two textboxes and one check box, one save button and one cancel. So how can I achieve this. As per my undestanding to insert records into database we should first click either create/createInsert buttons and I dont want to use this. One more thing I observed is if there is no data in the tables. The UI Components are shown in read only mode? why is this behavior? How can i made them editable? Please clarify with some example/code and steps. I am struggling for this past one week.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-45973701988115232802012-04-14T07:43:25.738+02:002012-04-14T07:43:25.738+02:00Yes of course, why not?
AndrejusYes of course, why not?<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-32212426287843981462012-04-13T18:24:03.854+02:002012-04-13T18:24:03.854+02:00Hi Andrejus,
This is really a good post. I have o...Hi Andrejus,<br /><br />This is really a good post. I have one basic doubt here please clarify.<br />Consider I have two text boxes in my UI and two buttons save and cancel. What operations I should use here. My main doubt here is can i use commit alone without create/createInsert.???Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-23849913438005802522011-07-17T22:31:14.100+02:002011-07-17T22:31:14.100+02:00Hi,
In my jspx page i have a button,textfield an...Hi,<br /><br />In my jspx page i have a button,textfield and a table. when user enters a number, say '2' and clicks on the create button 2 rows have to be created in the table provided a unique id(which is combination of char and numbers)be inserted in table and displayed in the table. So when button clicked generating unique id, inserting it to table and displaying it to table has to be done. How can i do that.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-425148384912587672010-11-09T07:59:53.658+01:002010-11-09T07:59:53.658+01:00Is there any functions or procedure like the NEXT_...Is there any functions or procedure like the NEXT_RECORD in Oracle Forms Developer?This use for the detail record operation to create multi rows and bar scanners input. in your examples it needs to push button to create or insert record.<br />Im new with this jdeveloper and no knowledge about it ,html or java(etc.). but im trying this adf and im interested with it...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-57025951848243657172010-11-09T07:58:07.352+01:002010-11-09T07:58:07.352+01:00Is there any functions or procedure like the NEXT_...Is there any functions or procedure like the NEXT_RECORD in Oracle Forms Developer?This use for the detail record operation to create multi rows and bar scanners input. in your examples it needs to push button to create or insert record.<br />Im new with this jdeveloper and no knowledge about it ,html or java(etc.). but im trying this adf and im interested with it...<br /><br />Currently using Forms 10g on AS10g<br /><br />sorry for my english...<br />Tnx...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-82172640066279630282010-09-18T17:08:22.070+02:002010-09-18T17:08:22.070+02:00Hi,
You need to use Rollback operation for this, ...Hi,<br /><br />You need to use Rollback operation for this, not Delete.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-18819985818449306272010-09-18T13:50:31.996+02:002010-09-18T13:50:31.996+02:00Hi Andrejus,
I have dragged the view object as a A...Hi Andrejus,<br />I have dragged the view object as a ADF Table and created 3 buttons for CreateInsert, delete and commit functionality for the same.<br />When i click on createInsert it create's a new row in the table. What should i do if i want to delete that new empty row created. ( it gives me error sayin the Primary key fields needs to be entered and doesn't let me delete the empty row usind the delete button)<br /><br />Please help.<br /><br />Regards,<br />AparnaUnknownhttps://www.blogger.com/profile/07544416973185247009noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-25069429961934790102009-05-25T08:18:04.831+02:002009-05-25T08:18:04.831+02:00HI Andrejus,
I am struck at point:-
I want to writ...HI Andrejus,<br />I am struck at point:-<br />I want to write code (Enable/Disable and assignment of value to input text etc).<br /><br />I have gone through Jdeveloper forum and try to implement onpageload() through phaselister but it is not working with. The onpageload()not being called when in open that page.<br /><br />I need your help in this regard.<br /><br />Can upload/post any example regarding this issue<br /><br />I will be thankfull this favour.<br /><br />Regard<br /><br />M NiazAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-42084434711912411992009-05-11T21:37:00.000+02:002009-05-11T21:37:00.000+02:00Hi,
You can try to use DisplayRow = selected prop...Hi,<br /><br />You can try to use DisplayRow = selected property on af:table.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-12839700262562924832009-05-11T12:23:00.000+02:002009-05-11T12:23:00.000+02:00How to set cursor focus on the first column of a n...How to set cursor focus on the first column of a newly added row in a table?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-69009275151937861262009-05-05T04:13:00.001+02:002009-05-05T04:13:00.001+02:00Thanks for the quick response. I tried out this an...Thanks for the quick response. I tried out this and it is working for view and document. How about for the dialog, popup and Boundedtaskflow which doesn't have the af:view or af:docuemnt.<br /><br />- thivaAnonymousnoreply@blogger.com