devxlogo

Tip Bank

Creating menu items in a running program

Question: Is it possible for a running program to dynamically create/add a menu or add a specific item to an existing menu based on an action by the program user?

Excel Export Group Data

Question: I used your Excle OLE Automation and it works great! Is there any way to capture subtotals? Excel captures only what is in the primary buffer. When I retrieve

Dates

Question: select issuelog.analysts,issuelog.helpdesk,isssuelog.issue.issuelog.customer.issuelog.status.issuelog.logged,issuelog.date FROM issuelogWHERE(((issuelog.date)like “*24/01/99*”))ORDER BY issuelog.helpdesk; How do I get it to search for a series of dates, such as the 24th, 25th, 26th etc., in one query?

General Programming

Question: I want to create a function that will calculate four values. I want to return these four values as an array back to an array in the main procedure.

How Can I Tell if a Sheet is Open

Question: How can I check if a certain sheet is Open? Answer: PowerBuilder stores a list of all the currently open sheets automatically for you. You can use the GetFirstSheet

Rowscopy function fails

Question: I’m trying just simply to copy rows from one datastore to another. They both have the same Dataobject set. I know that the source datastore has two rows, but

Export Data to Excel Example Array Arguments

Question: “Export Data to Excel Through OLE Automation: A 10-Minute Solution” says: “Refer to the section of the description: … Create a function called GetColumns, which accepts two arguments, a

Power Builder 6.5 Install Builder Tools

Question: Where is the install builder (how to make the app standalone)? Answer: PowerBuilder 6+ includes the install shield lite edition, which you can use to build installation scripts for

DeleteRow(0) in DW

Question: Does DeleteRow(0) delete the current row or the row at the bottom of the datawindow? Answer: It deletes the current row.