Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

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

Mike22Doyle
Level 1
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