Manual Organization
This manual contains the following topics:
Database Access Methods
This chapter introduces the various visual components and APIs with which you can develop PSQL applications.
This chapter shows more detail regarding the access methods.
Transactional Programming with the MicroKernel Engine
This chapter provides information about developing and running applications in the MicroKernel Engine environment.
This chapter describes API and MicroKernel Engine 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 PSQL SDK installation option.
This chapter includes an overview of PSQL 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 PSQL application by making direct calls to the Btrieve API.
Relational Programming
This chapter explains how to create a database by creating the data dictionary and creating database tables, columns, and indexes.
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 add data to a database using either PSQL 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. It also discusses atomicity in PSQL databases.
Appendixes
This appendix lists sample collations of language-specific strings, using the ISR tables provided in the MicroKernel Engine.
This appendix describes the design of the tables in a Demodata sample database.