Populate a flexgrid control with specified columns and filtered rows by drawing the control and calling this routine: Dim strWhere As StringstrWhere = ” WHERE PeopleAddressesID=4502″Call PopulateFlexGrid(Me.MSFGrid, “tblPeopleAddresses”, strWhere,”PeopleAddressesID”, “BuildingName”,
During development, it is often necessary to have blocks of code for debugpurposes. If the debug code is lengthy, commenting anduncommenting it can be tedious. But if you put either
This is a very simple but time-saving and powerful tip to build a dynamicSQL query (in SQL Server 7.0) that updates a particular column value present in all tables. And
Question: I have some complex engine control software that has to run under MS-DOS 6.2, but it needs to transfer data to SQL Server 7. What’s the best way to
Question: I have a table that stores test answers. It looks something like this: Student Date_taken Q1 Q2 Q3 … Q78 If each question (Q%) is true/false (ENUM(”,’T’,’F’)), how do
Question: I tried a DTS export of a table to an Excel file. The data types of all the columns in the table are varchar. When it exports to the
If you have a recordset already created and want to filter it by some criteria, you can use the Filter property of the recordset to do it. Just change the
You can use the dot operator (.) in XSL transformation stylesheets to refer to, effectively, “whatever element was just identified.” Let’s say you had this template in a stylesheet: Say
If you’re getting a bunch of data for an ASP page, you can retrieve all the data through a single stored procedure and through a single call. Here’s what your