* name of my ODBC connection lcOdbcConnection = 'Test_QRM_Assistant' * make connection to sql server using ODBC connection defined using * windows authentication (so no need to speciy password) lnHandle = SQLCONNECT(lcOdbcConnection) IF lnHandle <= 0 =MESSAGEBOX('Unable to connect to &lcOdbcConnection ODBC connection.') RETURN ENDIF * retrive the DirectoriesToProcess table from the remote * extractorcontrol database and place the result in a local * cursor called temp lcCommand = 'select * from extractorcontrol..DirectoriesToProcess' lnOK = SQLEXEC(lnHandle,lcCommand, 'temp') IF lnOK != 1 =MESSAGEBOX('Error retrieving data!') RETURN ENDIF * disconnect = SQLDISCONNECT(lnHandle)