Question: I need to get a handle on my choices for a SQL reporting tool for ad hoc reports. The quick-and-dirty requirements are that it must be able to develop

Question: We are currently running SQL 6.5 and want to upgrade to SQL 7.0. The machine hosting SQL 6.5 is not robust enough to handle SQL 7.0. We are running

Question: I have three databases in SQL Server 6.5. All have the same structure of tables and stored procedures, but whenever I change stored procedures in one I must do

Question: What is the data type for time? Example: 8:45 am Answer: What you really have is the tail end of a datetime data type. You can get it back

Question: I am writing an application that needs to be able to shut down any NT workstation or server remotely. Do you have any ideas on how to do this

Question: When I run SQLMaint to update statistics on one of our SQL 6.5 servers, the table statistics get updated but it returns an error message: [4] Update Statistics…[Microsoft SQL-DMO]

Question: What situation produces incorrect results in an uncontrolled shared update? Answer: I’m not certain what you mean; however, reading uncommitted (i.e., dirty) data springs to mind. Are you trying

Question: How do I display a column from a database in a list box? Answer: This presumes you have a view defined somewhere, either remotely or on the server as

Question: I want to know where Visual Foxpro came from. Can you give me a history of this language? Answer: Visual Foxpro evolved from a product called Foxpro. Foxpro started

Question: Is there a way, using Visual FoxPro, to determine the maximum number of characters (not spaces) in a field? I am working with a table that has over 3

Question: I am using an array on the client side to create an HTML string that builds a table of data, which the user can then manipulate. Because the array

Question: How can I recover data from my SQL database after a stored procedure replaced a whole table with incorrect values? Answer: Chances are you cannot do so. Well, it

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