Question: How do I sort by year a datawindow that already sorts in ascending or descending? (The field is in mm/dd/yy format.) Answer: Create a computed column on the datawindow
Question: How do I activate trim trailing blanks from No to Yes? Answer: The SET ANSI PADDING statement controls the setting you are referring to. When a table is being
Question: What’s the best way to write null values in file, then read them back from file? Answer: If you are using the built-in PowerBuilder functions to read the data
Question: Can I rename a SQL column without making a new table or relying on GUI? Answer: The ALTER TABLE ALTER COLUMN SYNTAX supports either dropping an existing column or
Question: I just installed IDS 7.31.uc5 on HPUX 11. When I try starting it up (oninit -iy) I get the following error: unable to open input file ‘s’unable to open
You can easily download an HTML page by using the Internet Transfer Control (INet). Here’s a reusable routine that uses this control to download the HTML page at the specified
All COM-oriented VB developers know how to register and unregister an ActiveX DLL, using the REGSVR32 utility. However, there is no such an utility to register and unregister a type
The ADO Recordset object exposes the GetString method, which returns the values in the Recordset into a formatted string. Here’s its syntax: res = GetString([StringFormat As StringFormatEnum = adClipString], _
Here’s a quick way to retrieve the textual (that is, without any HTML tag) contents of a WebBrowser control: Dim Text As StringText = WebBrowser1.Document.Body.InnerText Getting the HTML text is