devxlogo

Tip Bank

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.

Retrieving database table names using SQL

Question: I’m a database administrator for a medium-sized company. I would like to be able to retrieve the names of the tables within the company’s database using SQL so that

Overload New and Delete in a Class

It is possible to override the global operators new and delete for a given class. For example, you can use this technique to override the default behavior of operator new