Robert,
You have many ways to keep track of any updates using the form,
including which Object, Field, UserName, UserID, NetUser,
UserDomain and the specific computer where the change was made.
So here are your options ...
01. To know the FOCUS on exact object in the form, such as,
Editable Field (Column/Variable), Combo Box, Check Box,
Radio Button or Push Button:
Use (ISTAT(Form_Control_Type))
Example:
SET VAR vControlType = (ISTAT(Form_Control_Type))
Results:
0 = No current control
1 = Editable Field (Column/Variable)
2 = Combo Box
3 = Check Box
5 = Radio Button
7 = Push Button
02. To know whether a change has been made to the data:
Use (ISTAT(Form_Dirty_Flag))
Example:
SET VAR vChanged = (ISTAT(Form_Dirty_Flag))
Results:
0 = No change has been made to the data
1 = Change been made to the data
03. To know who made any change using the NAME parameter in
RBASE.CFG configuration file as defined in RBASE.INI file:
Use (CVAL('NAME'))
Example:
SET VAR vCFGName = (ISTAT('Name'))
Result: Exact name defined in RBASE.CFG or overwritten by
using the SET NAME command.
04. To know the EXACT name of Windows User ID:
Use (CVAL('UserID')) -- 6.5++ for Windows Only
Example:
SET VAR vUserID = (CVAL('UserID'))
Result: Windows User ID
05. To know the EXACT name of the User_Login_Name in a Multi_User
Network Environment:
Use (CVAL('NetUser')) -- 6.5++ for Windows Only
Example:
SET VAR vNetUser = (CVAL('NetUser'))
Result: Currently logged-in network user name, regardless of
which computer and domain.
Very useful and powerful function for tracking/security reasons
when a person moves around from desk to desk, building to building
or domain to domain and accessing the commonly used R:BASE 6.5++
database on the network!
Examples:
Small/Big Corporations, Federal Government, Educational and
State-Wide Network Systems using R:BASE 2000 (version 6.5++)
for Windows!
06. To know the EXACT domain in a Multi-Domain Environment:
Use: (CVAL('UserDomain')) -- 6.5++ for Windows Only
Example: SET VAR vUserDomain = (CVAL('UserDomain'))
Result: Name of logged-in network domain
Also very useful for tracking/security reasons.
07. To know the EXACT computer name:
Use: (CVAL('Computer')) -- 6.5++ for Windows Only
Example:
SET VAR vComputer = (CVAL('Computer'))
Result: Name of computer used
08. Last, but not least, you can put any or all of the above
options in an ENHANCED Stored Procedures and Triggers
using The Glorious R:BASE 2000 (version 6.5++) for
Windows.
There you have it, Robert.
Now you can Run R:BASE Your Way!
Very Best Regards,
Razzak.
At 03:06 AM 9/8/01 -0400, Robert Vincent wrote:
>>>>
Is there an Rbase environment variable that can be checked from within an .EEP that can tell me if the form has received any updates? (R:base 6.5+ Build 1,839) I found myself in a "catch-22" when trying to implement a simple routine to track who was the last logged-in user of the database who performed an "update" of a row thru a form. The customer wanted to find the user(s) who were not following the correct data-entry procedure. However, after "they" exited the form I was setting "them" to be the last user (thus circumventing the whole routine for checking!). Ideally, once the form is invoked, it should be able to be viewed, and as long as no column is updated (via the keyboard/mouse) the previously listed user in that row should remain untouched. If the user should happen to perform any keyboard/mouse update on a column/radio-button/chkbox, etc... the flag can be checked in thie .EEP and determine if the currently logged in user should be "updated" in the row. TIA Rob Vincent R.A.V. Enteprises Dearborn Heights, Michigan
===================================-============================
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
