Question: Is there any other way apart from using the INSERT INTO command that allows you to append a line to a database? I have a primary key “ID,” but

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

Question: How can I dynamically add a visual userobject to a visual userobject? The PB documentation mentions how to add a userobject to a window at run-time, but not how

Question: I have a select query “Select * from Table where ID in (8, 2,3,78,32,1,7)” that I want returned in the same order that the IDs are in in the

Question: I need to know how to order by the count of the selected field. For example: Select xxx count(xxx)from prod-tableorder by xxxI’d like to order/rank field xxx highest to

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

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

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

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

Question: Can I print only one page in datawindow? Answer: Yes, you can set the print range of a datawindow, just like in Word or Excel. If you set the

Question: How can I display the row number in the results of a SELECT query? For example: Select empname from employees where city = “toronto” I would like to show

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

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

Question: I have a problem making reports flexible. Let us assume we have a standard report, but it changes according to the situation. How can I allow users to change

Unlike ordinary member functions, a virtual destructor is not overridden when redefined in a derived class. Rather, it is extended: the lower-most destructor first invokes the destructor of its base

A template definition can be #included in several translation units (source files). However, each time it is #included the definition is recompiled. Using large template definitions can increase compilation time

In some rare cases, it is useful to disallow further derivation of a class. Classes that implement system API or sensitive security management are good examples for that. Declaring the

C++ defines a hierarchy of standard exceptions that are thrown at run time when abnormal conditions arise, such as when operator new fails. The standard exception classes are derived from

The preprocessor #include directive appears in two flavors: #include < vector > // angular brackets and #include “myclass.h” // quotes The two are not interchangeable. The angular-bracket version applies to

I use this routine in almost every application I develop. It’s handy whether you need a key for a collection or whether you use it in a database: Option ExplicitPrivate

This “wait” routine suspends your code and waits for the shelled process to finish. It comes in handy when you need to run another scriptatch file during your process. Use

Use this code to fill a list box with the values from a database table. The first field in the query provides the ItemData for the list: Call FillList(dbase, “select

If you write programs that access information on a network server, you never want to hard-code drive letters. Not all software vendors take advantage of the Uniform Naming Convention (UNC)

I would like to add a few things to the “Building a Better Mouse Trap” tip [VBPJ November 1996, page 56]. This approach also works for any message, including button-up

If you have an application that must run “unattended” and you want it to alert you if something goes wrong, your application can send you a message through WinPopUp. WinPopUp

Question: How can I use VB5 components from within PB6? Can VB5 deliver a DLL that we can communicate with, or are there better methods? Answer: The best method of

Question: How do I control the font size in a rich text edit? I am pulling text from a variable and applying it to a rich text edit by: rte_1.SelectTextAll()rte_1.ReplaceText

Question: I have an .exe of PB app “sales.” While I type c:sales.exe, I will also pass a parameter such as c:sales.exe auto. Now I want to access this parameter

Question: Is there a way to wrap text that is written to the TextArea? Answer: The java.awt.TextArea class does not have built-in support for wrapping text, but you can implement