FairCom Edge
FairCom MQ
FairCom RTG
FairCom ISAM
FairCom DB
Common info
  • FairCom Edge

    • Edge Tutorials

      • Edge APIs

        • Transform Methods

          • Field Bus Connectors

            • Software Connectors

              • Industrial Ethernet Connectors

                • Edge Versions and Compatibility

                  • Edge Overview

                  • Edge Administration

                  • Edge Concepts

                • FairCom MQ

                  • MQ Concepts

                    • MQ Tutorials

                      • MQ Versions and Compatibility

                        • FairCom MQ overview

                        • MQ Administration

                        • MQ APIs

                      • FairCom RTG

                        • RTG overview

                          • RTG setup and installation

                            • Modern data management with RTG

                              • RTG utilities

                                • RTG logging, error codes, and troubleshooting

                                  • RTG configuration

                                    • RTG Versions and Compatibility

                                      • RTG data conversion

                                      • RTG transaction support

                                      • RTG SQL access

                                      • RTG XDD schema structure

                                      • RTG tutorials

                                      • Upgrade files to RTG 5 attribute resource format (Unified Data Types)

                                    • FairCom ISAM

                                      • ISAM overview

                                        • ISAM setup and installation

                                          • ISAM configuration file elements

                                            • ISAM utilities

                                              • ISAM Versions and Compatibility

                                                • Advanced ISAM techniques

                                                • ISAM logging, error codes, and troubleshooting

                                                • ISAM XDD schema structure

                                                • Btrieve compatibility

                                              • FairCom DB

                                                • JSON DB concepts

                                                  • DB Tutorials

                                                    • DB Upgrade

                                                      • DB Concepts

                                                        • ACE APIs

                                                          • DB Versions and Compatibility

                                                            • FairCom DB JSON APIs

                                                            • FairCom DB Standalone V12/V13 Updates

                                                            • FairCom DB FAQs

                                                          • Common info

                                                            • Install

                                                              • JSON API

                                                                • Errors

                                                                  • Security

                                                                    • FairCom Data Change Stream (DCS)

                                                                      • FairCom DB Notify

                                                                        • Replication

                                                                          • User interfaces

                                                                            • License agreements

                                                                              • FairCom terms glossary

                                                                              1. Common info
                                                                              2. JSON API
                                                                              3. DB Query Data
                                                                              4. Query API actions

                                                                              Query API actions Articles

                                                                              1. closeCursor: JSON DB "closeCursor" action closes a previously opened cursor
                                                                              2. getRecordsByIds: JSON DB "getRecordsByIds" action retrieves records from a database table using their IDs
                                                                              3. getRecordsByIndex: JSON DB "getRecordsByIndex" action can return a cursor to retrieve a large number of records efficiently or to navigate and retrieve records in any desired way
                                                                              4. getRecordsByPartialKeyRange: JSON DB "getRecordsByPartialKeyRange" action retrieves zero or more records from a database table using the specified key range
                                                                              5. getRecordsByTable: JSON DB "getRecordsByTable" action retrieves records from a database table in table order and performs a full scan of all records in a table
                                                                              6. getRecordsFromCursor: JSON DB "getRecordsFromCursor" action retrieves records from a cursor created by a "getRecords..." action
                                                                              7. getRecordsInKeyRange: JSON DB "getRecordsInKeyRange" action returns records within a range of values
                                                                              8. getRecordsStartingAtKey: JSON DB "getRecordsStartingAtKey" action positions the current record in the index at the key that most closely matches the comparison criteria
                                                                              9. getRecordsUsingSQL: JSON DB "getRecordsUsingSQL" action runs a SQL query and returns the resulting records
                                                                              Sorry, we didn't find any relevant articles for you.

                                                                              Please fill out the contact form below and we will reply as soon as possible.

                                                                              • Privacy
                                                                              • Terms

                                                                              FairCom Corporation © Copyright 2026