Dear R:Base Folks


On behalf of Bill Downall, Sami Aaron and myself, I send our overdue but not
less sincere thanks to everyone who helped us make the October conference a
great success  in every way:



*  We raised over $1600 for Project Bundle Up, doubled by Razzak’s generous
donation

*   We heard from a wide variety of developers, users and R:Base staff and
got a wealth of new information (see summary below). Especially great were
all the people presenting for the first time!!

*  We had full cooperation from everyone, generous offers of help and
volunteers whenever we needed them to make being an MC a painless and fun
experience!

*   We were able to express our sincere thanks and appreciation in concrete
terms to Razzak and the entire RBTI team for the wonderful tools we have
been given and their incomparable responsiveness to us.  Thanks to Claudine
Robbins and Adriana Montano, we gave lovely gifts to all of them and a huge
card signed by everyone at the conference!



Those who attended, feel free to add more to my notes!



SUMMARY OF CONFERENCE PRESENTATIONS:



SATURDAY OCTOBER 23



NEW PRODUCT: R:BASE 7.5, Part I – RAZZAK



Razzak demonstrated 7.5 in several parts.  Several of the key new features
will be:



Explorer – right click and show hints under icons or hide icons

Multiple Language options available

Browser:  if you mouse over a note field the whole text is shown

            Enter works to move in browser



Forms

            New Caption Toolbar options

Tabs that are not relevant (no data for those tables) can be suppressed This
is a new PROPERTY command feature

Themes – totally different look and feel without changing the form –
R:Themes – 30 bundled in – will most likely be add on product, though there
was discussion about including it with R:Base instead



Reports

            Pause box is build into the report:

New Report “EEPS” – programs that will run on start, after start a report:
for
example, a custom PAUSE on screen while the report is building – SEE BILL
DOWNALL PRESENTATION BELOW

Report generated with PDF can have password with it – can be case sensitive

-         Low level – view only

-         High level – can print, copy etc.

Table of contents in PDF generated report!! – Bookmarks!

Generate report in HTML, XHTML and table of contents works the same way





There will be a fee to upgrade to 7.5



Any registered user can request to be a beta tester





REMOTE CONNECTIVITY – ALEXEI NICOLINI



Alexei demonstrated LIVE a dazzling Pocket PC application linking directly
to a server with Terminal Services client.



Terminal services Client faster with 256 colors



TSC comes with Pocket PC 2003

NO programming for Pocket PC needed



He recommended Pocket PC with integrated Bluetooth

Pick PC w/ Integrated Wi-Fi



Advantages:



Processing occurs on the server side

No limit to memory



Disadvantages:



Must be connected to LAN or internet



Form size on the Pocket PC is 220 x 267



Nicolai demonstrated again his powerful utility SENDFILE.EXE that makes
sending / receiving files “idiot proof” for users.  It can be used from
within R:Base simply with:



LAUNCH Sendfile.exe renew – simple R:Base command

 - looks for file RENEW.TXT in install directory -





LOOK WHAT I’VE DONE WITH R:BASE– MARK KWOKA – “Vera Wang Runs on R:Base”



Mark demonstrated a beautiful, elegant R:Base 7.1 application using bar
coding and simple, easy to use yet attractive R:Base forms. The application
was created for one of the world’s best known creators of custom wedding
gowns.



DESIGNING DYNAMIC SEARCH OPTIONS IN R:BASE: Razzak



The sample form on the CD is Form SearchCriteria in RRBYW10



This elegant example showed a form with 4 radio buttons:  For each radio
button that you want to search by, PROPERTY command displays the correct
control and hides the others, based on an “on click” EEP for the radio
button.



Razzak demonstrated how to set this up.  Useful tips included:



Action from menu – internal eep sets up vars needed



On after start – variables set to null, and set visible PROPERTY to false
for ALL controls



To avoid flashing when the form opens: PROPERTY WIDTH 0 AS LAST STEP when
creating the form – after everything is set up and working correctly



Once this is done, you can still edit the form using the menu to display all
controls and then edit as needed.



THE ON CLICK EEP for the radio button just makes the various controls
visible / not visible:



The “Search” Button on the form does the work of each option



TO use the form, sequence is:



Click radio button selection – the correct control comes up

Fill in what the search asks for

Click on Search



I noticed an interesting change in programming style:  define vars for the
form in the BEFORE START EEP, not in the code calling the form.


The Component ID:  will have no limit in # characters in 7.5





CREATING A CONSISTENT VISUAL INTERFACE – EMMITT DOVE - BLUE RIDGE PAPER
COMPANY



Emmitt shared some excellent tips on how to do this and demonstrated his
beautiful results:



The Hard way – set color / font properties of every form

Easy way – Use Themes in RBASE 7.5



Preparation:



Conceptualize the visual theme – look at established graphical identity

            Web site

            Stationary



            Emmitt used the company logo as a background for EVERY screen



Prepare some samples and show to your users – involve marketing, graphics
design department



Start with form with most of the object types you will use

Get colors set to your satisfaction

Add to custom colors if you create one

Add each object type to a “toolbox” form

Use cut and paste copy controls from this custom form to the one now being
developed!!



Tool box:



Create a program with templates for each of your commands (PAUSE / DIALOG /
CHOOSE)  Call it 0.0; in RBEDIT set up to list all files and then this will
always the first in the list

He sets up forms with objects having GENERIC Captions – then he uses
PROPERTY to assign caption values



Use a standard background on all forms



Emmitt created ONE form with a standard background – matching the background
of main menu

One AMAZING example was a ONE TIME ON entry to row EEP for this form which
creates a command to RUN the parameter sent it – executes it and then
CLOSEWINDOW – all controlled from the form! IN other words, this ONE form
serves as a background for ALL programs in the application and the EEP
starts ALL menu choices. You have to see the sample on the  CD to full
appreciate how elegant and simple this is!



Old way of getting standards:



More work – pay attention to all details

BUT – you have complete control over the application



New way: R:Themes:



Less work

But you can’t control all controls

Still must deal with standards for CHOOSE, PAUSE, DIALOG



A BEAUTIFUL APPLICATION!





NEW PRODUCT: R:THEMES: RAZZAK



Is add on product with DLL



If you have it installed, when you open FORM PROPERTIES get a new tab for
THEME and select one of the 30 themes



Controls the look and feel of:



Title bar at top

Bit Button

Combo Box

DBNavigator

Many more!



What doesn’t it change?



Test by put all controls on a form!



If you put a custom color on a button it is overridden by the theme; if you
have an image on the button and don’t want the old color to show around it –
make it transparent



Must apply themes to ONE form at a time



RBTI will help you create a new theme if you want one

See sample on CD to run and look at all 30 to decide the look and feel



IF YOU design forms with R:Themes – customer must also have R:Themes



If you  buy Runtime / R:Compiler it DOES have unlimited use





NEW PRODUCT: R:SCRIPTER FOR R:BASE 7.1 MIKE BYERLY:



This is a new Plugin for R:Base that allows you to store other language
scripts right in R:Base and run the code with a simple PLUGIN command.



Mike’s example on the CD shows:



Plugin:  For Pascal Script, VB Script, J Script

Source code stored as VARCHAR data in database in his sample

Samples:

            Filesize of text fle

            Number lines in text file

            Current network drive

            API Message box:

            Multi function call – simple example of multiple functions

            StringList – add item to string list and retrieve it – in
background of list boxes in
Test timeout
Get URL currently up in explorer into R:Base
Starts Word and opens a file – could modify to open multiple documents at
once! – (you would have to modify his code)
API GetUtil – generates code as point to part of screen



You’ll have to take apart his table structure, eeps, and sample form on the
CD to follow examples of plugin code he’s building





NEW PRODUCT: R:SCOPE 7.5 FOR WINDOWS: JOHN MINYO



R:Scope was originally created 1990.   Every version has been in DOS until
now



This new version will work with 6.5 and higher



Besides the obvious advantages of a Windows interface, some of the nice new
features include:



*  Printer set up for error log



*   New View Data options



*  You can open in multi-user mode – you can’t do all fixes but you can look
at the data



*   In manual row can click on “VIEW DATA” and see the actual row





NEW FEATURE IN NEW PRODUCT:  SUB-REPORTS IN R:BASE 7.5 – BILL DOWNALL



When you create a report with a sub-report, R:Base displays tabs at the
bottom of screen for main and sub reports



There is now a new Tables – Add/remove table option in the menu, so one
report can be based on table x, and the sub-report on table y



IN the past, a ONE TO MANY report showing, for example, All customers, inclu
ding those with contacts and without them would have required setting up an
outer join between the Customer and Contacts tables and then basing the
report on this outer join.  SUB REPORTS MEAN THIS IS NO LONGER NECESSARY



You can set up the main and sub-reports in a region to permit the main and
sub-report data to stretch together if needed



How does a sub-report decide which rows to display from the sub-report?
Link of two tables / view is based on common column names and is automatic



How do you sort data in a sub-report?  In the sub-report definition you set
break points



OR to limit rows in sub-report further OR sort, create VIEW to limit the
rows and sort the data, then base that sub-report on the view



Four New Report / Actions:



Examples of how to use them:



Before Preview – Predefine vars defined; preset page number;  if vars built
into view, define the variables for the  views here

After Preview – clear the vars?

Before Generate – a PAUSE 3 to say it’s preparing

After Generate – a CLS to get PAUSE 3 off when it’s all built



These actions are available ONLY on the master report



IN another example Bill showed us, with contacts and invoices – if there ARE
invoices, it prints them, if NOT NOTHING prints  - so NO outer join is
needed and NOTHING prints if are none – no headers, no nothing!  This is
BETTER than the old way and lots simpler!



SUB REPORTS CAN HAVE SUB REPORTS



WATCH OUT:



Don’t use same variable name in main and subs



In the example on the CD with CUSTOMER, CONTACTS, TransMaster, TransDetails
to have proper sub reports, Contacts and Transactions have CustID so they
are subs of main, Transdetail does NOT so it has to be a sub of the
TransMaster sub-report – this also allows NO header for main or details if
are NOT transactions



FORMS DOCUMENTATION: SAMI AARON:



This requires setting up some new tables to document your forms, and, for
now, requires MANUAL entry as you create your application, of the
documentation.



Sami showed a very complicated form with a US map: the user could click on a
state and get data about airports for that state



The new tables are: SMS_Forms and SMS_FormsDetails



Sami’s Install file on the CD puts theses tables and all views, reports,
forms you’re your database



To use you must:



Add tables, etc to database

Have 2 copies of RBase open, one in design, one in her sms_forms form and
add a row for each control as you develop or document.





RBASE 7.5 PART II:  RAZZAK



The new PDF options are all through a huge list  of new OPTIONS in the PRINT
command under OPTION PDF



To see the example on the CD, IN RRBYW10 –select Reports / Secure PDF
Reports with TOC



Some of the new options include:



OWNER_Password (can print, etc) – overrides the limitations set by ENABLE
options below

USER_Password (user can view only)

ENCRYPT_FILE ON – ask for password

ENCRYTION_LEVEL 128BIT (lower case / upper case included in the password)

GENERATE_TOC ON – a table of contents shows up on the left side of document
in Adobe if you click on BOOKMARKS tab to the left – makes fast navigating
of the document possible (I look forward to this in the new R:DOCS!!!)

ENABLE_PRINTING ON/OFF

ENABLE_COPYING ON/OFF

ENABLE_MODIFYING ON/OFF

(His samples on the CD show options in alpha order but they don’t have to
be)

PRESENTATION_MODE ON/NONE – if on, need more time to display

USE_COMPRESSION ON

PAGE_LAYOUT_SINGLE_PAGE (or comes up with icons per page)



These show in Document Summary option in Adobe



TITLE

SUBJECT

AUTHOR

KEYWORDS



THE AMAZING SELECT COMMAND: DAVID BLOCKER



I demonstrated the basics of SELECT using the SELDEMO.RMD program on the CD,
and then demonstrated several interested and unusual multi- table joins and
the advantages of each:



SELF – JOINS:  joining a table to itself. Examples included:



Simple bill of materials and more complex bill of materials

A “ranked list”: showing clients in order by amount of total sales,
including a “ranking” number, all with one SELECT



CARTESIAN PRODUCTS:   deliberately joining  ALL rows in table with ALL rows
in another:



Samples included:



A “partial” cartesian product allowing a report showing the contribution of
each actor to a film’s sales

Getting around a “Cursor” lock on a table when all you’re doing is using the
cursor to read data, not change it.

Printing multiple copies of the same mailing label, grouping the same labels
together





SUNDAY OCTOBER 24, 2003:



UNDERSTANDING AND EDITING THE SYS_FORMS3 TABLE – ALEXEI CHUYASOV:



To see what’s really stored in the table:



Browse all from sys_forms3

Double click on the SYS_DATA column!



Object oriented conception : Each object is displayed in a tree structure



For each component:

Object

  Properties

End



Very careful about editing this table to mess up the “end”

My idea: could we  load this data into a table with one row per line in text
and use it to document a form?



CAN EDIT AN OBJECT IN AN AMAZING WAY!

-         point to it in forms designer

-         Ctrl X

-         Paste into notepad

-         Edit it

-         Copy it

-         Paste onto the form

-         The changed object will appear on the from in the right spot!



WARNING:  If you are editing the sys_forms3 table the form should NOT be
open in the designer









JOB APP NETWORK:  RANDY MORROW, RINART PEPA



This was a demonstration of a remarkable 6.5++ application.  Randy and
Rinart run their ENTIRE company off R:Base: their clients set up automated
Job applications: applicants, apply, have interviews, etc. all over the
phone, all run automatically by R:Base, with R:Base storing the
conversations and answers in full!



Interactive Voice Data and Facts:  “The Future of Hiring”



They plan to set out a huge number “take a number” containers (like you see
at a supermarket deli-counter) all over nationally to advertise this service



People call in for job openings with their clients – R:Base is behind
scenes – handling hundreds of thousands of calls

Automated voice mail



THIS IS AN AMAZING EXAMPLE OF aN APPLICATION  HANDLING NATIONWIDE PHONE CALL
24 hours a day stored in huge dATAbASE!







CUSTOMIZED QUICK REFERENCE FORMS: Charlie Parks:



There’s no way to describe this – you have to see it to believe it and
understand it!!   ********* LOOK AT THIS ON THE CD!



Among other things, Charlie  opened our eyes to a great feature on 7.x
forms: “CUSTOM FORM ACTION”.  You find this under– Layout / Custom Form
Action; you set up code that can be  executed many times in one form with a
PROPERTY command!





ELECTRONIC VOTING: BERNIE LIS:



Bernie took us into the wonderland of a WHAT IF R:Base was used to set up a
nationwide voting system application; in the process he launched his
campaign for President and shared some truly disgraceful jokes!





R:WEB SUITE:  RAZZAK AND RAFEE:



Razzak and Rafee gave yet another great demonstration of a all the terrific
things you can do with PHP and R:WEB SUITE.



This included a good example of a table to track all who log in (IP
addresss, server from,  report printed), etc.



What does your service provider need to run a web site developed with R:WEB
SUITE? Not much!    All have PHP,  1AND1.COM is an example of who can host
it,  the provide 124 gig server access  $29 per month





BUILDING A SCHEDULE USING R:BASE PROPERTIES:  DAVID KOS – BLUE RIDGE PAPER
COMPANY



David showed a great example of how he built a calendar scheduling
application using a Gantt Chart style display



Behind it all were:



Variable Edit Controls showing  jobs, tasks related to a job



Enhanced Panel Control to contain Job shifts or time intervals



Hints to provide job or general information



Pop-up forms = schedule cards or detail task info



To look at it need 1200 dpi pixel setting to see full form at once on screen



He showed a BIG block of code that runs on entry to the form that sets
properties for each of the schedule blocks – setting top, sizes, colors of
each job block to show it in the proper position on the form.





NEW PRODUCT:  R:FAX:  ALEXEI CHUYASOV:



This is a plug in to send faxes from R:Base



It includes:



Options to view the file

Options to include cover page

Pages can be text, PIFF, JPG

It assumes you have  a modem and phone line – this assumes THAT way of
sending faxes





NEW PRODUCT: TURBO R:BASE 8.0 – A WORK IN PROGRESS – WAYNE ERICKSON R:BASE
V-8 TURBO



Wayne demonstrated this very close to ready for prime time product!

Features include:



Large file sizes

Long column/ table / names



SET NAMEWIDTH command which controls the length of the display on LIST
commands



Row size now 4k – may be longer



Filenames will be rX1 to  rX4



Wayne showed a database with #2 file 3.4 gig



Expression size limit may increase from 240 to 1000



Steve Sweeney demonstrated a LIVE Hewlett Packard account which actually
using Turbo R:Base 8.0  - #2 file 4.3 gig



He showed a table with 3 million rows of data and did a  sample select group
by command with very fast results



There could be possible new data types such as Boolean





NEW PRODUCT: RBZIP: ALEXEI CHUYASOV



Another plugin!  Plugin rbzip-rbl



Option:  show_dialog  - this indicates where to create the zip file in an
interactive mode – with a very friendly interface



Can be used to compress or uncompress files



See SampleRBZip.RMD



Files created can be read by WinZip, etc.





REPORTS: MERGE DATA AND USE OF REGIONS – CLAUDINE ROBBINS



Claudine demonstrated a complex contract form that, with Razzak’s help, she
was able to create using R:Base 7.



She used to use Extended Report Writer to do it.  Starting in versions 4.5
and 4.5++, she  ran into limitations and resorted to using data file
exported to Word Star and later MS Word to create the contracts, a real
productivity loss.  Now she can do it in R:Base!



Most of the document is boiler plate, but some of it must be at the end
(unique ID)



On her data entry form there are 12 possible boiler plate paragraphs to
include in the contract.  All she has to do know is check off what applies
and it’s included in the contract.



This is accomplished by a program which builds all the long text strings
needed, paragraphs, etc., load them  into a temp table and the report runs
off that table.



She talked about a problem she had with successive DB memo objects one above
the other.  Here’s how to get them to expand correctly:



Text1         DBMemo1



Text2        DBMemo2



Text3        DBMemo3



Solution:



*  Region1 is around text1 and dbmemo1

*  Region2 is around text2 and dbmemo2 and the REGION shifts relative to
DBMemo1

*  Region3 is around text3 and dbmemo3  and the REGION shifts relative to
DBMemo2





NEW PRODUCT:  R:ARCHIVE: RAZZAK



This product is an R:Base application than can be used to manage document
scanning



Menu options in the product:



Select Session Folder(s):  Define directory for the current scanning
session, define prefix for all files to be scanned in this session  - gives
default and you can change either or both  - files will be named
prefix_00000000.jpg, prefix_00000001.jpg, etc.

Scan Document Automatic:  Scanner is hooked up to PC, user clicks “Scan
Document” and the program sends commands to the scanner to scan and the
database stores – Doc Id, date, time, user (from network ID) and the doc
name given.  The  user can then type in the title and notes and can view the
doc: the image is a standalone JPG file on the drive in the directory you
defined for that session.  The application stores the full path /directory
name \filename in the database

Scan Document Manual:    This allows you, for example, to scan the document,
then bring it up for editing, select out just part of it and store THAT as
the image!



This is NOT on conference CD



Includes an option to change the driver to use so you can use different
equipment – including a digital camera!!



You can change resolution (DPI) x and y, colors, output format, and whether
or not to show the user interface



It’s all an R:Base application – we can change as we need to!



Once you buy this, you can use it on our own, include it in another
application,  RCompile it and end up with an EXE to send out!





CONVERTING 7.1 /5 DATABASES TO R:BASE V-8 TURBO: RAZZAK



In 7.1:



SET NULL -0-

OUTPUT dbname.STR

UNLOAD ALL

OUTPUT SCREEN



Creates STR and LOB file



In R:Base V-8 Turbo:



RUN dbname.STR



There you go!





CREATING CUSTOM HELP SCREENS: RAZZAK



He uses a product to create them – it is available at  www.helpandmanual.com



This creates files CHM – the actual help file and  HM3 – the designer file



*   Collect your image files needed (jpg files)

*  Very easy to create the tree of topics (table contents on the left) –
then compile it



Automatically gives you



*  table of contents

*  search option



To run from R:Base – just LAUNCH xxxx.chm







SETTING UP  A FORM TEMPLATE:  CHARLIE PARKS



Charlie demonstrated a simple and powerful technique to create forms
quickly.



He created a sample standard form with, for example:



Enhanced panel

Topic on top

Add tab page

Add right hand panel for buttons, include splitter if want

Add boxes to right panel to provide background for buttons



The result is a “master form” with all his standard images on it – click and
copy from it to start new forms.



This is a basic standard form – just copy to new name and table and off you
go!





NEW PRODUCT:  R:MAIL 2.5: JOHN MINYO



Internally at RBTI they have an in-house application called R:WYWO (phone
message management system)



Sample app is on conference CD



New front end



It takes advantage of these new features in R:Mail 2.5



*  Create Receipt

*  Lets you know if email could be sent or not

*  Saves authentication to log file



To use this application:



Copy the CD files and startup files to a network directory

Create a Shortcut for 7.1 with RWYWO.DAT as the startup file





PROGRAMMABLE CALENDAR IN R:BASE – VICTOR TIMMONS:



Victor created a Calendar and scheduler application in R:Base 7.1 and is
sharing it with us on the conference CD!



Very slick use of forms and properties to do scheduling

If you get this, notice in particular his idea of having an address in the
application and turning it into a Map Quest request for directions to that
address!!!







NEW PRODUCT:  R:JAVA:  ALEXEI CHUYASOV



This is not real R:Java but an ODBC connector



The product is a DLL that permits connecting Java code to an R:Base back end



Done and ready to ship





PRODUCT DESCRIPTION:  RCOMPILER:  RAZZAK



You can make your own icon, your own company name, etc.



R:Compiler normally expects an RBA but you replace instead with an RMD
instead! (This creates a standalone file IF ALL programs are stored in
forms)



Your application can build graphs  with R:Charts – can distribute those too
if  you include RCHARTS.DLL with what you ship





ODBC:  RAZZAK:



Razzak demonstrated an  attempt to get into R:Base FROM Access. His point
was that the Oterro driver works better than the usual R:Base ODBC driver





MONDAY, OCTOBER 25, 2004



AUTOMATED BACKUP / PACK / RELOAD ROUTINES FOR R:BASE 7.1: DAVID BLOCKER



I demonstrated a standard set of programs that will work on ANY database to
perform these 3 critical functions from an R:Base application.   All are
based on a standard set of code and all have extensive error trapping to be
sure every step works before you go on the next one.



I demonstratead 3 alternative methods of  keeping  a background screen up
during the process, since an R:Base form cannot normally remain on screen
during the backup.



Method 1: Use a program I got from Mike Byerly to create a background screen

Method 2: Use the Application designer, not a form, to create your main menu

Method 3: LAUNCH another session of R:Base that displays a screen that looks
like your main menu form but is actually from another database; files
created by the backup programs are used to signal the other application when
it can close.



The first two methods are fully available and documented on the conference
CD.  The third was based on an idea from Emmitt Dove at the conference and
was written there. It is NOT on the conference CD. Contact David privately
if you’d the files.





DAWN OAKES – RAPID CONVERSION TO 7.5+:



Heinrich Ceramic Decal, Inc.



Dawn demonstrated an elaborate system to use of hazardous raw materials such
as lead in her company which creates customized ceramic products (Mugs,
plates, etc.)



What did she do to convert rapidly from 6.5++?  She did NOT add bells and
whistles and just converted



They also developed a method of getting histogram data from a Mac
application to R:Base





EXPANDING THE CAPABILITIES OF R:WEB SUITE:  DALE THOMAS



R:Web suite is great, but sooner or later you’ll need to learn PHP.



You can do simple applications fast with R:Web suite.



But then you will run into things that are way over your head: normally you’
ll  contract these out



Then there are those in the middle: ;these were the focus of his
presentation.  He demonstrated and includes in his conference CD files:



*  Using Styles: control look and feel of entire application / site by doing
it at one site

*  All info about your PHP installation – system vars, etc – are available
with one command: PHPINFO

*  Doing ODBC queries

Odbc_result_all  command: – this is for debugging purposes – it throws
everything from the query into a table (file ODBC_RES.PHP) – this is VERY
powerful and simple example to look at

*  CLOCK.HTM – a clock that moves around with your mouse!

*  EMAIL.PHP – sending emails using PHP

*  CALENDAR.PHP – a calendar



Resources to learn PHP:



*   BOOK – Poor’s PHP Programming by Atkinson

*   WEB site – www.php.net





RBG7 REPORT QUEUE – CALLING RBG7 REPORTS FROM ANYWHERE – STEVE SWEENEY



In the past, Steve and others had to build a seperate report in 6.5++ then
again from scratch in a web design tool to get the report printed from the
web.



NOW  - can call report produced by v7 anywhere on web



WEB: inserts row into a table with report to print, where clause, order by



In his example created for HP, there are three workstations than run an
application all the time looking for a row in that table



The REP_QUE table includes the report name, where,  order by and workstation
ID that claims the request



The application:



Locks the table – looks for row with report but no filename and location



Prints the report creating file name, posts to the row the workstation id
producing it, filename created, etc.



WEB application looks for that  row and then shows that file at that server
location – the report!



A HUGE time and money saver for your clients!



IMPLEMENTING A FLEET MANAGEMENT SYSTEM: JAVIER VALENCIA



Javier demonstrated a comprehensive and elegant system for maintaining a
large number of vehicles for a department of public works.



David Blocker
[EMAIL PROTECTED]
781-784-1919
Fax: 781-784-1860
Cell: 339-206-0261

--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [EMAIL PROTECTED]

(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: 
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, 
place any 
text to search for.
================================================

Reply via email to