Client/server applications with Visual FoxPro and SQL server /

Detalles Bibliográficos
Clasificación:Libro Electrónico
Otros Autores: Urwiler, Chuck
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Whitefish Bay, Wis. : Hentzenwerke Pub., ©2000.
Temas:
Visual FoxPro for Windows.
SQL server.
SQL server
Visual FoxPro for Windows
Database management > Computer programs.
Database Management Systems
Bases de données > Gestion > Logiciels.
COMPUTERS > Programming Languages > SQL.
Database management > Computer programs
Andre fag (naturvidenskab og teknik) > Andre fag
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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
  • ReliabilityAdvantages 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
  • LicensingCharacter 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
  • BufferingCommitting 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 ThroughConnecting 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

Ejemplares similares