Tip Bank

DevX - Software Development Resource

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 - Software Development Resource

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 - Software Development Resource

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

DevX - Software Development Resource

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 - Software Development Resource

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 - Software Development Resource

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 - 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