Great Products, Knowledge and Downloads for Your HP Palmtop!

Palmtop Email Newsletter

The Palmtop StoreThe Palmtop ArchivesLinks and ContactsFree Offers + DownloadsSearch this siteHome Page

 

A Free Newsletter for Users of the HP95LX/100LX/200LX
~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~

In this issue: 
---Use Subset Instead of Find in Database Applications
---Use Appointment Book for more than doing business
---Use NoteTaker to Keep a Date Stamped, categorized Diary

~^~^~^~^~^~^~^~^~^~^~^~Ad^~^~^~^~^~^~^~^~^~^~^~^~
Prepay for a refurbished HP 200LX and get a 10 Meg PC card and a serial cable FREE. For details on this offer that ends on June 30, 2000, see http://www.palmtoppaper.com/cart/shop/PT-used.htm
~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~
Use Subset Instead of Find in Database Applications
---------------------------------------------------
Like a lot of users of the Palmtop's database applications (i.e.,database, Phone Book, NoteTaker, WorldTime) I've used the Find (F4) key to do searches.

What I really wanted was a Find function that would let me search for multiple words or a set of words. I also wanted to avoid having to press F4 and ALT N to search for the next instance of a word. With such a Find function I could look up all those records that contain "calculus" and "equation" or "math". 

I didn't have to look very far to have my wishes granted. The Palmtop's Subset (F6) function does just what I want. Using the Subset function is not as easy as pressing the Find key but, with a little planning and a little patience, the results outweigh the effort. 

If you're interested in exploring this tip, here is an example that will give you the idea and get you started. For the example, I'll use a NoteTaker file called EQNS.NDB that is available on the CD Infobase (1998-2000) in the \ONDISK\97-DISK\PWRDSK97\EQNS directory. The file contains 84 equations in the Notes sections of the records. 

Suppose I want to find all those records that use either of the Solver functions "G( )" or "L( )" and which contain the function Sigma( ). Here's a way to get the records and only the records that meet these specifications.

Open the NoteTaker application and load the EQNS.NDB file. Press the F6(Subset) key and press the F2(Define) key. Press the Tab key to get to the empty Notes field and type in G(,L(&sigma This will get me all those records whose Note field contains "G(" or "L(" and "sigma. Observe the use of the ampersand to represent "and" and the comma to represent "or". This formula won't get me what I want but we'll fix that in a moment. For now, press F10(Done), F4(Edit) and F2(General) to see the SSL formulation. It should be (Note#"G("|Note#"L("&Note#"sigma") The database engine will set up the SSL statement for you. You can leave the subset as "unnamed subset".

You can edit the SSL statement so that it reads ((Note#"G("|Note#"L(")&(Note#"sigma")) 

By putting parentheses around the statements Note#"G("|Note#"L(" and Note#"sigma", you can force the way in which the database engine handles the expression. 

At this point, you can press F10(Done) twice and get a subset of 20 records that meet the requirements for the complex search.

This "search" technique isn't limited to words or phrases in the Notes field. It can include other fields in a database or Phonebook as well. 

~^~^~^~^~^~^~^~^~^~^~^~Ad^~^~^~^~^~^~^~^~^~^~^~^~
Email, do newsgroups, and surf the web from your Palmtop. Total Internet solution in your pocket designed for the HP Palmtop with WWW/LX. http://www.PalmtopPaper.com
~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~ 

Schedule most important things first
------------------------------------
Some of us have so many responsibilities that we end up without having time to do what is really important for us. For example, spending time with our children. We are tired at night and our weekends are crammed with activities, work, or even our favorite ball game.

ON THE PALMTOP: One approach is to schedule an appointment with your kids in your Palmtop, say, for Saturday mornings for 2 hours. That appointment must be treated like any other important appointment. If it must be rescheduled it should be rescheduled immediately and all affected parties need to be informed.

Repeating appointments are easy on the HP Palmtop. Just enter an appointment the usual way by pressing (F2) (Add) from the appointment screen, and then enter the description and time and date. Then press (F8) (Repeat) and move the cursor to weekly. Press (F10) a couple of times and you have scheduled something that is really important to you.

Palmtop diary
-------------
There are many good reasons for keeping a personal diary of our thoughts, feelings, and day to day activities. By pausing to write, often you can clarify uncertainty, explore ideas, think deeply about a concern. If we examine our diary over the months and years, we can discern patterns that will provide insights into living a more fulfilling life. If nothing else, it is interesting to look back and see over time how our concerns changed and matured.

Often it is hard to make time to keep up a diary. However the Palmtop is always with you. You can make it a habit to use the waiting periods, those holes in the day, to update your thinking.

ON THE PALMTOP: Start a new NoteTaker file called Diary ((MENU) File New Diary (ENTER)). For the Title you could Date and Time stamp by pressing (Fn)(,), Date, and (Fn)-(.), Time. Then begin writing. Alternatively you can enter your notes in NoteTaker. Then create your note. Finally, categorize it: say, "happy", "depressed", "excited", "concern", "breakthrough". At a later time you could, say, look at all "concerns."

To insure privacy give the file a password. In either NoteTaker or Memo press (MENU) File Password and give the file a password that you're sure to remember. If you forget the password, you will have lost the file.

~^~^~^~^~^~^~^~^~^~^~^~Ad^~^~^~^~^~^~^~^~^~^~^~^~

Sell us 1 or 1000 palmtops even if they are broken. See
http://www.PalmtopPaper.com or mailto:wayne@thaddeus.com. How about Windows CE? 
Visit http://www.hpcmag.com 

~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~^~

 

[Previous][Next]

[Top]