javascript - Clone Row (copy records) in Oracle Apex is not working - 


<script type="text/javascript">     function fn_clonerow(pthis) {         $(pthis).parent().parent().clone().appendto($(pthis).parent().parent().parent());     }

with use of above code able clone clicked rows in tabular form bottom of table, unable store them. when change values of cloned rows, original row updated instead of adding new row when page submitted.

that because in cloning row clone element containing primary key. top of head, following elements:

  • empty input element containing pk (you'll need find out if array f01 or other. question not provide context) or if use rowid, clean out input element name "frowid"
  • empty input element containing row checksum. input element name "fcs"
  • set input element containing record status (name = fcud) 'c' . used determine action perform on it. 'd' new, 'c' changed , 'u' update - presume. not in documentation though, inspecting html , javascript can find this.

you can further improve code not doing parent().parent()... , instead closest tr or table using .closest(...)

var newrow = $(pthis).closest('tr').clone(); $('input[name=f01]', newrow).val(""); //input pk value -- make sure matches situation!!! $('input[name=frowid]', newrow).val(""); //or if form works rowid, use $('input[name=fcs]', newrow).val(""); //clear checksum $('input[name=fcud]', newrow).val("c"); //set record status newrow.appendto($(pthis).closest('table')); //finally, append row table

Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more