vcgfm.htm

Visual C++与数据库的连接经典实例

<FONT SIZE=4 COLOR="#FF0000"><B>Prefix Tags for Data or Object Type Identification</B></FONT></CENTER></H4>

<BR>

<P>The code examples in this book use two- or three-letter prefix tags to identify the data type of variables and symbolic constants of the fundamental data types of Visual C++ and other Object Basic dialects, as well as object variables.

<BR>

<P>Examples of Hungarian variable names of the fundamental data types are sz<I>StringVar</I><I>,</I> n<I>IntegerVar</I><I>,</I> l<I>LongVar</I><I>,</I> d<I>Double</I><I>,</I> and p<I>Pointer</I>. Microsoft and this book use the term <I>fundamental data type</I> to distinguish conventional variables, which have names that are Visual C++ reserved words, from variables of object data types, which might have names that are either reserved or keywords.

<BR>

<P>Prefix tags also are used to identify the type of object when you declare variables of the various object data types supported by Visual C++. The most common object prefix tags in this book are ws<I>WorkSpace</I><I>,</I> db<I>Database</I><I>,</I> and qdf<I>QueryDef</I>.

<BR>

<P>Appendix B provides detailed information on the derivation and use of type identifier prefix tags.

<BR>

<BR>

<A NAME="E68E13"></A>

<H3 ALIGN=CENTER>

<CENTER>

<FONT SIZE=5 COLOR="#FF0000"><B>A Visual C++ and Database Bibliography</B></FONT></CENTER></H3>

<BR>

<P>As I mentioned earlier, this book is intended for readers who are familiar with writing Visual C++, Visual Basic for Applications, and/or Access Basic code. If your first Visual C++ application is a full-fledged database front end, you might want to acquire one or more tutorial or reference books on introductory or intermediate-level Visual C++ programming. Access Basic programmers who are porting Access 2 or Access 7 applications to Visual C++ will benefit from developer-level Visual C++ guides. You also might want more details on the 1992 version of ANSI SQL, SQL-92, and the background of the ODBC API. The following sections provide recommendations of up-to-date books that fulfill these needs.

<BR>

<BR>

<A NAME="E69E16"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>Introductions to Visual C++ Programming</B></FONT></CENTER></H4>

<BR>

<P>The following books are designed to introduce you to Visual C++'s event-driven graphical programming environment:

<BR>

<UL>

<UL>

<P><I>Essential Visual C++,</I> by Mickey Williams (Indianapolis: Sams Publishing, 1995, ISBN: 0-672-30787-1)

<BR>

</UL></UL>

<UL>

<UL>

<P><I>Teach Yourself Visual C++ 4 in 21 Days,</I> by Nathan and Ori Gurewich (Indianapolis: Sams Publishing, 1994, ISBN: 0-672-30795-2)

<BR>

</UL></UL>

<UL>

<UL>

<P><I>Visual C++ in 12 Easy Lessons,</I> by Greg Perry and Ian Spencer (Indianapolis: Sams Publishing, 1995, 0-672-30637-9)

<BR>

</UL></UL>

<BLOCKQUOTE>

<BLOCKQUOTE>

<P><I>What Every Visual C++ 2 Programmer Should Know</I>, by Peter Hipson (Indianapolis: Sams Publishing, 1994, ISBN: 0-672-30493-7)

<BR>

</BLOCKQUOTE></BLOCKQUOTE>

<BR>

<A NAME="E69E17"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>Visual C++ Books for Developers</B></FONT></CENTER></H4>

<BR>

<P>The following books cover intermediate-to-advanced Visual C++ programming topics:

<BR>

<UL>

<UL>

<P><I>Develop a Professional Visual C++ Application in 21 Days,</I> by Mickey Williams (Indianapolis: Sams Publishing, 1995, ISBN: 0-672-30593-3)

<BR>

</UL></UL>

<UL>

<UL>

<P><I>Master Visual C++</I>, Third Edition, by Nathan and Ori Gurewich (Indianapolis: Sams Publishing, 1995, ISBN: 0-672-30790-1)

<BR>

</UL></UL>

<UL>

<UL>

<P><I>Visual C++ 2 Developer's Guide,</I> Second Edition, by Nabajyoti Barkakati (Indianapolis: Sams Publishing, 1995, ISBN: 0-672-30663-8)

<BR>

</UL></UL>

<BLOCKQUOTE>

<BLOCKQUOTE>

<P><I>Visual C++ 4 Unleashed,</I> by Viktor Toth (Indianapolis: Sams Publishing, 1996, ISBN: 0-672-30874-6)

<BR>

</BLOCKQUOTE></BLOCKQUOTE>

<BR>

<A NAME="E69E18"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>A Book on the Microsoft Jet Database Engine</B></FONT></CENTER></H4>

<BR>

<P>The following book offers an excellent reference to the Microsoft Jet database engine:

<BR>

<BLOCKQUOTE>

<BLOCKQUOTE>

<P><I>Microsoft Jet Database Engine Programmer's Guide</I>, by Dan Haught and Jim Ferguson (Redmond: Microsoft Press, 1996, ISBN: 1-55615-877-7)

<BR>

</BLOCKQUOTE></BLOCKQUOTE>

<BR>

<A NAME="E69E19"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>The Primary Guide to SQL-92</B></FONT></CENTER></H4>

<BR>

<P>If you want to fully understand the history and implementation of the American National Standards Institute's X3.135.1-1992 standard for SQL-92, you need a copy of Jim Melton and Alan R. Simpson's <I>Understanding </I><I>the New SQL: A Complete Guide</I> (San Mateo: Morgan Kaufmann Publishers, 1993, ISBN: 1-55860-245-3). Jim Melton of Digital Equipment Corp. was the editor of the ANSI SQL-92 standard, which comprises more than 500 pages of fine print.

<BR>

<BR>

<A NAME="E69E20"></A>

<H4 ALIGN=CENTER>

<CENTER>

<FONT SIZE=4 COLOR="#FF0000"><B>Publishers of Database Standards</B></FONT></CENTER></H4>

<BR>

<P>The syntax of SQL is the subject of a standard published by the American National Standards Institute (ANSI). At the time this book was written, the current standard, X3.135.1-1992 or SQL-92, was available from

<BR>

<UL>

<UL>

<P>The American National Standards Institute

</UL></UL>

<UL>

<UL>

<P>11 West 42nd Street

</UL></UL>

<UL>

<UL>

<P>New York, NY 10036

</UL></UL>

<BLOCKQUOTE>

<BLOCKQUOTE>

<P>[phone] (Sales Department)

<BR>

</BLOCKQUOTE></BLOCKQUOTE>

<P>The SQL Access Group (SAG) consists of users and vendors of SQL database management systems. SAG publishes standards that supplement ANSI X3.135.1-1989, such as the Call-Level Interface (CLI) standard used by Microsoft's ODBC API. You can obtain SAG documents from

<BR>

<UL>

<UL>

<P>The SQL Access Group

</UL></UL>

<UL>

<UL>

<P>1010 El Camino Real, Suite 380

</UL></UL>

<UL>

<UL>

<P>Menlo Park, CA 94025

</UL></UL>

<BLOCKQUOTE>

<BLOCKQUOTE>

<P>[phone] (extension 221)

<BR>

</BLOCKQUOTE></BLOCKQUOTE>

<BR>

<A NAME="E68E14"></A>

<H3 ALIGN=CENTER>

<CENTER>

<FONT SIZE=5 COLOR="#FF0000"><B>Keeping Up to Date on Visual C++</B></FONT></CENTER></H3>

<BR>

<P>A variety of sources of up-to-date information are available to Visual C++ developers in print and electronic formats. Both print periodicals and online sources address management and development issues that are applic