oracle10g - XPage jdbcRowSet + repeat control: In place changes not persisted in Oracle 10 DB -

-

i trying create “endless form”, user can edit rdbms table's column values directly in form (i.e. without opening separate “edit form” allows edit single row). using xpages repeat control bound jdbcrowset accesses simple person table in oracle 10 db (id number primary key, first/last name, plus additional columns not exposed in form).

displaying data , editing works expected, persisting changes db fails persistently, without error message. in source code below 1 can see ways have tried tell data source save changes made, no avail. (using same code notes datasource works expected , persists changes).

how jdbcrowset persist changes in form ?

thanks in advance help, martin

<xp:view xmlns:xp=“http://www.ibm.com/xsp/core”  xmlns:xe="http://www.ibm.com/xsp/coreex">  <xp:this.data>     <!-- <xp:dominoview var="view1ld" viewname="authorview"></xp:dominoview> -->     <xe:jdbcrowset var="view1" connectionname="oracle10"         sqltable="person">     </xe:jdbcrowset>     <xe:jdbcquery var="jdbcquery1"></xe:jdbcquery> </xp:this.data>   <xp:panel id="panel0">      <xp:repeat id="repeat1" rows="30" value="#{view1}" var="rpt">         <xp:panel id="paneldocdata">             <xp:inputtext id="inputtext1" value="#{rpt.id}"></xp:inputtext>             <xp:inputtext id="inputtext2"                 value="#{rpt.first_name}">             </xp:inputtext>             <xp:inputtext id="inputtext3" value="#{rpt.last_name}"                 showreadonlyasdisabled="true">             </xp:inputtext>             <xp:inputtext id="inputtext5"                 defaultvalue="#{rpt.last_name}">             </xp:inputtext>         </xp:panel>     </xp:repeat>      <xp:br></xp:br>     <xp:inputtext id="inputtext4" value="#{view1.last_name}"></xp:inputtext>     <xp:br></xp:br>     <xp:br></xp:br>     <xp:button value="save" id="button1">         <xp:eventhandler event="onclick" submit="true"             refreshmode="complete">             <xp:this.action><![cdata[#{javascript:view1.acceptchanges()}]]></xp:this.action>         </xp:eventhandler>     </xp:button>     <xp:button value="simply save" id="button3">         <xp:eventhandler event="onclick" submit="true"             refreshmode="complete" immediate="false" save="true">             <xp:this.action>                 <xp:save></xp:save>             </xp:this.action>         </xp:eventhandler>     </xp:button>     <xp:button value="submit" id="button4">         <xp:eventhandler event="onclick" submit="true"             refreshmode="complete" immediate="false" save="true">             <xp:this.action>                 <xp:confirm                     message="are sure want persist changes in database ?">                 </xp:confirm>             </xp:this.action>         </xp:eventhandler>     </xp:button>     <xp:button value="save document" id="button5">         <xp:eventhandler event="onclick" submit="true"             refreshmode="complete">             <xp:this.action>                 <xp:savedocument var="view1"></xp:savedocument>             </xp:this.action>         </xp:eventhandler>     </xp:button>     <xp:button id="button6">         <xp:this.value><![cdata[save datasource]]></xp:this.value>         <xp:eventhandler event="onclick" submit="true"             refreshmode="complete">             <xp:this.action><![cdata[#{javascript:rpt.acceptchanges()}]]></xp:this.action>         </xp:eventhandler>     </xp:button>     <xp:button value="save view ds" id="button7">         <xp:eventhandler event="onclick" submit="true"             refreshmode="complete">             <xp:this.action><![cdata[#{javascript:view1.acceptchanges()}]]></xp:this.action>         </xp:eventhandler>     </xp:button>     <xp:button value="save view ds 2" id="button8">         <xp:eventhandler event="onclick" submit="true"             refreshmode="complete">             <xp:this.action><![cdata[#{javascript:view1.rpt.acceptchanges()}]]></xp:this.action>         </xp:eventhandler>     </xp:button> </xp:panel> <xp:br></xp:br>


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more