Tip Bank

Question: I created a collection of textbox controls within the same form, using the usual copy option from the edit menu. This collection seems Ok.I try to set properties for

Question: I’m looking for a syntax that can be used to update several columns in an SQLtable. Although I’ve found a number of topics related to ‘update’, they allseem to

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: 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: 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” )

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: 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: 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