Visual FoxPro has long been the perfect front end for client-server applications. Featuring a robust programming language, a full-featured IDE, and a powerful object model, rich client development has always been a joy. Inside, a native local data engine, integrated hooks into binding with remote data, and Rushmore technology make VFP your secret weapon when connecting to SQL back-ends. MySQL is the world's most popular open source SQL database, running on Windows, Linux, and Macintosh platforms. Version 5 incorporates big-iron features like stored procedures and transactions. These features, together with the royalty free runtime model of VFP and the open source licensing of MySQL make client-server applications built with these tools the most powerful and economical combination on the planet. And this book is the only one that shows you specifically how to install, configure, and connect MySQL and VFP, as well as build a variety of client-server user interfaces with VFP. Together with dozens of discussions of real world problems and potential solutions, you won't find a better guide to MySQL and VFP client-server development.
Visual FoxPro is the perfect front end for client-server applications. Its robust user interface, native local data engine and integral hooks into binding with remote data sources, and rich object model, combined with the powerful SQL Server database engine are an unbeatable combination. But with power and flexibility comes potential complexity. "Client-Server Applications with Visual FoxPro and SQL Server" teaches users how to put these two powerful tools together and take advantage of the best features of both.
Ship it! Music to your ears or words that cause a cold sweat as you realize you now need to deploy the solution you have worked on for so long? Have you planned the deployment? Do you have the proper language in your contract with your customer? Do you have the proper install package? What media is the package going to be shipped on to the client? How will it be distributed? What happens after Setup.exe finishes? Do you have the support infrastructure in place? How are you going to handle updates and changes? There's a lot to think about, and deploying a solution requires careful planning. These questions and many more are answered based on real world experience within the pages of this book.
Visual FoxExpress has been helping FoxPro developers build feature rich Fox applications for longer than anyone else. With Creating Visual FoxPro Applications with Visual FoxExpress, you'll learn the nuts and bolts of application development with VFE, starting with setting up a project and continuing on through user interfaces, reports, and security. Bob Archer and Dan Jurden have years of VFE experience under their belts, and it shows as you'll learn dozens of tips and tricks while getting a firm grounding on the entire application development process.
As an in-depth reference for sophisticated corporate developers or Visual FoxPro consultants, this title teaches developers how to develop Internet enabled applications including Active Server Pages and Active Documents. The CD-ROM contains the FoxPro Foundation Classes--a fully developed set of class libraries that developers can begin using immediately.
Client-Server Applications with Visual FoxPro KEY FEATURES ● Explain all features of Visual FoxPro in a step-by-step manner. ● Various commands, functions and features of Visual FoxPro are explained in detail and illustrated through practical examples. ● Provides several useful tips for an efficient use of Visual FoxPro. ● Explains Triggers, Referential Integrity, Data Buffering and Transactions in easy-to-understand language Object-Oriented Programming with Visual FoxPro explained in detail. DESCRIPTION Book is based on Visual FoxPro 9 version 6, 7 or 8, as any important command, function or feature not supported in prior versions is clearly stated in the book. The book is organised into 23 chapters and each chapter covers a distinct set of topics. If you are familiar with Visual FoxPro, you may read the chapters in any sequence; however, beginners are advised to read the book from beginning to end. The book covers almost all commands, functions and features of Visual FoxPro. shown with actual screen images of Visual FoxPro 9, running under Windows XP. WHAT YOU WILL LEARN The objective of this book is to help you to become proficient in Visual FoxPro. DBMS (Database Management System) software and its applications are explained in a simple and easy to understand manner. The style adopted in the book will help to learn Visual FoxPro in a step-by-step mode. You don’t need to have any prior knowledge about database management or Visual FoxPro. All you require, beside this book, is Visual FoxPro installed on a Windows PC. WHO THIS BOOK IS FOR Book is developed for people who want to learn Visual Foxpro in a relatively short time. It will prove an asset to both fresher as well as experienced computer users and will serve as a solid foundation in making them good and efficient programmers of tomorrow. TABLE OF CONTENTS 1. Introduction to Visual FoxPro 2. Tables 3. Locating and Editing Data 4. Modify Structure, Memo & General Fields and File Utilities 5. Memory Variables, Date, Time and Mathematical Functions 6. Sorting and Indexing Tables 7. Programming with Visual FoxPro 8. Useful Functions, Commands and Error Handling 9. Creating Forms 10. Using Form Controls and Creating Visual Classes 11. Creating Reports and Label 12. Creating Windows and Menus 13. Validation Rules, Triggers and Referential Integrity 14. Query Designer and SQL-SELECT 15. Using Views and Accessing Remote Data 16. Organising an Application through Project Manager 17. Data Buffering and Transactions 18. Using Object-Oriented Programming with Visual FoxPro 19. Advanced Object-Oriented Programming 20. Visual FoxPro Development Productivity Tools 21. Interfacing Visual FoxPro with Other Software Package 22. Miscellaneous Commands, Functions and Tips 23. Creating Help File
SQL is THE standard language used world-wide for database communication on all popular database software. It allows the storage and manipulation of data both on Windows platforms and on Unix-based platforms, such as Linux. SQL in easy steps, 3rd edition has an easy-to-follow style that will appeal to anyone who wants to begin using databases. It is aimed at those with little or no experience of SQL. From web developers wanting to add database interaction to their web sites, programmers wanting to quickly add SQL to their skills set, hobbyists who want to begin creating SQL scripts for upload to their own ISP, to students or to those seeking a career in computing, this book will appeal to all who need a fundamental understanding of database administration with SQL. SQL in easy steps, 3rd edition begins by explaining how to download and install the free MySQL database server on both Windows and Linux platforms. This allows you to establish an environment in which to develop and administer your own databases. This book makes no assumption that you will have previous knowledge of any programming or scripting language so it's ideal for the newcomer to SQL. Each chapter builds your knowledge of executing database queries. The book contains exciting chapters on how to selectively extract data from within one, or more, databases and there are complete examples that illustrate each aspect of SQL. By the end of this book you will have gained a sound understanding of the Structured Query Language and be able to write your own SQL scripts to insert, extract and manipulate data. Updated and revised with the latest techniques since the second edition, which was published in 2005. All examples given in this 3rd edition demonstrate SQL features using the current MySQL Relational Database Management System that is supported on both Windows and Linux operating systems. Table of Contents 1) Introducing SQL 2) Getting Started 3) Creating database tables 4) Inserting data into tables 5) Retrieving data from tables 6) Sorting retrieved data 7) Simple data filtering 8) Complex data filtering 9) Generating calculated fields 10) Manipulating data 11) Grouping table data 12) Making complex queries 13) Joining database tables
While Joomla! is relatively easy to install, a fair amount of knowledge is required in order to configure the application to your specific needs. Beginning Joomla! answers many of the questions you're sure to have, guiding you through the process of creating your own design templates, adding and managing content, and adding popular community features such as article commenting, user profile management, and forums. Later chapters discuss e-commerce integration, explore search engine optimization, and show you how to extend Joomla! by creating your own plug-ins.
An irreverent look at how Visual FoxPro really works. Tells you the inside scoop on every command, function, property, event and method of Visual FoxPro 7.0. The eagerly awaited revision to the Hacker's Guide for Visual FoxPro 6.0, this completely updated book is the one you'll keep by your side for as long as you develop in Visual FoxPro.
