Eclipse SQL Engine
Previous  Top  Next

Eclipse_Database_Updater.exe can be used to view or modify your Eclipse database with the use of SQL statements. Because of this the programme should only be used under the supervision / instruction of your technical support team at Navigator unless you are confident with SQL.

SQL statements can be typed directly into the memo box on the main form of the programme, or they can be loaded from an SQL file (text file with an .SQL extention) that you can search for with the file brower dialog

It is always advisable to back up tables that you are updating before executing any SQL code.

SQL_Engine


Example SQL code
 
·Select * from AiJobs  
 
This will select all the records from the AiJobs.db table and displays the data  
 
· Update AiJobs set Invoiced = True  
 
This will update the AiJobs table (Navigator Window) and set all jobs as invoiced.  
 
·   Delete From "Sort" where Eqlno = 2  
 
The will delete all lines from the equipment list table where the equipment list number has a value of 2.  


Automating an SQL statement

The Eclipse SQL Engine accepts file names passed as commmand line parameters so you could use the Windows Scheduler to run the programme on a regular basis and pass it a list of text files containing the SQL code to process. Any file name and extension is acceptable although good practice would be to use an .SQL file extension. If the file is the same folder as the programme the full path need not be given, just the file name.

Example command line (sql files in same folder)

"C:\Program Files\Navigator Systems\Eclipse" MyFile1.sql MyFile2.sql MyFile3.sql  

Example command line (sql files NOT in same folder)

"C:\Program Files\Navigator Systems\Eclipse" C:\SQL_Files\MyFile1.sql C:\SQL_Files\MyFile2.sql C:\SQL_Files\MyFile3.sql