Description |
1 online resource (xix, 242 pages) |
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 |
|
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 |
Analysis |
Andre fag (naturvidenskab og teknik) Andre fag |
Notes |
Includes index |
|
English |
|
Print version record |
SUBJECT |
Visual FoxPro for Windows. http://id.loc.gov/authorities/names/n95047852
|
|
SQL server. http://id.loc.gov/authorities/names/n90684343
|
|
SQL server fast |
|
Visual FoxPro for Windows fast |
Subject |
Database management -- Computer programs.
|
|
Database Management Systems
|
|
COMPUTERS -- Programming Languages -- SQL.
|
|
Database management -- Computer programs
|
Form |
Electronic book
|
Author |
Urwiler, Chuck
|
ISBN |
9781930919112 |
|
1930919115 |
|
1280552026 |
|
9781280552021 |
|
9786610552023 |
|
6610552029 |
|