At 03:23 AM 1/4/2007, Robert Ainsworth wrote:
Is there a way to use the jump to command or any other command
in a form to have the form go to a specific record in the same
form? Not just jumping to the next 3, next 10 etc. but rather,
jumping to say a record with a prompted for employee number?
Robert,
Use the 'FormTableName->SEARCH->FormColumnName->' varname command
to achieve your goal.
Here's how:
Syntax:
PROPERTY TABLE 'FormTableName->SEARCH->FormColumnName->' varname
Use this option to search for text within a given column of a form
table.
Example 01:
Use the following command as "On DB Grid Cell Click" EEP
-- Begin
SET VAR vSearchString TEXT = NULL
SET VAR vSearchString = +
('PROPERTY TABLE Customer SEARCH->'+.vColumnName+'->'+.vSearchValue)
&vSearchString
RETURN
-- End
Also, is there a way to get the internal record number of a
specific record in a table? That should help to resolve my
first issue, I think?
Use the 'FormTableName->RECNO' varname command to achieve that goal.
Syntax:
GETPROPERTY TABLE 'FormTableName->RECNO' varname
Use this option to retrieve the record number of selected/focused
record in the form.
Example 01:
-- Begin
CLEAR VAR vRecNo
SET VAR vRecNo TEXT = NULL
GETPROPERTY TABLE 'Customer->RECNO' vRecNo
RETURN
-- End
Variable vRecno will return the record number of selected/focused
record on the form associated with the Customer table.
And, that's all there is to it!
Super Advanced Training (SAT) CD includes a few applications to
demonstrate the use of such features in R:BASE 7.5, 7.6, 7.6 (C/S:I)
and Turbo V-8 for Windows.
2006 9th R:BASE Developers' Conference CD also includes a sample
application to demonstrate the use of "Designing Search Forms using
DBGrid".
Enjoy and make sure to have fun.
Very Best R:egards,
Razzak.
--- 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.
================================================
