July 27, 1999

Inserting Page Breaks in a Report

Question: How do I insert page breaks into a SELECT report? The report is sorted by a column that contains about five separate values, and I would like a new page to start each time that value changes. Answer: Page breaks depend on the number of lines already printed. In

Importing Data Containing a CR/LF

Question: How can I import data into a datawindow if the data blob contains CR/LF as part of its data? I am using dw.object.data and dw.importstring for distributed data transfer. This problem is arising when a user enters data (such as in a note) that contains a new line character

Adding the Identity Property to Existing Fields

Question: I have a users table with primary key USERID. The table is already created and loaded with pre-existing data. I now want the USERID field to be self-incrementing&#151that is, using the identity property. Can I alter a column in an ID table once the table and column are created

Changing an Installed Code Page

Question: How do I change the code page in SQL Server 7.0 once it has been installed? Answer: The code page is selected with sort order upon install. Though you can have clients with a different code page from the one the server installed, that brings code page translation into

Dropping Tables at Beginning of Statement

Question: I am trying to create a procedure that first drops the table “table” but only if it already exists. How do I create the statement using “if exists” or something similar to this? Drop table mytableselect * into mytablefrom othertable This statement returns an error if the table does

Comparing Text File with Existing Table

Question: How can I go about reading in a (comma-delimited) text file and comparing it to an existing table? If there is a match on the key field, the row should be updated. If there is no match on the key field, then the row should be added. I am

Converting from FoxPro to Oracle

Question: Can you convert Visual FoxPro forms and reports to Oracle forms and reports? If you can, how is this done? Answer: I am not aware of anything that performs such a conversion.

Hiding the Main FoxPro Window

Question: Is it possible to completely hide the main Visual FoxPro window when I run an executable? In my main program, I use “_VFP.Visible = .F.”, but the main window appears for a few seconds when I first launch the executable. Answer: Here are the steps to fix the problem

Using MS Word to Spell-Check in PowerBuilder

Question: I need to incorporate Microsoft Word 97 spell-check functionality into PowerBuilder. Which MS Word functions are required to do the task? Answer: To interface to the Word spelling checker you will need to use OLE Automation to create a link to the Word application, then call the correct Word

No more posts to show