Get Multi-fields' Value

(This action is available in Enterprise Edition only)

Fetches the one or more fields' value from an open dataset. You can also use the action to read all fields of the current record.

Parameters

Dataset name Specifies the name for the dataset. The dataset must be opened or connected prior to this instruction.
Field name/index Specifies the field name or field index number (starts from the number 0). Multiple fields should be separated by the semi-colon.
Return read value into variable Specifies the name of the variable that should be populated with the read result. The variable will be converted to an array automatically.

Notes:

Re-define the variable is not necessary. The variable will be converted to an array automatically.
For more information about the dataset, please refer to "Execute SQL Statement" or "Connect dataset in parent task".

Introduction
Editions Comparison
Minimum Requirements
Uninstalling
Using Macro Expert
- Getting Started
- Macro Manager
- Options
- Script Editor
  - Looking at Script Editor
  - Editing a macro
  - Working with the variables
  - Debugging a macro
  - Options
Macro Properties
- General
- Parameters for Playback
- Triggers
- Schedulers
- Advanced Options
Internal (built-in) Functions
Macro Commands
- General Settings and Error Handling Options
- Keyboard and Mouse
  - Key Action
  - Mouse Action
  - Put a Text
  - Mouse Move Activity
  - Mouse Action on Object
  - Series Keystrokes
  - Change Options of Mouse Actions
- Dialog
  - Display Message Dialog
  - Select a Folder
  - File-selection Dialog
  - Input Dialog
  - Show Tip Text
  - Hide Tip text
  - Choice Dialog
- Window
  - Window Action
  - Keep Window's State
  - Show or Hide Windows on Desktop
- Wait
  - Delay
  - Wait for Mouse Pointer
  - Wait for Window
  - Wait for Color
  - Wait for Window Object
  - Wait for Keystroke
  - Wait for Mouse Action
  - Wait for Image
  - Wait for File
  - Wait for Process
- Play Control
  - On Error
  - Pause
  - Stop
  - End
  - Play Speed
  - Play a Macro
  - Set Emulation Level
  - Block/unblock Mouse and Keyboard
  - Log a Playback Message
  - Save Cursor Position for Restoring
  - Reset Keyboard
- Variable
  - Set Value
  - Increase/Decrease Value
  - Advanced Set Variable Value
  - Advanced Get Variable Value
  - Exchange Variables' Value
  - Redefine Variable
  - Fill Array
  - Add an Element to Array
  - Remove an Element From Array
  - Sort all Elements in Array
  - Clone an Array
  - Search for Element in Array
- Text
  - Find Text
  - Replace Text
  - Convert Text
  - Split Text
  - Pad Text
  - Get Sub Text
  - Extract Text
  - Trim Text
  - Get Text Length
  - Append Text
  - Fomat Datetime
  - Generate Random Text
- Flow
  - Comments
  - Separator line
  - Label
  - Goto
  - If Expression
  - If Variable
  - If Color
  - If File Exists
  - If Window Exists
  - If Image
  - If Window Object
  - If Webpage Element
  - Select Case
- Loop
  - Loop
  - Loop Array
  - Loop Windows
  - Loop Files
  - Loop Processes
  - Loop Text
  - Loop Microsoft Excel
  - Loop Dataset
  - Loop Elements of Webpage
  - Exit/Continue Loop
- System
  - Run
  - Image Search
  - Text Search Based on Image
  - Read/Write INI File
  - Get Text From Object
  - Get Text From Point
  - Generate Random Number
  - Carry out Action on Object
  - End Process
  - Get Pixel
  - Get Caret (Text Cursor) Position
  - Set System Date and Time
  - Registry Operation
  - Call an External DLL
  - Send Message to Window
- Session
  - Log off
  - Start Screen-Saver
  - Lock Workstation
  - Shut-down Computer
  - Turn Off/On Display
- Clipboard
  - Copy, Cut, Paste and Clear
  - Put Text to Clipboard
  - Get Text From Clipboard
- Multimedia
  - Play an Audio
  - Increase/Decrease Volume
  - Adjust Volume
  - Sound Switch
  - Sound On/Off
  - CD Player
- Webpage
  - Open a Web page
  - Connect a Opened Webpage
  - Read Field
  - Fill Field
  - Save Image Element
  - Click Element
  - On Popup Window on Webpage
  - Submit Form
  - Find Element
  - Wait for Element
  - Close Webpage
  - Save Webpage Content
  - Internet Explorer Navigation Actions
  - Change Window of Webpage
- Network
  - Make Remote Access Connection
  - Disconnect Remote Access Connection
  - Connect Network Resource
  - Disonnect Network Resource
- Internet
  - Send Email
  - HTTP Download
  - HTTP Post
  - Ping
  - Retrieve Internet Time
  - Delete Tempoary Internet Files
  - Delete Internet Explorer Cookies
  - Clear Internet Explorer History
- FTP
  - Log On
  - Connect Session in Parent
  - Log Off/Disconnect
  - Download
  - Upload
  - Create Folder
  - Delete Folder
  - Get Current Path
  - Change Current Path
  - Delete Files
  - List Files
  - Rename
  - Move Files
  - Move Folder
  - FTP Command
- File
  - Copy Files
  - Move Files
  - Delete Files
  - Create a Folder
  - Delete a Folder
  - Rename Files
  - Set File Attributes
  - Change File Time
  - Synchronize Folders
  - Compress Files
  - Extract a Zipped File
  - Read Text File
  - Write Text File
  - Find/Replace in File
- Microsoft Excel Document
  - Open Document
  - Create a Microsoft Excel Document
  - Connect Open Document
  - Close Document
  - Save Document
  - Read a Cell
  - Read Multiple Cells
  - Write Cell
  - Find Cell
  - Add Worksheet
  - Remove Worksheet
  - Activate Worksheet
  - Wait for Cell
- Database
  - Connect to Data Source
  - Close Data Source Connection
  - Execute SQL Statement
  - Connect Dataset in Parent
  - Close Dataset
  - Set Field Value
  - Get Field Value
  - Get Multi-fields' Value
  - Change Current Record Position
  - Transaction on Data Source
Variables and Expressions
Command Line Usage
Frequent Question and Answer
Purchasing Macro Expert

Mailing List

Subscribe to our newsletter and receive updates, tips and tricks on how to automate your tasks with Macro Expert.

Get Multi-fields' Value

Parameters

Notes:

Resources & Support

Websites

About

Mailing List