Question: Can I declare a global variable at runtime? Answer: Yes and no. You cannot add a global variable at runtime, but you can dynamically create an object and store

Question: I’m installing IDS 7.3.x on Sol 2.6 with Connect 2.01, and when I attempt to initialize through onmonitor, I do not get an option for soctcp. I’ve even tried

Question: I have seen an easy way to increase any given portion of NOW(), but it was months ago and I can’t find it again. What I want to accomplish

Question: I would like to know how to call the CD-Rom, or rather search for its drive letter. Answer: You can use the FileSystemObject (Microsoft Scripting Runtime in the references

Question: How can I retrieve the images that are stored in the SQL Server Database Table by using iHTML? Answer: I, as well as many others, generally discourage storing images

Question: I was told that in order to make my program easier to read, I shoulduse try to cover all of my program, then catch every exception at the endof

SQL Server sysobjects Table contains one row for each object created within a database. In other words, it has a row for every constraint, default, log, rule, stored procedure, and

STL’s binary_search() algorithm traverses a sequence and returns a Boolean value indicating whether the sought-after element exists in that sequence. binary_search() is declared in the header as follows: bool binary_search

In low-level programming and hardware interfaces, you often need to assign a pointer to a specific physical address. To do that, you have to cast the address value using the

Here are some key terms that you may find useful for reading Standard Template Library (STL) literature and documentation. ContainerA container is an object that stores objects as its elements.

Does your compiler accept the following declarations? volatile x; const y = 0; In pre-standard C++, the default type in such incomplete declarations was int. Thus, the first declaration would

To block copying and assignment of an object, explicitly declare the assignment operator and copy constructor private. Don’t define them, (there’s no point in defining them because they can’t be

Question: I am developing a database program using Access and Visual Basic. I want to display data in a form where the data comes from two tables. For example, the

Question: I want to order the output of my query by two fields. Is this possible? That is, if two values are the same, I want the output ordered by

Question: I have a field that stores lots of data (up to 8,000 characters). I thought that I could maybe save disk space if I stored this data as varbinary

Question: I am having to reformat data for addition to a database. My current struggle involves an identification field for certain records. In the new database it needs to be

Question: Is there a 2.5 patch for running on fast computers? Answer: The only patch that I am aware of is the 2.6 patch.

Question: We have to connect VFP to SQL Server, and we have a lot of non-structural index files for tables. We’ve created remote views for the tables and need to

Question: How do I control the output format for the list structure command so that it always fits on a page (portrait or landscape)? Is there another way to get

Question: Every time I try to use a wizard, I get the following error message: “Cannot find the Wizard Program.” The wizards are located in the same folder that I

Question: How do I place a text box on a pageframe (or anything for that matter)? Answer: Right click the pageframe in the form designer or class designer and choose

Question: When using the following commands to modify a dbf file, I find the file is not accessible for modification: USE MODIFY STRUCTURE How do I modify the file structure?

Question: How do I check strings that have only alphanumeric characters? Answer: When you say alphanumeric, I assume you mean that the characters are in one of the following domains:

Question: I have a table with column called Date, which stores date record, that was entered in smalldatetime format (e.g., 2000-06-01 00:00:00). I need to write a stored procedure that

Question: I would like to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static

Question: I am facing a problem with the following SQL stored procedure: CREATE PROCEDURE usp_CreateAdminUser /*Input Parameters for the Create Admin User */ @FullName varchar(100), @Telephone varchar(50), @Email varchar(50), @Address1

Question: I have a stored procedure that takes a costcenterid (int) as an input parameter. The user wants to search on an unspecified number of costcenters each time. I use

Question: Can I get a list of the columns and datatypes that are returned from a stored procedure without executing the procedure? Answer: There’s no way of doing this using

Question: I need to pass the @TheVar variable to the stored procedure’s IN statement but I keep getting zero records. If I type this statement into the SQL… WHERE Name

Question: Is it possible to create tables in stored procedures using a variable for the table name? For instance: declare @MyNameset @MyName = ‘dbo.Unique_Name’create table @MyName … This obviously doesn’t