Tip Bank

DevX - Software Development Resource

Creating Auto-Incrementing Columns

Question: How can I make a column that will automatically increment by one each timea new row is inserted into the table? Answer: The solution will depend upon the database

DevX - Software Development Resource

Record Count by Quarter

Question: I have a table set up with training records by date. I want to produce a query that will count how many training sessions took place for each quarter

DevX - Software Development Resource

Definition/Summary of ISQL

Question: I would appreciate an introductory definition/summary of ISQL (Interactive SQL?). Answer: As you’ve guessed, ISQL is an acronym for Interactive SQL. In general,ISQL describes any tool or interface that

DevX - Software Development Resource

List of files in a directory

Question: I need a way of letting the user pick a file name or names from a list. I would prefer this not to be in a dialog box. In

DevX - Software Development Resource

Dynamic UserObject in Tab Control

Question: I’m looking for a way to put a dynamic UserObject in a Tab Control. The PowerBuilder documentation mentions a technique to put it in a window, but nothing for

DevX - Software Development Resource

Two Ways of Indexing a Paradox Table

Question: Two ways of Indexing a paradox table Answer: Having done a lot of work with Paradox in the past, there are things I’ve learned in Paradox that I’ve needed