I'm newbie for this ListX. I need assistance to solve this problem.
I'm trying to add and delete record on the table. Unfortunately it doesn't work. For Update Record it work.
<?xml version="1.0" encoding="utf-16"?>
<xListSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<recordsPerPage>0</recordsPerPage>
<enableAlphaFilter>false</enableAlphaFilter>
<enablePageSelection>false</enablePageSelection>
<enableRecordsPerPage>false</enableRecordsPerPage>
<enableCustomPaging>false</enableCustomPaging>
<enableExcelExport>false</enableExcelExport>
<enableQueryDebug>false</enableQueryDebug>
<enableAJAX>false</enableAJAX>
<enableAJAXCustomPaging>false</enableAJAXCustomPaging>
<enableAJAXCustomStatus>false</enableAJAXCustomStatus>
<includeJavascriptUtilities>false</includeJavascriptUtilities>
<includeJavascriptValidation>false</includeJavascriptValidation>
<enableMultipleColumnSorting>false</enableMultipleColumnSorting>
<ModuleCommunicationMessageType />
<showAll>true</showAll>
<searchItems />
<queryItems>
<anyType xsi:type="QueryOptionItem">
<Index>0</Index>
<VariableType><Session></VariableType>
<QuerySource>CurrentGatewayID</QuerySource>
<QueryTarget>[GatewayID]</QueryTarget>
<Protected>false</Protected>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>1</Index>
<VariableType><Form></VariableType>
<QuerySource>fld_Gateway</QuerySource>
<QueryTarget>[Gateway]</QueryTarget>
<Protected>true</Protected>
</anyType>
<anyType xsi:type="QueryOptionItem">
<Index>2</Index>
<VariableType><Form></VariableType>
<QuerySource>fld_GatewayID</QuerySource>
<QueryTarget>[GatewayID]</QueryTarget>
<Protected>true</Protected>
</anyType>
</queryItems>
<listItems />
<messageItems>
<anyType xsi:type="MessageActionItem">
<Index>0</Index>
<ActionType>Message</ActionType>
<ActionInformation>4:7;6;ToolbarCancel</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>1</Index>
<ActionType>Condition-If</ActionType>
<ActionInformation>7:26;1;2;[CurrentGatewayID,Session]=-1</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>2</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>7:9;16;0;<Session>CurrentGatewayID</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>3</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>7:3;17;2;Tab[bi4ce_bc_back,S]59</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>4</Index>
<ActionType>Condition-Else</ActionType>
<ActionInformation />
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>5</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>7:3;17;2;Tab[bi4ce_bc_back,S]59</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>6</Index>
<ActionType>Message</ActionType>
<ActionInformation>4:7;4;ToolbarSave</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>7</Index>
<ActionType>Condition-If</ActionType>
<ActionInformation>7:26;1;2;[CurrentGatewayID,Session]=-1</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>8</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>6:6;106;InsertInsertGatewayID @GatewayID=[CurrentGatewayID, Session], @Gateway='[FORMAT,[fld_Gateway,F],{REPLACE:',''}]'</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>9</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>8:9;16;13;<Session>CurrentGatewayID[GatewayID,0]</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>10</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>7:3;17;2;Tab[bi4ce_bc_back,S]59</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>11</Index>
<ActionType>Condition-Else</ActionType>
<ActionInformation />
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>12</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>6:6;106;UpdateUpdateGatewayID @GatewayID=[CurrentGatewayID, Session], @Gateway='[FORMAT,[fld_Gateway,F],{REPLACE:',''}]'</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>13</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>6:3;0;2;Tab59</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>14</Index>
<ActionType>Message</ActionType>
<ActionInformation>4:7;6;ToolbarDelete</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>15</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>5:6;52;DeleteDeleteGatewayID@GatewayID=[CurrentGatewayID,Session]</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>16</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>7:9;16;0;<Session>CurrentGatewayID</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>17</Index>
<ActionType>Action-Redirect</ActionType>
<ActionInformation>6:3;0;2;Tab59</ActionInformation>
<Level>2</Level>
</anyType>
</messageItems>
<query>SELECT GatewayID, Gateway FROM GatewayID WHERE GatewayID=[GatewayID]
</query>
<filter />
<customConnection>Provider=SQLOLEDB;Server=localhost;Database=VoCALData;uid=vocal;pwd=vocal;</customConnection>
<listItem><br/><br/>
<table width="100%" cellpadding="0" cellspacing="2" border="0" id="listXTable">
<thead>
<tr>
<td width="10%" nowrap><img src="images/1x1.gif" width="100%" height="1px" border="0"></td>
<td width="90%"><img src="images/1x1.gif" width="100%" height="1px" border="0"></td>
</tr>
</thead>
<tbody>
<tr><td class="Tier3Label">Gateway ID</td><td class="Tier3Edit"><input type="textbox" class="Tier3Textbox" id="fld_GatewayID" name="fld_GatewayID" value="[GatewayID]" disabled></td></tr>
<tr><td class="Tier3LabelRequired">Gateway</td><td class="Tier3Edit"><input type="textbox" class="Tier3Textbox" id="fld_Gateway" name="fld_Gateway" value="[Gateway]"></td></tr>
</tbody>
</table>
</listItem>
<listAItem />
<defaultItem><br/><br/>
<table width="100%" cellpadding="0" cellspacing="2" border="0" id="listXTable">
<thead>
<tr>
<td width="10%" nowrap><img src="images/1x1.gif" width="100%" height="1px" border="0"></td>
<td width="90%"><img src="images/1x1.gif" width="100%" height="1px" border="0"></td>
</tr>
</thead>
<tbody>
<tr><td class="Tier3Label">Gateway ID</td><td class="Tier3Edit"><input type="hidden" class="Tier3Textbox" id="fld_GatewayID" name="fld_GatewayID" value="[CurrentOrderID]" ></td></tr>
<tr><td class="Tier3LabelRequired">Gateway</td><td class="Tier3Edit"><input type="textbox" class="Tier3Textbox" id="fld_Gateway" name="fld_Gateway" value=""></td></tr>
</tbody>
</table>
</defaultItem>
<noqueryItem>{IIF,"'[GatewayID]'='-1'","<span class=""Tier3NewRecordTitle""><New Gateway Being Added></span>","<span class=""Tier3Title"">Edit: [Gateway]</span>"}
</noqueryItem>
<Version>16</Version>
</xListSettings>
I'm follow the code shown in Northwind tutorial Order Edit page.
All the Stored Procedure used tested work on Query Analyzer.
Thanks in advance.