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