Welcome to RAC, the R(eplacement) for the A(ccess) C(rosstab) query, written exclusively for MS Server 7 and S2k. Use RAC to produce basic crosstab tables. Take advantage of the many computational and report type features to create more elaborate tables. Use RAC to perform various data manipulations
Community
Stored Procedures: Parameters, Inserts and Updates
From SQL Team.com, Darrell writes "I need to figure out how to run a query and get a recordset row. With the data from that recordset I need to create create a new row changing the primary key. The old row then needs to have status fields updated. I hope that is clear." I'll discuss pass
C++ SOAP client for MS SOAP Toolkit 1.0
by Catalin Hatmanu<br> In July 2000 Microsoft released first version of SOAP Toolkit for Visual Studio 6.0. In September 2000 was released the beta 1 of SOAP Toolkit Version 1.0. In my opinion the most remarkable feature that was added is the SSL support. The most recent non-beta version is version
Preparing Your Site for WAP
By Steve FranklinCiting estimates that wireless web clients of various types will soon outnumber LAN-connected devices, this article offers developers tools for deciding how to add wireless support to their sites.
XML Ain't What It Used To Be
by Simon St. Laurent Current XML development at the W3C threatens to obliterate the original promise of XML — a clean, cheap format for sharing information — by piling on too many features and obscuring what XML does best. While users may demand some of those features for some applications, f
Seven Simple Steps
Seven Simple Steps has many unique features but it can be called a “source code generator”. If Microsoft Front Page allows you to channel your creativity into colorful and static web sites then Seven Simple Steps is a tool that allows you to turn your data files into well-constructed dynamic data fo
Make ADO Work Faster Using Output Parameters in Your Stored Procedures
Many of us have read or heard that using SQL Server output parameters is more efficient than simply returning a recordset. But, how much more efficient? And was the gain in ADO, SQL Server, or both? Although Craig Utley is based in Kentucky, you might think he’s from Missouri, the "show me" state.
Pervasive.SQL Workgroup Edition – Product Focus
Pervasive.SQL for DataFlex is a combination of the DataFlex Connectivity Kit for Pervasive.SQL from Data Access Corporation and Pervasive.SQL from Pervasive Software, Inc. Pervasive.SQL's "Best of Both Worlds" server technology simultaneously provides the high-performance tra
eXcelon Unveils Portal Server 3.0
eXcelon Corporation, a leading provider of XML-based business-to-business infrastructure solutions, introduced eXcelon Portal Server 3.0. The next major release of the company's XML-based platform for developing and delivering self-service applications, Portal Server 3.0 includes a new integrate
Answering the Namespace Riddle
Dodds introduces RDDL, the Resource Directory Description Language, the result of a recent project conducted by the XML developer community to make XML namespaces easier to use.