Tip Bank

DevX

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

DevX

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

DevX

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:

DevX

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

DevX

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

DevX

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]

DevX

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