Thank you, Javier,
this code will come very handy...
Best regards,
Luc D.
----- Original Message -----
From: Javier Valencia
To: RBASE-L Mailing List
Sent: Thursday, November 04, 2010 4:50 PM
Subject: [RBASE-L] - re: automatically running an application
Luc,
The application I run is a compiled R:Base application. However, if you do
not have the compiler, you can use the line command to start the application.
The command file that I use s as follows:
======================
-- Set Basic Settings
SET MESSAGES OFF
SET ERROR MESSAGES OFF
SET QUOTES=NULL
SET QUOTES='
SET DELIMIT=NULL
SET DELIMIT=','
SET LINEEND=NULL
SET LINEEND='^'
SET SEMI=NULL
SET SEMI=';'
SET PLUS=NULL
SET PLUS='+'
SET SINGLE=NULL
SET SINGLE='_'
SET MANY=NULL
SET MANY='%'
SET IDQUOTES=NULL
SET IDQUOTES='`'
SET CURRENCY '$' PREF 2 B
DISCONNECT
-- This are new settings
SET STATICDB ON
SET FASTLOCK ON
SET QUALCOLS 2
--These are old settings
-- SET STATICDB OFF
-- SET FASTLOCK OFF
SET ROWLOCKS ON
SET FEEDBACK OFF
-- This section sets up the scratch files...
SET SCRATCH TMP
-- Loading Application parameters
PROPERTY LOADWINDOW CAPTION 'Loading Road and Asset Management System...'
PROPERTY LOADWINDOW TITLE 'Please Wait...'
PROPERTY LOADWINDOW PROGRESS 100
-- Start Database
IF(CVAL('DATABASE')) <> 'PMSDB' OR (CVAL('DATABASE')) IS NULL THEN
CONNECT PMSDB IDENTIFIED BY XXXXXXXXXXX
ENDIF
-- Enforce Default Settings
SET QUOTES='
SET DELIMIT=','
SET LINEEND='รพ'
SET SEMI=';'
SET PLUS='+'
SET SINGLE='_'
SET MANY='%'
SET IDQUOTES='`'
SET CURRENCY '$' PREF 2 B
SET NULL '-0-'
SET ZERO ON
SET DATE FORMAT MM/DD/YYYY
SET DATE SEQUENCE MMDDYY
SET DATE YEAR 30
SET DATE CENTURY 19
-- The following line runs a form that executes code to loads the fuel
records and exits without any user interaction
EDIT USING fuel_auto_load
DISC
EXIT
RETURN
======================
The fuel_auto_log form displays status messages throughout the process and
exits automatically without user intervention; it has the following code on the
After Start EEP:
======================
*(
auto_load_fuel.asc - This file auto-loads the daily fuel data from
the fuel management system and updates odometer and last date
Written by : Javier Valencia
Date: 03/06/2003
Updated: 07/15/2004
Modified for 9.0 8/10/2010
)
DEBUG SET TRACE ON
SET MESSAGES OFF
SET ERROR MESSAGES OFF
SET ERROR VARIABLE vderr
-- All the processing code and status messages go here.
PAUSE FOR 1 USING 'UPDATING SCREEN' +
CAPTION 'PROCESS PROGRESS...' icon attention
LABEL done
CLS
CLOSEWINDOW
RETURN
======================
As Dennis indicated, you can run also all the code above from the command
line.
Javier,
Javier Valencia, PE
913-829-0888 Office
913-915-3137 Cell
913-649-2904 Fax
[email protected]
------------------------------------------------------------------------------
From: [email protected] [mailto:[email protected]] On Behalf Of Luc Delcoigne
Sent: Thursday, November 04, 2010 3:07 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - re: automatically running an application
Javier,
I am aware of the Windows Scheduler....I use it now to run the same program
in Access.
But in Access you have a property called 'Autorun' which allows you to
automatically run a form and the attached macro when access is started.
Is there a similar feature in R:base ?
Luc D.
----- Original Message -----
From: Javier Valencia
To: RBASE-L Mailing List
Sent: Thursday, November 04, 2010 8:36 AM
Subject: [RBASE-L] - re: automatically running an application
Luc,
I have an application that runs every night to upload fuel records; I use
the Windows Scheduler. You can access it at Control Panel>>Scheduled Tasks; it
is pretty simple to setup. Make sure that the User ID you assign has a password.
Javier,
Javier Valencia, PE
913-829-0888 Office
913-915-3137 Cell
913-649-2904 Fax
[email protected]
----------------------------------------------------------------------------
From: [email protected] [mailto:[email protected]] On Behalf Of Luc
Delcoigne
Sent: Thursday, November 04, 2010 2:19 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - re: automatically running an application
I have to automatically run a program in Rbase that retrieves data and
writes them to a another PC in the network on a specific time each day of the
week.
How can I do that automatically ?
Luc D.
