Copyright ©1996-2004 GlassWare        All rights Reserved.

TCJ My-Stock DB Database Filtering

Once your collection is loaded into a database, the fun begins. Let’s be honest, it doesn’t take long before we can collect more electronic parts than can be used in a lifetime. I for one probably own more than 40,000 parts: capacitors, diodes, ICs, inductors, loudspeaker drivers, MOSFETs, nuts and bolts, PCBs, power supplies, resistors, sockets, transformers, transistors, tubes, wire, zeners… How do find a needle in the haystack? Filtering.

 

TCJ My-Stock DB, filtering your collection is made easy by drop-down selection of filter constrictions. You can quickly define, for example, a filter that will show only tubes made by Amperex that are also triodes and 9-pin miniatures and NOS and have been designated for your line-amplifier project.

 

If the database field doesn’t take a number, such as the part’s brand or vendor, then three choices are offered: blank, which means “anything will be accepted;” =, which means “must match;” and ≠, which means “anything but this.” If the field does take a number, then more choices are available: blank, which means “anything will be accepted;” =, which means “must match;” >, which means “greater than;” >=, which means “greater than or equal to;” <, which means “less than;” <=, which means “less than or equal to.”

 

Once all the filter specifications have been made, the “Apply Filter to Database” button must be pressed down for the filter to take effect. The status bar at the program’s bottom displays whether the database is in the filtered state or not.

TCJ My-Stock DB    One DB    Images    Web Searches    Grids    Creating Reports     Graphs    Filtering DB    Help System    Lists

More Information