devxlogo

Tip Bank

Is There a GoTo Statement in ASP?

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

Uncontrolled Shared Update

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

Minimum Required Run-Times Files

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:

Static vs. Dynamic SQL

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

Visual Foxpro History

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

SQLMaint Update Error

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]

Data Type for Time

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

Common Stored Procedures

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