Question: We use Dunn & Bradstreet’s Smart Streem System with a subledger that has a high volume of data, and as of this point has to be identified manually and

Question: If a table has a primary key on columns A, B, and C, is there any advantage to also defining an index on columns A and B? Wouldn’t the

Question: I need a text (or char) field that can hold more than 255 characters. Something like a Memo field to hold almost unlimited character data. Is this possible? Answer:

Question: I am developing an application package with VB 6.0 and SQL Server 7.0. My problem is that I can add new records to the ADO recordset but I am

Question: Once a table has been created, is there any way of deleting it in SQL? Answer: Try: DROP TableName

Question: I have two tables: Yarn {Y_yarn_code,x_code}y_yarn_code being PK Yarn_lot (yl_yarn_code) I need to update yl_yarn_code with x_code where y_yarn-code=yl_yarn_code Answer: Try this: UPDATE Yarn_Lot SET Yarn_Lot.yl_yarn_code = (SELECT x_code

Question: I am converting a database from Access to SQL. It is a large database?some 4.5GB large. I get a timeout (1 minute) before I get my response back. Can

Question: Is there a way to use an INSERT statement inside of a view? If it is not possible through a view, how do I use an INSERT statement? I

Question: As a novice SQL Loader user, I have imported a comma-delimited ASCII file into an Oracle database (Unix) using >sqlldr and specifying the delimiter as a comma. I now

The FileSystemObject object (sic) in Active Server Pages (ASP) is very handy for reading, writing, and deleting files via server-side script. However, it isn’t always easy to locate your files

When you create an HTML frameset using the FRAMEBORDER=”0″ attribute, the frames look fine in Internet Explorer. However, there’s an unsightly white gap between non-white pages when you view the

Question: I have an application in which I have to enter employee info and save their photo. I can do that if I use a data control and bound control

Question: I have written an application using VB6/Access. I use DAO. How easy is it to convert the application from Access to SQL Server? Should I make a lot of

Question: I need to compare two object instances of the same class. But I need to compare the contents and not the references (ie: “obj1 is obj2” – will not

Question: Let me describe the problem first: I have a TYPE statement with two variables(appname & dbname). They both are pointing to a global variable that sets the maximum length

Question: How can I put a column from my database into a listbox using VB 6.0? Answer: Here’s a quick way to load a listbox using ADO in VB 6.0.

Question: After retrieving a resultset, using VB6, from SQL Server, I am easily able to populate a grid by setting the resultset to the grid (i.e. Set DataCombo1.DataSource = GetRs).

Question: I know a recordset object should be named rstName, but don’t know all about variant naming specifications. I looked for it on MSDN for a long time, but couldn’t

Question: How is the data laid out in the array and how do you know the size of the array! Answer: Each string that results from the Split function is

Question: I’ve read about what happens behind the scenes when VB creates an instance of a COM object. But, what exactly does happen when VB creates an instance of a

Question: I want to kick off a function once a day (for examle, at midnight). The timer seems a very inefficient way to do this. Is there any way of

‘ Shuffle the elements of an array of any type’ (it doesn’t work with arrays of objects or UDT)Sub ArrayShuffle(arr As Variant) Dim index As Long Dim newIndex As Long

‘ Return the sum of the values in an array of any type’ (for string arrays, it concatenates all its elements)” FIRST and LAST indicate which portion of the array’

‘ The average of an array of any type” FIRST and LAST indicate which portion of the array’ should be considered; they default to the first’ and last element, respectively’

‘ The standard deviation of an array of any type” if the second argument is True or omitted,’ it evaluates the standard deviation of a sample,’ if it is False

Question: How can I interact with a running version of Internet Explorer or Netscape? When I say interact, I mean handling or monitoring browser events such as right click or

Question: We are using Visual Basic to develop our new applications and will be converting our old applications from COBOL to Visual Basic in the near future. We want to

Question: How do I sort columns with their corresponding rows of information and then add data? I would like to use the data in a Web page. Answer: If you