Lookup Feature

[Scott Krise]

I am creating a form where the name of a drug is going to be entered into a
field. What I want to be able to do is to set it up so that after the user
enters the first 5 characters, I want to display all the drugs in the master
file that begin with the same 5 characters. As they type each additional
character, I want the list to refresh itself with the new matchs,
etc...until they either click on one of them to accept...or they tab off the
field. I want them to have the option to just keep typing if they want
to...or to select a preexisting drug. (Just like the options available when
typing in an address on a web browser). Has anyone been able to set up
something like this in 5.7? What about Dbase Plus? A snipet of code would be
greatly appreciated if someone has been able to do this.

Thanks,

Scott

[Glenn Fausel]

Post by Scott Krise
I am creating a form where the name of a drug is going to be entered into a
field. What I want to be able to do is to set it up so that after the user
enters the first 5 characters, I want to display all the drugs in the master
file that begin with the same 5 characters. As they type each additional
character, I want the list to refresh itself with the new matchs,
etc...until they either click on one of them to accept...or they tab off the
field. I want them to have the option to just keep typing if they want
to...or to select a preexisting drug. (Just like the options available when
typing in an address on a web browser). Has anyone been able to set up
something like this in 5.7? What about Dbase Plus? A snipet of code would be
greatly appreciated if someone has been able to do this.
Thanks,
Scott

I have done this with a listbox, which is hidden until user starts
typing. First question though, why 5 characters?? What if the drug is
Axid? Nothing wrong with doing all the characters. Mine has the listbox
datasource set to the main file. Then using the onkey function,
something like this, filling in your own data.

drugname_entryfield_onkey
form.drugs1.rowset.setrange(this.value)
return

This will have the listbox data reduced. In my situation, hitting enter
will select the drug that is at the top of the list. The user can also
select is with the mouse from the listbox. When there is NO match,
'enter' allows the user to add a new drug.

HTH

Glenn Fausel

[David Bridger]

Post by Glenn Fausel
drugname_entryfield_onkey
form.drugs1.rowset.setrange(this.value)
return

This is code for Plus not VDB 5.7.

--
David Bridger

[Scott Krise]

Post by Glenn Fausel
I have done this with a listbox, which is hidden until user starts
typing. First question though, why 5 characters??

I guess my thinking here was that if the drug name is only 5
characters...just let them type it...but having it come up automatically as
soon as they start typing wouldn't necessarily be a bad thing.

Post by Glenn Fausel
drugname_entryfield_onkey
form.drugs1.rowset.setrange(this.value)
return
This will have the listbox data reduced. In my situation, hitting enter
will select the drug that is at the top of the list. The user can also
select is with the mouse from the listbox. When there is NO match,
'enter' allows the user to add a new drug.

This could be what I'm looking for. So as you keep typing, the top line will
keep changing to the item that most closely matches what you've typed? I was
playing with the combo box, and it does something like what I am trying to
do, but I don't like that it seems to put the item that matches what you are
typing in the middle of the dropdown screen. Maybe the listbox is the way to
go...I'll give it a try.

Thanks,

Scott

[Glenn Fausel]

Post by Scott Krise
This could be what I'm looking for. So as you keep typing, the top line will
keep changing to the item that most closely matches what you've typed? I was
playing with the combo box, and it does something like what I am trying to
do, but I don't like that it seems to put the item that matches what you are
typing in the middle of the dropdown screen. Maybe the listbox is the way to
go...I'll give it a try.
Thanks,
Scott

You are welcome. I should have mentioned that this is dbplus code, as
the use above commented on.

Glenn

[David Heath]

Sounds like a combo box to me.

David

[Richard Perryman]

Post by Scott Krise
I am creating a form where the name of a drug is going to be entered into a
field. What I want to be able to do is to set it up so that after the user
enters the first 5 characters, I want to display all the drugs in the master
file that begin with the same 5 characters.

Sounds like you might want to try the seeker which is in the dulfp.

Thanks
Richard

[Scott Krise]

Post by Richard Perryman
Sounds like you might want to try the seeker which is in the dulfp.

Sorry...what is the dulfp?

[Richard Perryman]

Post by Scott Krise
Sorry...what is the dulfp?

It a file containing routines and programs, etc... written by various
programmers. The seeker is a field that does an incremental search as the
user types in something. You can download the 16bit dulfp for vdb 5.7 from
dbase.com All kinds of goodies in there.

thanks
Richard

[Scott Krise]

Thanks...I'll check it out.

[Scott Krise]

Post by Richard Perryman
It a file containing routines and programs, etc... written by various
programmers. The seeker is a field that does an incremental search as the
user types in something. You can download the 16bit dulfp for vdb 5.7 from
dbase.com All kinds of goodies in there.

Richard,

Downloaded the 16bit version...unzipped it...and did not find SEEKER. I also
downloaded the 32 bit version and found a seekersql...but no seeker there
either. Might it be somewhere else?

Scott

[Ken Mayer [dBASE, Inc.]]

Post by Scott Krise
Downloaded the 16bit version...unzipped it...and did not find SEEKER. I also
downloaded the 32 bit version and found a seekersql...but no seeker there
either. Might it be somewhere else?

The 32-bit dUFLP doesn't need a "seeker" as it's part of the product,
and is automatically available. The 16-bit version may not have it,
for some reason. Someone out there should have it available for the
16-bit version of dBASE, and they should be able to post it ...

Ken
---
Ken Mayer [dBASE, Inc.]
** Please respond ONLY in the newsgroups **

"Think OOP"

dBASE, Inc. website: http://www.dbase.com

[Richard Perryman]

Post by Scott Krise
Downloaded the 16bit version...unzipped it...and did not find SEEKER. I also
downloaded the 32 bit version and found a seekersql...but no seeker there
either. Might it be somewhere else?

We'll I thought that was where I got it. I'll post my copy in the binaries.

Thanks
Richard

[Rainald Taesler]

Scott Krise <***@penn.com> shared these words of wisdom:

The absolute # 1 Hit in the OE NGs these days ;-)

I have never downloaded an attachment from the binaries before...and
when I try, I get a message from outlook express that says that OE
Removed Access From The Unsafe Attachements in your mail...and it
won't give me access to it.

That's a security feature implemented a while ago with an
upadate/patch.
The setting for attachment now is deactivated by default.
I f one has an anti-virus e-mail-checker installed (a real MUST <!>),
one can switch this deature off.
If no virus protection on your machine, deiable the setting temporarily
for this specific attachment.

I've looked through the options within OE and can't find where
to disable this feature. Anyone know how to get around it?

Since my computer speaks German, I don't have the English wordings of
the settings-dialog. Let me try it:

From the menu:
Extras | Options,
third tabbed page in the upper row "Security",
second CheckBox "Saving and opening of attachments ..." has to
be DISabled.

HTH
Rainald

[Rainald Taesler]

Rainald Taesler <***@gmx.de> shared these words of wisdom:

Sorry, Typo!

Post by Rainald Taesler
The setting for attachment now is deactivated by default.

maust read:

The setting for *opening* attachments now is deactiveated by deafult.

Rainald

[David Heath]

In english, Tools/Options/Security tab. Checkbox -Do not allow
attachments etc.

David

Post by Rainald Taesler
Extras | Options,
third tabbed page in the upper row "Security",
second CheckBox "Saving and opening of attachments ..." has to
be DISabled.

[Rainald Taesler]

Post by David Heath
In english, Tools/Options/Security tab. Checkbox -Do not allow
attachments etc.

Thanks for jumping in and helping out.

Rainald

[David Heath]

Glad to help wise one :)

David

Post by Rainald Taesler
Thanks for jumping in and helping out.

[Rainald Taesler]

Post by David Heath

Post by Rainald Taesler
Thanks for jumping in and helping out.

Glad to help wise one :)

;-)
Not too wise, pretty dumb more often than not /*siigh*/

Rainald

[Scott Krise]

One step forward...two steps back...

Ok..thanks for the info on where to shut off that OE security thing...(this
is the one step forward part)...

But...now when I go into the binaries...the posting is gone! Richard...could
you please post it again.

Thanks!

[Rainald Taesler]

Post by Scott Krise
One step forward...two steps back...
Ok..thanks for the info on where to shut off that OE security
thing...(this is the one step forward part)...

OK, fine.

Post by Scott Krise
But...now when I go into the binaries...the posting is gone!
Richard...could you please post it again.

No need to repost it.
Nothing's gone. The thing is there.

Rainald

[Scott Krise]

Post by Rainald Taesler
No need to repost it.
Nothing's gone. The thing is there.
Rainald

Ok...I did find it now...but it was not listed in the binaries on my system.
For some reason, messages seem to periodically be removed from what I can
see on my system. To be able to see the posting that Richard made...I had to
unsubscribe from the binaries news group...exit outlook...then re-subscribe.
Then it was available. Even parts of this LOOKUP FEATURE thread were not
showing up in my system just now. Again, I had to unsubscribe, exit, and
resubscribe before I could see all the messages in the thread. What is
causing this to happen?

Thanks,

Scott

[Bowen Moursund [dBASE Inc.]]

Post by Scott Krise
showing up in my system just now. Again, I had to unsubscribe, exit, and
resubscribe before I could see all the messages in the thread. What is
causing this to happen?

Your Outlook Express configuration settings. Ensure that View|Current View
has 'Show All Messages' checked. You should also check
Tools|Options|Maintenence and adjust the message/header purge settings as
appropriate.

[Scott Krise]

Thank you. When I looked under Tools/Options/Maintenance, my system was set
up to delete news messages 5 days after being downloaded. That must be a
default setting because this is the first time I've ever seen it. Either
way, that should solve my problem.

Thanks again.

Scott

[Rainald Taesler]

Scott Krise wrote:

Hello Scott

Post by Scott Krise
Ok...I did find it now...but it was not listed in the binaries on my
system. For some reason, messages seem to periodically be removed
from what I can see on my system.

This is caused by the settings you specifý for OE.

Post by Scott Krise
To be able to see the posting that Richard made...I had to
unsubscribe from the binaries news group...exit outlook...
then re-subscribe. Then it was available. Even parts of this
LOOKUP FEATURE thread were not showing up in my system
just now. Again, I had to unsubscribe, exit, and resubscribe before I
could see all the messages in the thread. What is causing this to
happen?

Only YOU ;-)
Follow Bowen's advice.
I have *all* of the msgs ever posted in dBASE NGs on machine /*gbg*/ -
except those thrown out by the admin like Al Acker's ranting /*g,d&rf*/

Rainald

[Scott Krise]

Post by Richard Perryman
We'll I thought that was where I got it. I'll post my copy in the binaries.

I have never downloaded an attachment from the binaries before...and when I
try, I get a message from outlook express that says that OE Removed Access
From The Unsafe Attachements in your mail...and it won't give me access to
it. I've looked through the options within OE and can't find where to
disable this feature. Anyone know how to get around it? If not,
Richard...could you just e-mail it to me directly?

Thanks,

Scott