Copyright: Helpfile Generated by VB HelpWriter!


BtSearch

BtSearch is a Btrieve file editor.

Editing Btrieve files has never been so easy.  You just select the file from the list on the first tab by pressing enter or double clicking.  Then you select any or all fields from the list on the second tab.  Then you go to the third tab and begin locating and editing the data.

About BtSearch

Directory Locations

Edit Options

Exporting

Grid Display Options

Inserting/Deleteing Records

Importing

License Information

Order Information

Print Options

Requirements

Saving Queries

Search Options

Setup (tab 5)

Helpfile generated by VB HelpWriter.


Requirements

1) You must have the Btrieve DLL's required to run programs that access Btrieve databases within Windows.

2) The VBRUN300.DLL file has not been included because many of you already have this file.  If you do not have it you can download it in CompuServe.  Go VBPJ.

Helpfile generated by VB HelpWriter.


Exporting

You may export your Btrieve data by selecting the EXPORT TAB.  You have the option of ASCII or DBASE (DBF) file structure.

You may select any file and any or all fields to export.  You also can export just the records currently in the grid or you may export all records from the file.

Helpfile generated by VB HelpWriter.


Search Options

There are three search buttons which look like the following:  These are located on tab 3 as seen below:

The first button allows you to search for data by any index.  You may enter a value to search for and you will immediatly see the records that begin with that value in the index selected.  You may then use the scroll bar to move up or down through the file.  You can also use  the scroll bar to move your current position within the file.

The second button allows you to search for any piece of data within your file, no matter what type of data it is.  You are allowed to restrict the search to a particular field or to the entire file.  The search will return any records where that value exists.

The thrid search button allows you to select fields and enter values that you want to restrict the search to.

You are allowed to edit any record currently on the grid.  If you double click on any one row you will see a full screen edit of just that record.

                     Helpfile generated by VB HelpWriter.


Editing Records

You may edit any row on the grid.  Just point and click  in any row and column, start typing and you will see the yellow edit box above change.  You may also go directly to the yellow edit box and place your cursor within the line and begin editing.

You may also double click on the row that you wish to edit and you will see a full screen with just that one record.

Helpfile generated by VB HelpWriter.


Printing

With BtSearch you may select various locations to print.  Following is a review:

File.ddf Listing.  From the FILE TAB (first tab) you may select the option to print a list of files contained within File.ddf.

Field.ddf Listing.  From the FIELDS TAB (second tab) you may select the option to print a list of all fields contained within the file you previously selected from the first tab.  This printout will provide you with the file information.  It will show your the file size, Record size, number of indexes and each field with its location and size within the record.

Then there is the printout of the actual data on SEARCH/EDIT TAB (third tab).  You may print the records retrieved in one of two formats.  You can also edit the font size as desired.

                     Helpfile generated by VB HelpWriter.


Setup Tab

The setup tab allows you to set various options.  Following is a picture of those options:

Helpfile generated by VB HelpWriter.


License Information

BtSearch - Windows Btrieve Editor

For ordering information, see the file ORDER.TXT.

License Agreement

You should carefully read the following terms and conditions

before using this software.

Shareware Version

You are hereby licensed to:  use the Shareware Version of the

software; make as many copies of the Shareware un-registered

version of this software as you wish; give exact copies of the

original Shareware un-registered version to anyone; and

distribute the Shareware version of the software in its

un-registered form via electronic means.  There is no charge

for any of the above.

You are specifically prohibited from charging, or requesting

donations, for any such copies, however made; and from

distributing the software and/or documentation with other products

(commercial or otherwise).

Evaluation and Registration

This is not free software.  This license allows you to use this

software for evaluation purposes without charge.  You are

encouraged to register and receive the unlock code which will

enable the full capabilites of this program.  The registration

fee is $39.00.

Payments must be in US dollars drawn on a US bank, and should

be sent to Nelson Software Solutions, 15411 Via La Gitano, Poway

CA 92064 USA.  When payment is received you will be sent an

unlock code via mail, CompuServe, or Fax.

One registered copy of BtSearch may either be used by a single

person who uses the software personally on one or more computers,

or installed on a single workstation used nonsimultaneously by

multiple people, but not both.

You may access the registered version of BtSearch through a network,

provided that you have obtained individual licenses for the

software covering all workstations that will access the software

through the network.

Disclaimer of Warranty

THIS SOFTWARE AND THE ACCOMPANYING FILES ARE SOLD "AS IS" AND

WITHOUT WARRANTIES AS TO PERFORMANCE OF MERCHANTABILITY OR ANY

OTHER WARRANTIES WHETHER EXPRESSED OR IMPLIED.   Because of the

various hardware and software environments into which BtSearch

may be put, NO WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE IS

OFFERED.

Good data processing procedure dictates that any program be

thoroughly tested with non-critical data before relying on it.

The user must assume the entire risk of using the program.  ANY

LIABILITY OF THE SELLER WILL BE LIMITED EXCLUSIVELY TO PRODUCT

REPLACEMENT OR REFUND OF PURCHASE PRICE.

Helpfile generated by VB HelpWriter.


Order Information

Registration cost $39.00

Use Windows Notepad or other word processor and load the file Order.txt.  Fill out and return with your check to the address below:

Nelson Software Solutions

15411 Via La Gitano

Poway Ca 92064

U.S.A.

CompuServe ID:102105,1172

You may also register via the CompuServe Shareware Service.  BtSearch Registration number is 10817.

Helpfile generated by VB HelpWriter.


Insert/Deleteing Options

Look for these icons to Insert and Delete:

INSERTING RECORDS:  To insert records click on this icon:   This will give you a blank page so you may begin adding new records.

Each time you change rows it will ask you to save the record.  When done click the Cancel Insert button.

DELETEING RECORDS:  To delete a single record click the row you want to delete.  Then click this icon:    You may also delete a group of records by highlighting all the records you wish to delete.  Do this by using your mouse to begin blocking the records you want to delete.  Then click on this icon:

Helpfile generated by VB HelpWriter.


About Nelson Software Solutions
About BtSearch for Windows

Nelson Software Solutions

Gil Nelson

15411 Via La Gitano

Poway Ca 92064

CompuServe ID# 102105,1172.

BtSearch is a product I decided to write because there was a need for a Windows product to quickly and easily edit Btrieve files.

As always I would like to have your input as to how you would like to see this product enhanced.  Any suggestions may be forwarded to my CompuServe ID# 102105,1172.

To order BtSearch, print ORDER.TXT, then complete and mail in.  Upon receipt of payment an unlock code will be issued which will enable all functions.  You may also register via the CompuServe Shareware service, BtSearch Registration number 10817.

Helpfile generated by VB HelpWriter.


Saved Queries

There are two steps to queries.  First you must Save your Querie:  To save queries select the file from tab 1 and the fields desired in tab 2.  Then goto the frame titled "Save Query Information" on the second tab as seen below:

All saved queries are automatically saved with the extension .BTS.

The second step is retrieving the query.  This is done in one of two ways.

From the program manager or the Windows 95 desktop select the icon that currently runs BtSearch.  Copy this icon and edit it to include the name of  your query at the end of the command line.  For example if the current command line reads as follows C:\BTSEARCH\BTSEARCH.EXE then you would edit it as follows:  C:\BTSEARCH\BTSEARCH.EXE  FILENAME.BTS.  This will cause the program to load and automatically load the file and fields you had previously selected.

The second way to access a saved query is after the program is loaded.  From the first tab you will see a box on the lower right with a list of saved queries.  Double click on the file you wish to load.

                     Helpfile generated by VB HelpWriter.


Importing Data

When Importing ALWAYS BACKUP

This function allows you to import DBASE or ASCII files.  The data will be converted into there proper Btrieve types.  Following is the DBASE Import View:

You will be able to see how many records will be imported, and will be able to see a sample record.  You may view several records until you are satisifed then select the Begin Import button.

One note on importing information.  Btrieve stores numeric data in various formats.  For instance if the type is an integer then the maximum number is 32767 to -32767.  However it only takes 2 spaces in a Btrieve file for a number that contains 5 spaces in Dbase.  Thus Dbase and Ascii files that are being imported into the Btrieve format may have larger sized fields than there Btrieve counterpart.

The next screen shows you the ASCII Import View.  It differs slightly from the DBASE view in that you must confirm the lengths of each field.  They will default to the length that BtSearch would export them in.  The sample record will change as you change the lengths of the individual fields.  Once you are satisified that you have the proper lengths for each field then you may begin import.

                     Helpfile generated by VB HelpWriter.


Directory Locations

Below is the screen where you select your various directories:

The first box on the left is the Data Dictionary File location.  Select the directory where the File.ddf, FIeld.ddf, Index.ddf files are located.

The second box on the left is the location where the actual data files are located.  Many times they are the same, however if not you may change it to the location.

The box on the bottom titled  Location of Saved Queries is the location where you may pre-save a file and fields selected from a specific file.

These locations will be saved so that the next time you enter the program  it will default to these directories.

Helpfile generated by VB HelpWriter.


Grid Display Options

You may customize each grid by pressing the right mouse button while over the grid.  You may change the background and foreground colors as well as the font style and size.

                     Helpfile generated by VB HelpWriter.


Glossary

D

DDF Files

E

Export

F

Field.ddf

File.ddf

I

Index.ddf

Q

Queries

S

Search Button 1

Search Button 2

Search Button 3

V

Vbrun300.dll


DDF Files

DDF stands for Data Dictionary Files.  There are three DDF files.  File.ddf, Field.ddf, Index.ddf.  These files are necessary to run BtSearch.


Export

Export your Btrieve data to ASCII OR DBASE (DBF FILES).


Field.ddf

Field.ddf contains all of the field information such as the type, size and length of the fields.  This is required to run BtSearch


File.ddf

This file contains a list of all files that are used by your application.  It is required in order to use BtSearch


Index.ddf

Index.ddf is the file where index information is stored for each Btrieve file.


Queries

In BtSearch Queries represent Files and Fields preselected so that you may access them at a later date without going through the trouble of reslecting them.


Search Button 1

This search uses the index structure.  It allows you to enter a starting point and select the index desired and then will immediately locate the data.


Search Button 2

The second search button allows you to search for any piece of data, no matter if it is indexed or not.


Search Button 3

The third search button allows you to select various parameters to restrict the search.


Vbrun300.dll

Visual Basic's runtime module which is needed to run BtSearch.