SQL Runner

SQL Runner

Purpose

SQL Runner is a menu option designed to provide a way for users to run SQL scripts against their Argos database. 
Using system security permissions, the running of SQL scripts and the generation of keycodes can be restricted to different groups of users, so that a script that alters the database cannot be run inadvertently.

Access

  1. Control | SQL Runner

Process

The below dialog will display:

Copy the SQL Script and paste this into the “SQL statement” window and 

Enquiry (Report) Scripts

If the script is an enquiry, the results will show immediately in the bottom half of the dialog

The results may be reviewed within the dialog, or  to Excel

Database Update Scripts

If the script is to change the database (and you do not have security permissions to generate key codes), the below dialog will show:


The key number should be provided to a person in your organisation authorised to generate key codes.

Enter the key code they advise to you.


The update will then be performed

The SQL Runner will display a number of rows affected as a success message:


Spot Checks should be performed to confirm that the records have been adjusted as expected



    • Related Articles

    • Installing SQL Server

      SQL Server Setup The .Net 4.8 framework and C++ Redistributables MUST be installed on the server machine prior to SQL installation. See Prerequisites for further details. SQL Server Express The instructions below are provided to assist smaller ...

    • Quick Code Cashbook Transactions

      Purpose This function is used for the coding of a Statement Transaction Amount as a single Cashbook Transaction Timing Whenever required following a bank statement Access Cashbook | Edit/View Electronic Transactions | Process To quick code a ...

    • First Analysis Code Browse

      Purpose To provide a list of First Analysis Codes that have been established Access Account | Edit/View First Analysis Codes [F2] Lookup on First Analysis Code field Search Criteria

    • General Ledger Code Browse

      Purpose To provide a list of General Ledger Codes that have been established Access General Ledger | Access GL Codes [F2] Lookup on GL Code field Search Criteria Browse Specific Search Criteria Field Explanation GL Number Enter the numeric GL Number ...

    • General Ledger Code Details

      Purpose To allow the creation of a General Ledger chart of accounts so account integration entries may be posted. Timing GL Codes may be added at any time Access General Ledger | Access GL Codes [F2] on any GL Code Lookup field Dialog Details Details ...