failpax.blogg.se

Apex sql query checkbox
Apex sql query checkbox






The Product Available check box has a default value of Y. This behavior results from the fact that: Notice that the Product Available check box is enabled though you disabled it twice when you added the product. Select the Edit icon for the product you just added.

apex sql query checkbox

Verify that the Product Available check box is not selected and then click Apply Changes. Because of the way you defined the Product Available check box, it is virtually impossible to disable it.įrom the Add/Modify Products page in Sample Application, click the Home tab.įrom the Tasks list, click Add a New Product.įill in the required fields (fields marked with an asterisk).ĭeselect the Product Available check box. One disadvantage of this approach is that you need to perform some extra steps to disable it. You can accomplish this by setting the default value attribute of the check box item. In certain circumstances, you may want a check box to be enabled by default. To learn more about static LOVs, see "Creating Lists of Values" in Oracle Database Application Express User's Guide.Īt the top of the page, click Apply Changes.Ĭlick the Run Page icon in the upper right corner. If a display value were provided, it would appear to the left of the check box and could be used in place of the label. In this example, the display value is null and the return value is Y. The Product Available radio group is an item named P6_PRODUCT_AVAIL.įrom the Display As list in the Name section, select Checkbox.įrom Named LOV, select - Select Named LOV. In the Page field, enter 6 and then click Go.

apex sql query checkbox

Navigate to the Page Definition for page 6: On the Workspace home page, click the Application Builder icon. To change the Product Available radio group to a check box: Change Product Available Radio Group to a Check Box








Apex sql query checkbox