LEADER 04517nam 2200577Ia 450 001 9910825973403321 005 20200520144314.0 010 $a1-280-55202-6 010 $a9786610552023 010 $a1-930919-11-5 035 $a(CKB)111035898514176 035 $a(EBL)3301801 035 $a(SSID)ssj0000123253 035 $a(PQKBManifestationID)12018517 035 $a(PQKBTitleCode)TC0000123253 035 $a(PQKBWorkID)10006845 035 $a(PQKB)10056879 035 $a(MiAaPQ)EBC3301801 035 $a(Au-PeEL)EBL3301801 035 $a(CaPaEBR)ebr10110772 035 $a(CaONFJC)MIL55202 035 $a(OCoLC)923121698 035 $a(EXLCZ)99111035898514176 100 $a20011228d2000 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 00$aClient/server applications with Visual FoxPro and SQL server /$fChuck Urwiler ... [et al.] 210 $aWhitefish Bay, Wis. $cHentzenwerke Publishing$dc2000 215 $a1 online resource (263 p.) 300 $aIncludes index. 311 $a1-930919-01-8 327 $a""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"" 327 $a""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"" 327 $a""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"" 327 $a""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"" 327 $a""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"" 327 $a""Binding connections"" 606 $aDatabase management$xComputer programs 615 0$aDatabase management$xComputer programs. 676 $a005.756/5 701 $aUrwiler$b Chuck$01637000 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910825973403321 996 $aClient$93978565 997 $aUNINA