Private Type POINTAPI X As Long Y As LongEnd TypePrivate Type MSG hwnd As Long message As Long wParam As Long lParam As Long time As Long pt As POINTAPIEnd

In Windows 95 and 98, when the screen saver is currently active (and the screen is blanked) the Ctrl-Alt-Del key combination doesn’t work, in order to force the user to

Question: I have downloaded an ActiveX DLL (A third Party ActiveX component) for uploading files to my server. The problem is I can not register the DLL in my Web

When designing an internet application that must provide results in a grid, many developers will use small (1 pixel by 1 pixel) images in order to create a grid effect

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

Moving your ASP code to compiled components is always a good idea. Compiled components enable fast execution, along with easy development, debugging, and testing. For example, creating a record set

Question: Is it possible to display the address of the previous Web site as a string so that I can use it elsewhere? Answer: If the user got to your

Question: I have noticed that all rounding to x decimals scripts uses the following format: tenToPower = Math.pow(10, nDecimals);newNumber = String((Math.round(nNumber * tenToPower) / tenToPower)); However, that doesn’t work with

Question: I have tried to reorganize Informix chunks on my disks. So I stopped the Informix and started to copy chunks to a new location with a cplv command (AIX).

You can use savepoints in rolling back portions of transactions to predefined locations. A T-SQL savepoint defines a location to which a transaction can return if part of the transaction

Programming with style sheets is never an easy task if you want to write browser-neutral HTML code. This is because the DOM (Document Object Model) of the Internet Explorer and

The LookupTable object is marked as ThreadingModel=Both and doesn Related Posts Baltimore port crisis ignites infrastructure concernsR Comes to the Enterprise with Microsoft R ServerAsus ROG Ally Z1 Extreme discounted

I have a bunch of files on the server that I wanted to be able to select, for example, to delete them or to give them special treatment. Thus, I

Using this tip, you can create a drop-down list, which is populated from a database, and include it in a Web (ASP) page. This will basically increase the performance via

Question: I am trying to upgrade a program from DAO to ADO that will take a flat file and create a new database, add the needed fields and then populate

Question: I am a SQL beginner and I am trying to write this query. I have a table with four columns: ID STATUS DESCRIPTION CURRDATE1 open Test1 6/1/001 open Test1

Question: These are the fields of my table: id, email, firstname, and lastname. There can be multiple records for a single email. I only want to group by email and

Question: I am trying to query a database with the following: SELECT DISTINCT SystemName, OwnerID, Location, Productver, StartDate, EndDate, ProjectNameFROM DevicesORDER BY SystemName I only want to have the DISTINCT

Question: I’ve heard that Nokia’s strategic aim is to make sure that every automobile on earth has its own e-mail address by 2010. Have you heard that too? Answer: I’ve

Question: Is it possible to have a grid bound to a cursor? If so please tell me how. Answer: A grid is bound to a cursor the same way that

Question: I have two tables Region(RegionId-PK, RegionName) and District(DistrictId-PK, DistrictName, RegionId-FK). When I open a recordset (rs) like : Dim rs as new ADODB.Recordsetrs.Open “SELECT District.*, Region.RegionName FROM District INNER

Question: How do you pass a parameter to a stored procedure from within another stored procedure? Answer: To call a stored procedure from inside another stored procedure, let’s take an