Question: Will you please help me in locating a definition of the term “normalizeddatabase”? Answer: Normalization of relational databases is the process of ensuring that thedatabase does not contain redundant

Question: What is the length of a table name or a column name?I know that for some engines it is 18 characters.Is this a SQL limitation or engine limitation ?

Question: I have a form in which the user can select multiple values of “Manufacturer” from a drop-down list. The query should then select from the database all records in

Question: I have a tabular DataWindow with a DDDW. Can I filter the dddw to include only valuesthat have NOT already been selected ? Answer: There is a short, a

Question: Can I use more than one criteria in the QueryWhere(“col1=’val1′”&”col2=’val2′) to refresha bound grid? I would really appreciate an answer or a solution; we are on the border line

Question: I would appreciate an introductory definition/summary of ISQL (Interactive SQL?). Answer: As you’ve guessed, ISQL is an acronym for Interactive SQL. In general,ISQL describes any tool or interface that

Question: How can I make a column that will automatically increment by one each timea new row is inserted into the table? Answer: The solution will depend upon the database

Question: What are the advantages of converting a PC-based Cobol application to a P- based relational database? Answer: The most compelling advantage of converting legacy data into a relationaldatabase management

Question: How can I determine the current filter and/or sortassociated with a DataWindow?For example:s_old_filter = dw_1.WhatsTheCurrentFilter()dw_1.SetFilter(“”)dw_1.Filter()// Do somethingdw_1.SetFilter(s_old_filter)dw_1.Filter() Answer: You can use the Describe function:ls_OldFilter = dw_1.Describe( “datawindow.table.filter” ) Related

Question: Can I use 16-bit DLLs in 32-bit PowerBuilder 5.0? Answer: The short answer is no. If you have access to the source, you could writea thing called a thunk

Question: How can I perform a phonetic search in SQL? I need to search a database ofnames, but exact matches won’t work. Using phonetic matching, I could finda name registered

Question: I’m looking for a way to put a dynamic UserObject in a Tab Control. The PowerBuilder documentation mentions a technique to put it in a window, but nothing for

Question: How can I add a column to a table (not just at the end of the table)? For example: create table test(first_col char(20),second_col char(20)); I want to alter table

Question: I am developing an application that automates government-defined forms, and have defined the forms using DataWindows. For items such as MALE/FEMALE, YES/NO, etc., I have used radio buttons. But

Question: Is it possible to activate an event or function at regular time intervals in a customer user object?I’ve tried to defined a timer event using event id pbm_timer. But

Question: Does an archive or site exist thathas examples or templates for Power Objects? I’ma neophyte, and would like to start with somealready developed applications that I can modify.Specifically, I’m

Question: I need a way of letting the user pick a file name or names from a list. I would prefer this not to be in a dialog box. In

Question: I have a table set up with training records by date. I want to produce a query that will count how many training sessions took place for each quarter

Question: I have a table that contains a concatenated field delimited by colons. The field contains approximately six values I want to house as separate columns on the table. How

Question: Is there a driver for Oracle 7.3.2.3 — the version Oracle recommends for NT 4.0? Answer: Yes, but it is not readily available (as of this writing, 4/14/97). You

Question: How can I print two DataWindows on to one page? Do you have to use a composite DataWindow? Or is there a way to do it with two separate

Question: I have number of forms, including a MainMenu form. On the MainMenu form I have several buttons that I want to click and connect to my other forms. I

Question: Two ways of Indexing a paradox table Answer: Having done a lot of work with Paradox in the past, there are things I’ve learned in Paradox that I’ve needed

Question: A simple property editor Answer: This is an introductory level article about creating a simple property editor that I hope will get you started. I’ll provide enough information about

Question: Using SQL2 built-in functions Answer: A problem that’s rampant with many software tools today, even one as complete and comprehensive as Delphi, is that documentation on many important subjects

Question: I need to add a right-click event to aTDBGrid, but am ata loss as to how to accomplish it. I want to pop up a menu. Do you knowhow?

Question: Previous instance of a running application via EnumWindows Answer: The code below will check for the previous instance of an application. Ifit finds an instance of an app already

Question: Preventing a form from re-sizing using a Windows message Answer: There are some cases in your development where you want to prevent your users from re-sizing a form. This

Question: Some useful string manipulation functions Answer: If you’re like me, you create a bunch of utility functions and store them in a separate unit or maybe even a DLL

Question: How can I use two different data controls to display data from a single data source and table?For instance, I’d like to use a DBGrid as a navigating tool