Centura

Introducing Gupta Team Developer
20-6200-0004

Trademarks
Centura, the Centura logo, Centura net.db, Centura Web Developer, Gupta, the Gupta logo, Gupta Powered, the Gupta Powered logo, Fast Facts, Object Nationalizer, Quest, QuickObjects, SQL/API, SQLBase, SQLBase Exchange, SQLConsole, SQLGateway, SQLHost, SQLNetwork, SQLRouter, SQLTalk, Team Object Manager, db_QUERY, and db_REVISE aretrademarks of Gupta Technologies LLC and may be registered in the United States of America and/or other countries. The trademarks TeamWindows, ReportWindows and EditWindows, and the registered trademark SQL Windows, are all exclusively used and licensed by Gupta Technologies LLC. Adobe is a trademark of Adobe Systems, Incorporated. IBM, OS/2, NetBIOS, and AIX are registered trademarks of InternationalBusiness Machines Corporation. Java, JavaScript, and Solaris are trademarks of Sun Microsystems, Incorporated. Microsoft, Outlook, PowerPoint, Visual C++, Visual Studio, Internet Explorer, Internet Information Server, DOS, Win 32, Windows, Windows NT, ActiveX, MSDN, SQL Server, and Visual Basic are either registered trademarks or trademarks of Microsoft Corporation in the United States of Americaand/or other countries. Netscape FastTrack and Navigator are trademarks of Netscape Communications Corporation. Novell is a registered trademark, and NetWare is a trademark of Novell, Incorporated. All other product or service names mentioned herein are trademarks or registered trademarks of their respective owners.

Copyright
Copyright  2002 by Gupta Technologies LLC. All rights reserved.Introducing Gupta Team Developer 20-6200-0004 April 2002

Introducing Gupta Team Developer

Contents
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . i-15 Using SQLWindows . . . . . . . . . . . . . . . . . . . . 1-1
Installing Gupta Team Developer . . . . . . . . . . . . . . . . 1-1 Tutorial introducing SQLWindows. . . . . . . . . . . . . . . . 1-2 CreatingAccountInfo.app: overview . . . . . . . . . . . . . . 1-4 Creating the login dialog . . . . . . . . . . . . . . . . . . . . . . . 1-5 Coding the Login dialog . . . . . . . . . . . . . . . . . . . . . . . 1-9 Running the application. . . . . . . . . . . . . . . . . . . . . . . 1-15 Creating the form window . . . . . . . . . . . . . . . . . . . . . 1-17 Populating the form using SQL & SAL . . . . . . . . . .. 1-20 Completing the application . . . . . . . . . . . . . . . . . . . . 1-24 Add navigation controls. . . . . . . . . . . . . . . . . . . . . . . 1-24 SAL for navigation buttons . . . . . . . . . . . . . . . . . . . . 1-25 Running the application. . . . . . . . . . . . . . . . . . . . . . . 1-28

Gupta Desktop and Components . . . . . . 2-1
Gupta SQLWindows . . . . . . . . . . . . . . . . . .. . . . . . . . 2-2 Gupta Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-3 Report Builder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-9 Database Explorer . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-9 Visual Toolchest class library . . . . . . . . . . . . . . . . . . 2-11 Dynalibs: Dynamic linked objects . . . . . . . . . . . . . . . 2-12 TeamObject Manager . . . . . . . . . . . . . . . . . . . . . . . 2-13 Gupta QuickObjects . . . . . . . . . . . . . . . . . . . . . . . . . 2-17 SQLBase database engine . . . . . . . . . . . . . . . . . . . . 2-21 Native connectivity to SQL databases . . . . . . . . . . . 2-22 SQLTalk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-22
Introducing Gupta Team Developer -1SQLConsole . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-22

Using ActiveX Objects

. . . . . . . . . . . . . . . . . 3-1

Take a look at the finished application . . . . . . . . . . . . 3-2 Prepare the login . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-3 Create the form window . . . . . . . . . . . . . . . . . . . . . . . 3-4 Add a calendar control, table, and...