The book shows examples of SQL used in Microsoft Visual FoxPro Applications using Templates 2000, which are entered in SQL Server or Visual FoxPro stored procedures. This book compliments the book *Ready-Made Visual FoxPro Applications for File Maintenance-Templates 2000 for Visual FoxPro* ISBN: 978-1-4208-9681-7 Softcover ISBN: 978-1-4259-0223-0 Hardcover

This book complements the book "Ready-Made Visual FoxPro Applications for File Maintenance - Templates 2000 for Visual FoxPro" ISBN: 978-1-4208-9681-7 Softcover ISBN: 978-1-4259-0223-0 Hardcover

This Book is intended for people who have had some exposure to Visual FoxPro, or other programming languages, and want to learn more about creating practical data entry applications in Visual FoxPro. By using Visual FoxPro parent classes, ancestor forms and controls, all the difficult logic about the screen behavior is transparent to the programmer, and it is only required to modify the information related to the data file or table you are working with. Also it shows how to change an application, using stored procedures instead of views, and the related SQL. This book takes an approach of step by step, using several learning aids like: sample applications, and learning by examples, using lots of pictures that will help the reader achieve a degree of expertise in a short time.

This Book is intended for people who have had some exposure to Visual FoxPro, or other programming languages, and want to learn more about creating practical data entry applications in Visual FoxPro. By using Visual FoxPro parent classes, ancestor forms and controls, all the difficult logic about the screen behavior is transparent to the programmer, and it is only required to modify the information related to the data file or table you are working with. Also it shows how to change an application, using stored procedures instead of views, and the related SQL. This book takes an approach of step by step, using several learning aids like: sample applications, and learning by examples, using lots of pictures that will help the reader achieve a degree of expertise in a short time.

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.

Learn how to build large, mission critical Internet database applications using Tahoe as the foundation. Covers server side web applications, including ASP (ODBC and ActiveX automation servers), FoxISAPI, and advanced web features such as cookies, authentication, and browser functionality encapsulation. Also delves into non-HTML distributed applications and remote data services.

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.