Kofax TotalAgility
  • Welcome
  • Get started
  • Process Designer module
  • Form Designer module
    • Forms designing interface
    • Modeling bar of Form Designer
    • Automatically generate forms
    • Manually create a form
    • Automatically generate MFP forms
    • Manually create an MFP form
    • Log on to TotalAgility using a phone or tablet form
    • Save, release and deploy a form
    • Configure the form properties
    • Form variables
    • Form controls
    • Add actions to a form or control
      • Events and actions supported by form and basic controls
      • Events and actions supported by advanced controls
      • Events and actions supported by the capture forms and composite controls
      • Events and actions supported by the tablet and phone forms
      • Events and actions supported by a MFP form
      • Events and actions supported by the Capture Client controls
      • Add actions
        • Add a .NET Method action
        • Add a Condition action
        • Add an Else Condition action
        • Add an Add Row action to a table
        • Add an Apply Form Variant action
        • Add an Apply Validation action
        • Add an Alternative Extraction Search action
        • Add a Business Rule action
        • Add a Calculation Rule action
        • Add a Change Stack Order action
        • Add a Clear action
        • Add a Clear Selection action
        • Add a Close action
        • Add a Composite action
        • Add a Create Entity Instance action
        • Create a DB query
          • DB Query to view records in a table
          • DB Query to add records to a table
          • DB Query to delete database records
          • DB Query to update database records
          • DB Query to use stored procedures of a database
          • DB Query to use the database views
          • Insert multiple records into a database
        • Add a DB Query action
        • Add a Delete Row action
        • Add a Display Rule action
        • Add an Else Condition action
        • Add a File Upload action
        • Add a Find Entity action
        • Add a Fuzzy Search action
        • Add a Get Entity Attributes action
        • Add a Hide Action Menu action
        • Add a JavaScript action
        • Add a Kapow action
        • Add a Print action
        • Add a Redirect action
        • Add a Refresh Capture Form action
        • Add a Refresh Page Rendition action
        • Add a Reset Form Variables action
        • Add a RESTful Service action
        • Add a Same Page action
        • Add a Scan action
        • Add a Scan Settings action
        • Add a Set Device action
        • Add a Set Entity Attributes action
        • Add a Set Focus action
        • Add a Set Language from Job action
        • Add a Show Action Menu action
        • Add a Show Message action
        • Add a Show Navigation action
        • Add an Update Row action for a table
        • Add an Update Control action
        • Add a Web Capture action
        • Add a Web Service action
        • Enumerations
      • Configure multilingual actions for a form or control
      • Associate an action with a form or a control
      • Modify an action
      • Create a copy of an action
      • Delete an action
    • Work with Forms
    • Form variants
    • Navigation menus
    • Sites
    • Themes
    • Global variables
    • Security tokens
    • Translation
    • Manage style sheets
    • Manage images
    • Manage custom pages
  • Data module
  • Resources module
  • Integration module
  • System Settings module
  • Insight module
  • Business Monitoring module
  • Packages module
  • Access related documentation
  • Get help for Kofax products
  • Glossary

Your search for {searchVal} returned {total} results.

The search returns topics that contain every term you enter. If you type more than one term, an "and" is assumed. The results appear in order of relevance, based on how many search terms occur per topic.

  • If a search returns too many topics, add more search terms or search for an exact phrase. To search for an exact phrase, enclose it in double quotation marks (for example, “batch class”).
  • If a search returns too few topics, reduce the number of terms entered or use a partial term. If an exact match cannot be found, the search uses “fuzzy” matching to find similar terms. Only terms with exact matches are highlighted in the search results.
Welcome > Form Designer module > Add actions to a form or control > Add actions > Create a DB query

Create a DB query

Create a DB query to:

  • View records in a table

  • Add records to a database table

  • Update records in a database table

  • Delete records to a database table

  • Use the database stored procedures

  • View records in a selected view

Use a DB Query in the following:

  • Data Access activity on a process map. See Configure a Data Access activity.

  • DB Query action on a form. See Add a DB Query action.