GSAK (Geocaching Swiss Army Knife)
 

Contents - Index

SQL - Connect To


Connects to a database (a folder containing a set of stored SQL tables). Tables are stored in folders as semicolon-delimited text files with file names that have the .txt extension

Syntax:

  CONNECT TO 'absolute-folder-path'
 

Example:
 
 
$status = sql("connect to 'c:\temp\data'","")  
  if left($status,7) = "*ERROR*"
     cancel msg=$status
  endif
  # no errors, so continue macro code here

  
Notes
At the very start of a macro, GSAK automatically defaults to opening the "Macros" folder in the install folder of GSAK. Issue this as your first SQL statement if you want to open a different folder for the SQL engine to operate on.

Copyright 2004-2008 CWE Computer Services  
Privacy Policy Contact