Client/server applications with Visual FoxPro and SQL server / Chuck Urwiler ... [et al.].

Format:

Book

Contributor:

Urwiler, Chuck.

Language:

English

Subjects (All):

SQL server.

Visual FoxPro for Windows.

Database management--Computer programs.

Database management.

Physical Description:

1 online resource (263 p.)

Place of Publication:

Whitefish Bay, Wis. : Hentzenwerke Publishing, c2000.

Language Note:

English

Summary:

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 will teach you how to put these two powerful tools together and take advantage of the best features of both. Urwiler, DeWitt, Levy and Koorhan together have decades of real-world client-server application building as well as the broad, in-depth knowledge gained only through hundreds of hours of classroom training.

Contents:

""Dedication""; ""Our Contract with You, The Reader""; ""Acknowledgements""; ""About the Authors""; ""How to Download the Files""; ""Table of Contents""; ""Chapter 1 Introduction to Client/Server""; ""The PC revolution""; ""Client/server to the rescue""; ""Features of client/server databases""; ""Data access""; ""Security""; ""Database backup""; ""Point-in-time recovery""; ""Triggers""; ""Referential integrity""; ""Indexes""; ""Defaults""; ""Rules""; ""Primary key generation""; ""Stored procedures""; ""Views""; ""User-defined data types""; ""Replication""; ""Transactions""; ""Scalability""

""Reliability""""Advantages of client/server""; ""Performance""; ""Cost""; ""Security""; ""Scalability""; ""Summary""; ""Chapter 2 Visual FoxPro for Client/Server Development""; ""Object-oriented programming (OOP)""; ""Support for COM""; ""Built-in client/server support""; ""Built-in local data engine""; ""Support for other data-access technologies""; ""Rapid Application Development (RAD)""; ""Summary""; ""Chapter 3 Introduction to SQL Server 7.0""; ""Why move to SQL Server?""; ""Capacity""; ""Concurrency""; ""Robustness""; ""Security""; ""Installation""; ""SQL Server editions""

""Licensing""""Character sets""; ""Sort order""; ""Network libraries""; ""Databases, database files and the transaction log""; ""Types of databases""; ""Database files""; ""Creating a database""; ""The transaction log""; ""How SQL Server allocates storage""; ""Transactions and locking""; ""Implicit and explicit transactions""; ""Locking""; ""Database objects""; ""SQL Server object names""; ""Tables""; ""Enforcing data integrity""; ""Indexes""; ""Views""; ""Stored procedures""; ""Triggers""; ""Summary""; ""Chapter 4 Remote Views""; ""Connections""; ""Remote views""; ""Updatable views""

""Buffering""""Committing and refreshing buffers""; ""Other view properties""; ""FetchAsNeeded and FetchSize""; ""MaxRecords""; ""FetchMemo""; ""Tables""; ""Field properties""; ""DefaultValue""; ""RuleExpression""; ""UpdateName""; ""DataType""; ""Summary""; ""Chapter 5 Upsizing: Moving from File-Server to Client/Server""; ""Why upsize?""; ""Using the SQL Server Upsizing Wizard""; ""Indexes""; ""Defaults""; ""Relationships""; ""Validation rules""; ""Changes made locally""; ""Finished at last? Modifying the results of the Upsizing Wizard""; ""The local database""; ""Summary""

""Chapter 6 Extending Remote Views with SQL Pass Through""""Connecting to the server""; ""The SQLConnect() function""; ""The SQLStringConnect() function""; ""Handling connection errors""; ""Disconnecting""; ""Accessing metadata""; ""The SQLTables() function""; ""The SQLColumns() function""; ""Submitting queries""; ""Queries that return a result set""; ""Retrieving multiple result sets""; ""Queries that modify data""; ""Parameterized queries""; ""Making SQL pass through result sets updatable""; ""Calling stored procedures""; ""Handling input and output parameters""; ""Transaction management""

""Binding connections""

Notes:

Includes index.

ISBN:

1-280-55202-6

9786610552023

1-930919-11-5

OCLC:

923121698