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

Question: I want a simple way to get a report from a SQL server database to HTML. Then I want the report to print, nicely formatted. How do I do

Question: How does the browser history work? Is it possible to take out a link in the history? For example, I have a page with a redirect. The redirect works

Question: Some users access the Microsoft Access 97 database through a Web user interface and others directly to the MDB file. Will it speed Web access if I create a

Question: I have two different styles on my page: “content” and “small”. To avoid the “onmouseover…” lines within the tags, I defined the A:Hover line. Now if a user moves

You can optimize the performance of your “JavaScript” code by properlyarranging the conditions in the “if” statement. If you have severalconditions to be tested together, and you know that one