devxlogo

Tip Bank

The Type-name Keyword

A type-name is merely a placeholder that has to be substituted with a proper type. For example: template T min( const T& first, const T& second); //T is a type-name,

Make Sure Data is Safe Before Unloading

To decide when it is safe to exit your program, use a DataUnsafe function. Set the DataModified variable to False when you load or save data, or when you start

Problem with Filter function and char()

Question: I want to filter out data from a datawindow during runtime. I have a sle-field in which the user enters a search string (for example, “SM”). This should be

SQLServer Y2K Testing

Question: I have been asked as a SQLServer DBA to certify SQLServer 6.5 as Y2K compliant, apart from any statements from Microsoft. I am aware that Microsoft indicates that all

Titles of SQL reports

Question: Is there a way to title report outputs in SQL? Answer: If you are creating a quick and dirty report, you can always add a title simply by putting

Connection Limits to SQL Server?

Question: Is there a limit to the number of connections to an SQL server? If so, how many connections are permitted at one time? Answer: The number of connections is

Can PB act as a COM Server

Question: I am working with a client that has a Powerbuilder application. We need to call that app through a variety of APIs. The client says that they cannot act

PL/SQL

Question: What does the PL stand for in PL/SQL? Answer: The PL stands for procedural. SQL is traditionally set-oriented. In many situations, a significant amount of procedural code must also

Inner Joins

Question: Is there a limit on the number of tables that can be joined in SQL? Answer: In SQL Server version 6.5 there is an upper limit of 16 tables