Expand my Community achievements bar.

Livecycle Designer form connected to database - button to advance to next record does not work

Avatar

Level 1

I have a liecycle designer form that is connected to a query in an MS Access 2010 database.  I have placed a button on the form to advance to the next record.  It doesn't appear to be doing that. The form was created using Livecycle Designer ES4. When I click on the button nothing happens.  I realize it might be something as simple as a refresh, and if that's so, please give me a hint as to how to do that.

Thanks.

here is the header in the XML of the form.

<?xml version="1.0" encoding="UTF-8"?>
<?xfa generator="AdobeLiveCycleDesigner_V11.0.0.20130303.1.892433" APIVersion="3.6.13061.0"?>
<xdp:xdp xmlns:xdp="http://ns.adobe.com/xdp/" timeStamp="2015-06-10T19:23:30Z" uuid="0d801ee9-3585-459d-bc3f-

1b8d4c3435f8">
<template xmlns="http://www.xfa.org/schema/xfa-template/3.0/">

Here is the connection

<sourceSet xmlns="http://www.xfa.org/schema/xfa-source-set/2.8/">
   <source name="DataConnection" db="ado">
      <connect delayedOpen="0" timeout="15">
         <connectString>Provider=MSDASQL.1;Persist Security Info=False;Data Source=N4;Mode=Read</connectString>
         <user/>
         <password/>
      </connect>
      <command timeout="30">
         <query commandType="text">
            <select>SELECT N4.TO_TenantName, N4.From_LandlordName, N4.RentalUnitAddress, N4.PayDate,

N4.OweMeAmount, N4.ArrearFrom1, N4.ArrearTo1, N4.RentCharged1, N4.RentPaid1, N4.RentOwe1, N4.ArrearFrom2,

N4.ArrearTo2, N4.RentCharged2, N4.RentPaid2, N4.RentOwe2, N4.ArrearFrom3, N4.ArrearTo3, N4.RentCharged3,

N4.RentPaid3, N4.RentOwe3, N4.RfirstName, N4.Rlastname, N4.RDayPhone, N4.AgentName, N4.AgentLSUC, N4.AgentCompany,

N4.AgentAddress, N4.AgentPhoneNum, N4.AgentMunicipality, N4.AgentProvince, N4.AgentPostCode, N4.AgentFaxNum&#xD;
FROM N4&#xD;
ORDER BY N4.RentalUnitAddress;&#xD;
</select>
            <recordSet cursorType="forwardOnly" cursorLocation="client" lockType="readOnly" bofAction="moveFirst"

eofAction="stayEOF" max="0"/>

This is the Button code

         <field name="Button1" y="3.651mm" x="14.617mm" w="28.268mm" h="6.738mm" relevant="-print">

            <ui>

               <button/>

            </ui>

            <font typeface="Myriad Pro"/>

            <caption>

               <value>

                  <text>Button</text>

               </value>

               <para vAlign="middle" hAlign="center"/>

            </caption>

            <border hand="right">

               <edge stroke="raised"/>

               <fill>

                  <color value="212,208,200"/>

               </fill>

            </border>

            <bind match="none"/>

            <event activity="click" name="event__click">

               <execute/>

            </event>

            <event activity="click" name="event__click">

               <script contentType="application/x-javascript">

               xfa.sourceSet.DataConnection.Next();

               </script>

            </event>

         </field>

0 Replies