Question: What are the minimum required run-time files for a Visual FoxPro 5 application setup? Answer: The easiest way to find the minimum required run-time files is to do this:

Question: I’m equally comfortable using both VB and FoxPro. Each product has its pros and cons. I think VB has a better developed IDE and debugging facilities. FoxPro, on the

Question: Is GoTo a valid Statement in ASP? I need to do something like this: If x=y then Goto THEREend ifTHERE: bla bla bla Answer: There is no GoTo statement

Question: My company has been using R:BASE in the past and we recently upgraded our network and installed SQL. How can I migrate my old R:BASE data into SQL? I

Question: I need to pass large fields of text. Problem is, some of the text has single quotes in it ( ‘ ). How do I pass these text fields

Question: What is the difference between static and dynamic SQL? For that matter, what are they? Answer: Static SQL statements are embedded in the source code of a program. They

Question: I have a client that has a massively disorganized set of linked databases in Elustra on a UNIX server. They want to take everything, convert it to SQL, and

Question: I am using VFP 5.0. When I create an EXE file, how can I get my own icon associated with it? (instead of a Fox head) Answer: First, when

Question: Is there any way to change the ownership of files and directories with scripts or programs? Answer: You can use the SubInAcl.exe file (included in the NT 4.0 Resource

Question: I have been asked to develop a database of imagery from a company’s slide collection that needs to be incorporated into a Web site. Does SQL support binary files?

Question: Are there any special consideration when using an Inner Join and two of the same tables, one used as an alias? What is the ANSI SQL-specific syntax for Inner

Question: I would like to know how to take the information entered into a form, by a user, then both e-mail and the submitted results of that form and insert

Microsoft’s Internet Explorer 3.02 and above supports a BGPROPERTIES attribute that when set to “fixed” modifies the behavior of the background image to act as a watermark instead of scrolling

You can programmatically find out how long SQL Server has been running by getting this information from the sysprocesses table. Sysprocesses is a table in the master database that contains

The simplest way to create a timer in Java is to use the static sleep() method on the Thread class. This code shows a main class that has a while

Question: I have an app exposing a connector class that returns a reference to a single internal global object. This app runs continuously and I want to display status info

Question: I am creating a site with a public area and a secure area, which is broken into three parts. To enter security, the user goes to LogIn.htm and enters

Question: I want to activate those small popup windows (the ones that appear when you hold your mouse over a program icon in the Taskbar to tell you what appears

Question: How can I add resources to an EXE or DLL? I am using Delphi 3 at the moment. For example, I want to use a new Cursor (a self

Question: I created the main search screen form SearchScrn (fsNormal) with the ability to create as many new forms on the fly (they are not children of MDI form) as

Question: I have an ASP that records a text of notes created by a user. I save this note in a database along with a date&time stamp. If the client

Question: I want to retrieve the system date and convert it to a text string. I can get the system date (using the Date() function call), but I cannot write

Question: I have two forms on my ASP page. The first form uses the &qout;Post” Method and second uses the &qout;Get” Method. The form using the “Get” method has a

Question: I created an ASP that uses VB script to access an Access 97 database in a test environment. Here is the query used: “select * FROM property WHERE user

In a high-volume application, there’s a good chance that two separate transactions will both run the SELECT statement and acquire read locks before either can acquire the write lock required

Question: I have a mailing list with one record per person, but I want to mail to only one person per household. How can I select just the first record

Question: What is RDBMS? Answer: It’s lingo for “Relational Data Base Management System.”

Question: Do you know any good Web sites or have any tech tips on creating wizard interfaces? Answer: Creating wizard interfaces is straight-forward when you know how. All a wizard

Question: I have a difficult time using PB because I can’t see the code flow. I am an experienced programmer with COBOL, PL/1, and SQL and have taken several PB

Private Type POINTAPI x As Long y As LongEnd TypePrivate Type MSGTYPE hWnd As Long message As Long wParam As Long lParam As Long time As Long pt As POINTAPIEnd