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

• Record Nr.: UNINA9910779967603321
• Pubbl/distr/stampa: Whitefish Bay, Wis., : Hentzenwerke Publishing, c2000
• ISBN: 1-280-55202-6; 9786610552023; 1-930919-11-5
• Descrizione fisica: 1 online resource (263 p.)
• Altri autori (Persone): UrwilerChuck
• Disciplina: 005.756/5
• Soggetti: Database management - Computer programs
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.
• Nota di contenuto: ""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""