Login
`
Templates, Tools and Utilities
|
||
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: Substitute locator 2002-02-10 -- Chet Sapino > I have a data field in a file that is a string 4 bytes long. However, it
is
> not string data. It is binary data. We normally input it as a string than
> run it through a routine that converts it to binary. When we want to
display
> it we deconvert it from binary to string. So far it is simple.
>
> Now someone want a locator on that field. It is a valid request since the
> field contains an identifier. So I decided to create a dummy string,
convert
> it to binary and stuff it into the locator string, and then do a
> POST(EVENT:Accepted, ?LOC:Goto).
>
> It ---did not--- work. I know that I am triggering the
> BRW1::Sort2:Locator.TakeEvent() and BRW1::Sort2:Locator.Reset(). However,
> the browse still does not locate.
1. Populate the file field on the tab with the locator and hide it. The
locator must be Entry type.
2. Populate a variable on the tab to hold the string for the location.
3. Put a "Find" button on the tab and in the embed, run the variable thru
your routine to convert it to the binary var, and then do an
Access:file.Fetch(byBinaryKey) to get the record by the binary var.
4. Do a BRW1.ResetFromBuffer and it will take the browse to the located
record.
If you don't want to use a "Find" button, you can put the code in the entry
field and execute it with the Tab Key in the Accept .
This also works with multiple fields in a multicomponent key as a locator in
both a Windows app or a Java Free HTML browse. All of the entry fields must
be populated and hidden. Variables for each locator field must be populated.
Enter data in any one of the fields, press the "Find" button which assign
the vars to the key, get the record and reset the browse.
Today is December 3, 2024, 11:53 am This article has been viewed 35221 times.
|
|