LEADER 05317nam 2200613Ia 450 001 9910960041403321 005 20251116142414.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(BIP)46034482 035 $a(BIP)6474217 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 08$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"" 330 $aVisual 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. 606 $aDatabase management$xComputer programs 615 0$aDatabase management$xComputer programs. 676 $a005.756/5 701 $aUrwiler$b Chuck$01871707 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910960041403321 996 $aClient$94480633 997 $aUNINA