These several database functions work together and perform various utility functions, such as checking if fields and tables exist, creating fields and tables, and so on. The interface hides all

For simple Microsoft Access security, set the database password from the Security item under the Tools menu in Access, select Set Database Password, and enter a password. To use the

This code helps test SQL functions or other string-manipulation routines so you can generate random strings. You can generate random-length strings with random characters and set ASCII bounds, both upper

When executing an Oracle stored procedure, use the named parameter convention. In place of this code: OraDatabase.ExecuteSQL _ (“Begin Employee.GetEmpName (:EMPNO, :ENAME); end;”) Use this code:OraDatabase.ExecuteSQL (“Begin Employee.GetEmpName _ (empno=>:EMPNO,

Question: How can I check if the password that a user inputs has at least one numeric character? Answer: The best way to check whether what the user has entered

Question: I want to use a form that contains a set of textboxes and a set of buttons. When I push a button, I want to manipulate the last active

Question: I am developing an application using VBScript and ASP. I wrote this HTML code to be executed on a client’s machine:

Question: I have added a data connection in Visual Interdev. In the Data View I can see all my tables, fields and so on. My database resides on a SQL

Question: When I add a hyperlink to an ASP page, the link appears underlined. How can I remove the underline from the link? I only want the line to appear

Question: We are only able to add one row in the database, using forms in HTML. How can we do multirow operations on the HTML before sending it to the

Question: I am getting this error message: Invalid operator for data type. Operator equals subtract, type equals varchar. What does this mean? Answer: It means you are doing subtraction on

Question: Is there a script that can gauge site visitors’ net connection speed and route them to the proper link? In particular, I’d like to “auto link” my real video

In SQL Server 7.0, dynamic resource allocation lets disk and memory usage scale to meet changing database demands. This flexibility lets SQL Server provide better performance and simplifies managing the

Internet Explorer 5.0 makes printing pages from within your code simple. The print() method is now exposed off the window object in IE5. It presents the print dialog for the

Java uses a big endian data structure, but Intel-based computers and some others use a little endian format. You may run into problems reading binary data saved in little endian

Question: What is the difference between NT servers and NT workstations? Are they different machines or just different operating systems? Answer: NT servers and NT workstations run the same operating

Question: How can I execute an existing DTS package from Visual Basic? Answer: Get an object reference to the package. I do this in Visual FoxPro: loxx=createobject(‘DTS.Package’,’CmdExample’) Then I ask

Question: I am new to SQL. I need to use Oracle 7, but I need a user name and password. How can I get started? Answer: You need to ask

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