Loading
Everything HP200LX: Knowledge, Products, Service

 Archives
9 years, 100's of pages of HP Palmtop Paper, jammed with tips, reviews and how-to's

Links
Most useful, up-to-date Web sites devoted to the HP 200LX

Downloads
Direct link into 1000's of pieces of Palmtop software

Tips from Our Techs

2008 Catalog
(PDF, 2.6 MB)

Contact Us/About Us

 
Weekly Palmtop Paper Newsletter
(Palmtop tips, latest happenings, and HP Palmtop Paper Store information)


 

 

Privacy Policy

Special @functions increase your power

Special @functions increase your power

@BASE's functions are like their dBase counterparts and allow you to specify precisely the scope of your search. If criteria have been specified through the prompts, then @BASE returns the results of the specified subset of the database, otherwise, most formulas also allow you to specify criteria in the formula.

The following are some of the special database @functions that can be used if BASEFUNC.ADN is attached.

@dbavg -- returns the average value of a specified field for all the records in the database file.

@dbclose -- closes specified database file.

@dbcnt -- returns the number of records in a database file.

@dbfirst -- returns the record number of the first record found in a specified database file that meets the active and/or optional criteria.

@dbfld -- returns the contents of a specified field contained in a specified record number.

@dbisact -- returns a 1 if a specified record is not marked for deletion and meets the active and/or optional criteria. Otherwise returns a 0.

@dbisdel -- returns a 1 if specified record is marked for deletion. Otherwise returns a 0.

@dbisna -- returns a 1 if a field of a specified record has no value. If the field does have a value, the function returns a 0.

@dbmax -- returns the largest value in a specified field.

@dbmin -- returns the minimum value in a specified field.

@dbnext -- returns the record number of the next record in the database matching the active and/or optional criteria.

@dbopen -- opens a database file.

@dbrecs -- returns the total number of records in the database file.

@dbsum -- returns the sum of the values in a specified field.

@dbupd -- replaces the contents of a specified field and record with a specified value.

iPhone Life magazine


Notice about Palmtop.net
The Palmtop Network with its S.U.P.E.R. (Simply Unbeatable Palmtop Essentials Repository) software is now available under the domain name of hp200lx.net.  

 
We Buy
We buy used palmtops, working or broken: HP 200LX, HP 100LX and 1000CX.
 

Copyright 2010 Thaddeus Computing Inc