HALLOGRAM PUBLISHING
SHOPPING CARTSITE MAPCONTACT USPRODUCTS
HOMEBARCODESDEVELOPER TOOLSUSER TOOLSTRAINING
RaSQL for Clipper FAQ

In this FAQ we summarize many of the most common questions we receive from people who are considering purchasing RaSQL/B, or who are considering upgrading from a prior version of RaSQL/B. We try to address what the product is, what its features are, how and where it is used, how it is supported, and how it interacts with other products.

  1. What is RaSQL/B for Clipper?
  2. Why do I need RaSQL/B?
  3. What is the latest version of RaSQL/B? What is "new and improved" about it?
  4. I am not currently using Btrieve, why would I consider using it?
  5. You said that Btrieve is a client-server engine. What do you mean?
  6. Can I have the server select records, too?
  7. Do I need to rewrite my program using SQL commands?
  8. Does RaSQL/B use ODBC?
  9. What vertical market applications use Btrieve?
  10. Isn't Btrieve an old technology?
  11. What is new about the new Btrieve?
  12. Doesn't Btrieve still come bundled with NetWare? Do I have to buy anything else to use RaSQL/B?
  13. Does RaSQL/B require a network?
  14. I am still using Clipper Summer-87, which does not support RDDs. Can I still use RaSQL/B?
  15. Can I use RaSQL/B with other libraries and RDDs?
  16. Does RaSQL/B support Exospace, Blinker and Causeway protected (extended) mode programs? Does it support Blinker Dual mode programs?
  17. Can RaSQL/B be overlaid with RTLink, Warplink or Blinker?
  18. Does RaSQL/B support Windows programs created with FiveWin or Clip4Win?
  19. Does RaSQL/B support Windows 95?
  20. Can a RaSQL/B program run in a Windows 3.1, Windows 95 or OS/2 "DOS box"?
  21. What if I try RaSQL/B and decide I don't need it?
  22. If I use RaSQL/B will I find many other users to "network" with?
  23. Can Clipper applications created with RaSQL/B be distributed?
  24. Can RaSQL/B be installed on a server for group use by several programmers?
  25. Can I distribute Btrieve.exe with my application?
  26. Why should I use RaSQL/B when there are other shareware and even freeware libraries out there?
  27. Who is Communication Horizons?

What is RaSQL/B for Clipper?

RaSQL/B is an RDD (Replaceable Data Driver) that lets your program access Btrieve files with the same Clipper commands and functions that you use to access DBF files: Use, Skip, Goto, Seek, etc.

To Top


Why do I need RaSQL/B?

If you need to access Btrieve files from your Clipper application, RaSQL/B will make it fast and simple.

To Top


What is the latest version of RaSQL/B? What is “new and improved” about it?

The latest version is 6.1. It is a major upgrade over 6.0. It adds support for Btrieve 6.x, extended indexes (up to 119 segments), protected and dual mode programs, FiveWin and Clip4Win, and a client-server Set Filter command.

To Top


I am not currently using Btrieve, why would I consider using it?

Btrieve is the longtime leader in industrial strength database engines. That is the reason it is used by more popular vertical market applications than any other single database engine. It's main strengths are:

  • Data integrity -- which means no more corrupted data or indexes!
  • Performance on a network -- since Btrieve is a client-server engine, as the network gets busier and busier, the performance of a Btrieve-based application over a DBF-based application looks better and better.
  • Portability -- Btrieve files are supported on almost every platform: FoxPro, Clipper, VB, Cobol, to name a few. While most platforms can import or export DBF files, they usually do not support all the variations of DBF index files (CDX, MDX, NTX, etc.).

To Top


You said that Btrieve is a client-server engine. What do you mean?

On a non-client-server system such as DBF+CDX, the workstation maintains all the data as well as all the indexes. Every time you add or modify a record, the workstation must update the index files on the server. Every time you Seek a record, the workstation must read the index files to lookup the key value. With Btrieve, all indexes are maintained on the server: when you add or modify a record, the server updates the indexes automatically. When you Seek a record, RaSQL transparently sends the key value to the server: the server looks up the key value and sends only the record to the workstation. This can result in an enormous improvement in network throughput.

To Top


Can I have the server select records, too?

The RaSQL/B command, SET SERVER FILTER, works similarly to Clipper SET FILTER command. However, RaSQL/B directs the server to process the filter, instead of the workstation. This can increase performance dramatically when browsing or reporting.

To Top


Do I need to rewrite my program using SQL commands?

RaSQL/B, notwithstanding the name, uses standard Clipper commands and functions: Use, Seek, Skip, Goto, etc. No SQL is needed.

To Top


Does RaSQL/B use ODBC?

RaSQL/B communicates directly with Btrieve, bypassing ODBC overhead. We call it our “NODBC” solution.

To Top


What vertical market applications use Btrieve?

Platinum, Macola, Great Plains, Dac Easy, SaleMaker, and PeachTree for Windows, just to name a few.

To Top


Isn't Btrieve an old technology?

Btrieve has been around since the early 1980's. However, ever since Novell spun it off back to its originators, Btrieve Technologies Inc (BTI), it has again become cutting edge technology. Major new releases include Btrieve 6.15 for DOS, Windows, Windows NT and Windows 95.

To Top


What is new about the new Btrieve?

Btrieve 6.x is significantly faster than earlier versions of Btrieve. In addition, it supports up to 119 index segments, as opposed to 24 in earlier versions. The new DOS version runs in extended/expanded memory, thus taking up much less “real” memory.

To Top


Doesn't Btrieve still come bundled with NetWare? Do I have to buy anything else to use RaSQL/B?

Btrieve does come with NetWare, so there is no need to purchase anything else. However, the version that comes with NetWare is not guaranteed to be the latest one. If you will be using Btrieve for mission-critical applications, we strongly recommend that you contact Btrieve Technologies or us for the latest versions.

To Top


Does RaSQL/B require a network?

RaSQL/B will work equally well with networked or stand-alone Btrieve. No program changes are needed.

To Top


I am still using Clipper Summer-87, which does not support RDDs. Can I still use RaSQL/B?

Yes, RaSQL/B can be used as an RDD or a function library. Under Summer-87 you would use it as a function library.

To Top


Can I use RaSQL/B with other libraries and RDDs?

RaSQL/B has been tested with most popular third party products such as Funcky, SIx Driver, Comix, and of course NetLib! RaSQL/B should work fine with any other “well behaved” RDDs. For example, you could have a DBF+CDX file open in one work area and a Btrieve file open in another work area. You could even Set Relation between them!

To Top


Does RaSQL/B support Exospace, Blinker and Causeway protected (extended) mode programs? Does it support Blinker Dual mode programs?

Yes.

To Top


Can RaSQL/B be overlaid with RTLink, Warplink or Blinker?

Yes, RaSQL/B can be overlaid 100% with these real-mode, dynamic overlay linkers.

To Top


Does RaSQL/B support Windows programs created with FiveWin or Clip4Win?

Yes.

To Top


Does RaSQL/B support Windows 95?

RaSQL/B will allow you to use FiveWin and Clip4Win to create Windows 3.1 compatible programs. These programs can also run unchanged under Windows 95.

To Top


Can a RaSQL/B program run in a Windows 3.1, Windows 95 or OS/2 “DOS box”?

Yes to all.

To Top


What if I try RaSQL/B and decide I don't need it?

No problem. You can use it for 30 days and return it for any reason. Simply delete all RaSQL/B files from your hard drive and destroy any applications you may have created using RaSQL/B.

To Top


If I use RaSQL/B will I find many other users to “network” with?

RaSQL/B has been around since 1989 and has over 10,000 users world-wide, so you will easily find other users who may be willing to exchange their tips and tricks.

To Top


Can Clipper applications created with RaSQL/B be distributed?

Yes. There is no royalty for distributing executable programs. However, you may not distribute any RaSQL/B LIB or OBJ files. If the user receiving your application will need to recompile and relink their programs then the user needs their own copy of RaSQL/B. Alternatively, you can contact us for volume discounts or distribution licenses.

To Top


Can RaSQL/B be installed on a server for group use by several programmers?

Each programmer creating programs with RaSQL/B needs their own license. Even if you install RaSQL/B on the server, you must purchase a license for each person using it.

To Top


Can I distribute Btrieve.exe with my application?

If you need to distribute the standalone Btrieve EXE or DLL, you need to obtain a distribution license, unless your client already owns them. As a developer you can obtain a specially priced, unlimited distribution license from Btrieve Technologies Inc. or us.

To Top


Why should I use RaSQL/B when there are other shareware and even freeware libraries out there?

RaSQL/B is an RDD and is thus much easier to use. In addition, most freeware and shareware Btrieve libraries (as well as many commercial ones) are created by consultants “doing the library thing on the side.” Since product development and support is not their first priority, you may be in for a rude awakening when you desperately need support for your mission critical application.

Since 1986 Communication Horizons has been dedicated to product development, support and enhancement. Don't trust your mission critical application to anything less.

To Top


Who is Communication Horizons?

In a business where companies and products come and go seemingly every month, Communication Horizons has been a fixture on the PC software landscape since 1985. Their flagship product, NetLib, was introduced in 1986, and has won either “best of” or “honorable mention” in the DataBased Advisor Readers Choice Awards every year since 1989.

RaSQL, introduced in 1989, has almost single-handedly raised the awareness in the "Xbase" community to the benefits of Btrieve. Between the two, Communication Horizons' products have been used by tens of thousands of developers world-wide.

Besides providing the highest quality software, Communication Horizons aims to provide the highest quality support whether by CompuServe forum, Internet web site, phone or fax. In fact Neil Weicher, the main developer of NetLib and RaSQL still oversees technical support.

To Top


Return to RaSQL for Clipper
RaSQL for FoxPro
RaSQL for FoxPro Function List
RaSQL for FoxPro FAQ
RaSQL Tech Support


RaSQL/B
RaSQL/B 2.5 for FoxPro - WEB only Knowledgebase $695
RaSQL/B 2.1 for Clipper - WEB only Knowledgebase $695


Home || Shopping Cart || Site Map || Newsletter/Blog
Search HALLoGRAM || Request More Information
CALL TOLL FREE 1-866-340-3404

SEARCH
14,500+ PRODUCTS:

Order RaSQL

SIMILAR PRODUCTS
  • File Access Components
  • Database Tools
  • Data Modeling Database Design

  • OTHER PRODUCTS
  • Netlib 6.5 for VFP
  • Netlib
  • Y2KFOX

  • PRODUCTS FOR
  • MS-Access
  • ActiveX/OCX Controls
  • C/C++
  • Clipper
  • dBASE
  • Delphi
  • FoxPro/VFP
  • Java
  • Macintosh
  • Oracle
  • Paradox
  • PowerBuilder
  • Visual Basic
  • Visual Objects

  • Keystone Training Videos

  • Copyright ©2001 HALLoGRAM Publishing, Aurora CO. All Rights Reserved
    All products mentioned in this site are trademarks of their respective owners
    Prices are subject to change without notice
    dmcakegkim