The Latest

DevX

Visual Basic Fonts

Question: I wrote an application in VB4.0 (16 bit) anddistributed it to a few friends. I then madesome changes to the Font property on a few of theforms and make

DevX

Using Control Collections

Question: I created a collection of textbox controls within the same form, using the usual copy option from the edit menu. This collection seems Ok.I try to set properties for

DevX

How to Send to the Printer

Question: I am very new to Visual Basic and have just run this simple program:For x = 1 to 10Print xNext xEndThis produces a list of numbers from 1 to

DevX

Cascading Menu

Question: I am a new commer to VB and have been wondering if it is possible to have cascading pull down menus like the ones I see on the Win95’s

DevX

Toolbar image list

Question: I am trying to setup a toolbar using the MS windows common controls. How do you initialize the image list? The toolbar works but I cant get a image

DevX

Why Do I Need OS/2?

Question: I have just started working with an application developed in VB that my co-workers say can only be run in the Windows environment through OS/2. Supposedly the program uses

DevX

Updating Many Columns

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

DevX

What is normalization?

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

DevX

Length of Table and Column Descriptors

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 ?

DevX

WHERE (multiple values)

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

DevX

Can I filter DDDW values out of itself?

Question: I have a tabular DataWindow with a DDDW. Can I filter the dddw to include only valuesthat have NOT already been selected ? Answer: There is a short, a

DevX

QueryWhere()

Question: Can I use more than one criteria in the QueryWhere(“col1=’val1′”&”col2=’val2′) to refresha bound grid? I would really appreciate an answer or a solution; we are on the border line

DevX

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

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

Converting Legacy Data

Question: What are the advantages of converting a PC-based Cobol application to a P- based relational database? Answer: The most compelling advantage of converting legacy data into a relationaldatabase management

DevX

How to determine current filter/sort associated with DataWindow

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

DevX

Phonetic Searches

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

DevX

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

Adding a Column at a Specific Position

Question: How can I add a column to a table (not just at the end of the table)? For example: create table test(first_col char(20),second_col char(20)); I want to alter table

DevX

OPO Example Archive??

Question: Does an archive or site exist thathas examples or templates for Power Objects? I’ma neophyte, and would like to start with somealready developed applications that I can modify.Specifically, I’m

DevX

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

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

Stripping concatenated fields

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

DevX

Is there a driver for Oracle 7.3.2.3?

Question: Is there a driver for Oracle 7.3.2.3 — the version Oracle recommends for NT 4.0? Answer: Yes, but it is not readily available (as of this writing, 4/14/97). You

DevX

Datawindow Printing

Question: How can I print two DataWindows on to one page? Do you have to use a composite DataWindow? Or is there a way to do it with two separate

DevX

Connecting forms through a button

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

DevX

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