Tip Bank

Question: How do I temporarily disable foreign keys in a table, insert more rows, and then enable them again? In particular, I need to know about syntax and what the

Question: Do you have to individually catch each exception that a method maythrow? Or can you just have one generalized catch?For example, can I do this?: try{ method1 //which throws

Question: Is there a way for me to kill, destroy, release, or otherwise cancel a form that has hung, without quitting the current instance of Visual FoxPro? I’ve tried practically

If you are developing COM components which run under MTS (Microsoft Transaction Server) then you may want to replicate one machine’s catalog to another machine. Here is a command line

If you want to improve performance of your application then you should always try to use strict type variables. You can use strict type (or strongly typed) variables by referencing

SQL Server 7.0 allows the tempdb system database to expand automatically as needed, rather than failing with an out-of-space error. If a reporting application needs a lot of space in

In order to run this tech tip you need following things:(a) VB5 or VB6(b) Reference to Type Lib information object component (TLIBINF32.dll). This function takes in the name of the

If a run-time statement error (such as a constraint violation) occurs in a batch, the default behavior in SQL Server is to roll back only the statement that generated the

Not all programs may run on all the Windows platforms. Often programs require at least a certain version of Windows. In most cases, this is due to the lack of