Okay, here is the translation following your instructions: VISUAL FOXPRO 8.0 Programmer's Handbook

Author: Fang Zhihui
Publisher:
Publish Date: 2004-05-01
Features: (This book includes all features of Visual FoxPro 8.0) For Visual FoxPro users, the purpose of using this manual is to apply all features of Visual FoxPro 8.0 to develop applications, which is also the purpose of writing this manual. Like all Windows applications, Visual FoxPro 8.0 has added many new features and improved some features of previous versions. Below, they will be introduced separately.
Enhanced Interactive Development Environment
After running Visual FoxPro 8.0, users will find some small changes in the main operation window, with new buttons added to the toolbar. In addition, there are some changes that are not visible on the screen, which together enhance the interactive development environment of the data management system.
Added Many Classes, Commands, and Functions
Visual FoxPro 8.0 has added and enhanced many features through new class libraries, commands, functions, and system variables, allowing users to do more in application development.
Enhanced Data Functionality
Visual FoxPro 8.0 has added and improved its data usage performance in many aspects. For example, the CursorAdapter class for connecting remote data provides more options and better connection performance, with a wider range of data source usage. Additionally, it supports XML (Extensible Markup Language), ADO (ActiveX Data Object), ODBC (Open Database Connectivity), and local data source types. It can also use different data dynamically, with the data source attached to a CursorAdapter object or data environment. Data can be shared with restrictions within the data source, and a CursorAdapter object can define the way data and cursors are applied. Furthermore, the data environment can be saved as a class during design, field values can be automatically added when designing tables, a sequence can be predefined in indexes, SQL commands with SELECT...UNION can be implicitly data-aware, and INSERT SQL can insert new record rows into SELECT SQL commands.
Differences from the Previous Version at Runtime
The main difference between the runtime of Visual FoxPro 8.0 applications and the previous version lies in the fact that the preset application supports Windows XP themes, which may affect the user interface. Users can close this preset setting through forms, controls, and the _SCREEN system variable. Visual FoxPro 7.0 Service Pack 1 includes identifier 8192 in XMLTOCURSOR(), allowing the import of XML files. The document with identifier 8192 contains the XMLTOCURSOR() function. Additionally, the HOME(5) now returns the Visual Studio MSDN directory. This manual will comprehensively introduce the above new features, as well as the various properties, events, functions, methods, procedures, commands, system variables, and controls provided by Visual FoxPro 8.0.
For beginners, to master the content of this manual, they must first learn to use the Command window of Visual FoxPro 8.0, as it allows them to directly see many commands, functions, properties, etc., and intuitively understand their functions. The Command window is a sub-window of the operation window in Visual FoxPro 8.0. It can be seen on the screen the first time it runs. If it is closed afterward, it can be opened in the Window drop-down menu, and it will then appear on the screen. The Command window has many features similar to the operation window of Microsoft Word, such as inputting and executing commands, and selecting and executing previously used commands. In fact, any operation performed in Visual FoxPro 8.0 will execute related commands, functions, methods, etc., which will also appear in this window. If the scroll bar of this window is dragged to the top, you can see the commands and parameters used in the previous operations. Like other Windows application windows, the Command window can be moved to other positions, resized, or zoomed in and out. If you want to see more lines of content in the Command window, you can drag its lower left corner or bottom edge to enlarge it.
Next, beginners should learn to use the ? and ?? commands, which return the value of an expression on the screen. An expression is composed of commands, functions, methods, events, procedures, and fields, so through them, you can quickly understand the purpose of a command, function, event, or procedure. For example, if you enter the command line: ?15(10+10) in the Command window, Visual FoxPro 8.0 will immediately display the value of the expression 15x(10+10) in the main operation window.
However, before using this manual to develop Visual FoxPro 8.0 applications, you must first learn to write Visual FoxPro 8.0 applications. In visual programming, developing an application is not difficult. By creating the corresponding controls through forms and setting properties and procedure code, you can quickly complete the operation. This is vividly demonstrated in the companion tutorial of this manual. Users only need to refer to the various commands, functions, events, methods, etc. provided by Visual FoxPro 8.0 in this manual, as well as the parameters that can be set when using them, to fully apply the various features of this software to develop applications.
The following individuals contributed to the writing of this book: Lin Zhuangning, Li Lin, Wang Ming, Wang Ronghai, Huang Xiaoming, Zeng Xinyu, Zeng Xiaojuan, Zhang Xiaolin, Huang Ning, Li Yongnai, Ma Pingsui, Guo Chuosheng, Wang Kaihe, Zhou Yang, Zhong Linchuan, Zhao Erbing, Li Dan, Wang Bingyang, Yang Niyang, Gong Zehua, Liao Shuren, Wang Xiaofeng, Ding Shuren, and Lin Ming. Special thanks are given to them.
This is a reference book for Visual FoxPro 8.0 application developers. It provides detailed introductions to the functions, parameters, and usage examples of commands, properties, functions, procedures, events, etc. provided by Visual FoxPro 8.0. The chapters are arranged in alphabetical order, and the content is structured as a dictionary, including function, syntax rules or formats, parameter descriptions (where functions also include return value types), examples, scope of application, and object specifications. It also includes comparisons with related functions, objects, command formats, properties, and system reserved words, making it easy for users to quickly and efficiently refer to the information. This serves a constructive purpose.
The book comprehensively collects internal functions, objects, command formats, properties, and system reserved words involved in each version of the database development platform Visual FoxPro, and analyzes their usage methods, techniques, and scope of application through examples, guiding developers in practical application. The content of this book is comprehensive, with rich and practical examples, making it suitable not only for database and Visual FoxPro 8.0 application developers but also as a teaching and self-study reference for students and teachers in relevant fields at universities.