Digital Workshop

// Testing Opus v6 access to an SQLite DB.
function doingnwindDB3()
{
var adiffDB = "D:\\FolderA\\FolderB\\Dwld…   \\dhSQLite-Demo\\NWind.db" ;    //>  your Path here
var finddb = FileExists( " D:\\FolderA\\FolderB\\Dwld…   \\dhSQLite-Demo\\NWind.db ")  ;
testnwdb = finddb  ;  // returns "1"  if true, does exist
//
var SQLi1DB = new Database("DSN=SQLite3 ADatasource;")  ;  //> DSN EQ whateverYOUnameit.
var numreks = null ;       //> optional (as are many of the testvar statements)
var Recors_Prods1 = SQLi1DB.ExecuteSQL("SELECT ProductID,ProductName,SupplierID, ReorderLevel FROM 'Products' WHERE ProductID>12;" ) ;
//
   while ( Recors_Prods1.ProductID <55) {
     testRecP = Recors_Prods1.ProductID ;
     testRecP2 = Recors_Prods1.ProductName;
     testRecP3 = "Product values test:  " + Recors_Prods1.ProductName;
     wait(2)
     Recors_Prods1.NextRecord()
   }
var dbConn = SQLi1DB.Connect() ;
testconnect = dbConn + "  and   "+ testRecP ;    //> will display ‘true    and     true’    if succeed connection (displays after while loop)
//
}   //end:  function doingnwindDB3()
//
//  Note 1:  The DSN expression does not seem critical (how it is written), but does need proper setup
//           through Control Panel >>> Admin...Tools >>> ...ODBC
//  Note 2:  Variables here with 'test...' name are non-persistent Page Vars
//                 testnwdb      testRecP      testRecP2     testRecP3      testconnect
//  Note 3:  I have 'trial & errored' many settings.
//           I think Opus Publ Properties >>> Database tab:  Removing extraneous 'Data Sources'
//           and clearing 'Users' and 'passwords' may have helped.
//  Note 4:  I used the FireFox plugin, SQLite Manager, to view the nwind.db sample database and
//           get the table/column names right. Also, generated the SQL query there, saw the results...
//           Copied the SQL statement
//           Closed that plugin (closing the connection to the DB)
//           Pasted the SQL statement into Opus Script, inside the " ;" marks.
//  Note:    sqliteodbc  is from Chris Werner // dhSQLite3 is from www.thecommon.net (datenhaus)
//

int32Success = sqlite3_open(strZeroterminatedPath, int32DBHdl)
// and later...
int32Success = sqlite3_close(int32DBHdl)

function dowithoutODBC()
{
var int32Success = 99 ;
test1 = "entered func do_without" ;
var MyDLL = LoadDLL( SYSTEM_PUBLICATION_DIR +"Resource\\"+ "sqlite3.dll" );
test2 = MyDLL ;
   if ( MyDLL )
   {
   int32Success = MyDLL.CallFn(SYSTEM_PUBLICATION_DIR +"Resource\\","sqlite3_open","int32DBHdl",int32Success);  // just a guess how this might work
   test3 = int32Success  ;
   }  //end if
} //end func dowithoutODBC
//
//  the test1,2,3  are Page Vars to display results.
//  the sqlite3.dll  file was added via Publication Properties, and does exist in the Resource folder
//