This chapter introduces the various visual components and APIs with which you can develop Pervasive.SQL applications.

This chapter shows more detail regarding the access methods.

This chapter provides information about developing and running applications in the Btrieve environment.

This chapter describes Btrieve and MicroKernel features.

This chapter provides information about creating a data file, improving system performance, and setting up security.

This chapter provides language interface source modules provided in the Pervasive.SQL SDK installation option.

This chapter includes an overview of Pervasive interface libraries and the requirements for shipping Glue DLL files.

This chapter provides information about inserting and updating records, establishing position in a record, and adding and dropping keys.

This chapter describes the fundamental concepts of supporting multiple users and applications.

This chapter provides tips on troubleshooting your application.

This chapter provides information to help you begin developing a Pervasive.SQL application by making direct calls to the Btrieve API.

This chapter introduces the fundamental principles of relational database design. A thorough database design throughout the development process is critical to successful database functionality and performance.

This chapter explains how to create a database by creating the data dictionary and creating the database's tables, columns, and indexes.

This chapter explains how to add data to a database using either Pervasive.SQL applications or SQL statements. It also explains how to drop (delete) rows, indexes, columns, or tables from your database or drop an entire database when you no longer need it.

This chapter explains how to modify table definitions, column attributes, and data. You can perform these tasks by entering SQL statements using an interactive application.

This chapter discusses how you can use SELECT statements to retrieve data.

This chapter explains how to store SQL procedures for future use and how to create SQL triggers.

This chapter discusses defining relationships among tables, administering database security, and controlling concurrency with transactions. This chapter also discusses atomicity in Pervasive.SQL databases.

This chapter outlines the development options for programming to the Pervasive relational database engine.

This appendix lists sample collations of language-specific strings, using the ISR tables provided in Btrieve.

This appendix describes the design of the tables in the university sample database.