I have created a connection to a remote database. How do I connect to it and use the tables?
The way to do this is to create a new view in SEQUEL ViewPoint. On the design menu, select File > Properties. Use the database drop-down on the View tab to select the remote database. Then, select files and fields, creating a view as you normally would.

How can I calculate the first and last days of the current month?
For the first day of the month use the following calculation:

(CURRENT DATE - DAY

(CURRENT DATE) DAYS) + 1 DAY

For the last day of the month, use:

CURRENT DATE + 1 MONTH - DAY (CURRENT DATE + 1 MONTH) DAYS

How can I remove non-alpha characters from a string?
This requires using two functions. Use TRANSLATE to convert non-alpha characters to blanks, and use STRIPX to remove the blanks from the string.

Let’s look at building this calculation step by step. For example, if field X has a value of a!b@c#d$e, you can use TRANSLATE to replace the non-alpha characters with blanks:

TRANSLATE(X,” “,”!@#$”)

The result is a b c d e.

By adding STRIPX, you can remove multiple occurrences of a character from a string. In this case, you want STRIPX to remove the blanks created by the TRANSLATE function. The final calculation would be:

STRIPX(TRANSLATE(X,” “,”!@#$”),” “)

The final result is abcde.

This entry was posted on Wednesday, September 26th, 2007 at 1:29 pm and is filed under SEQUEL. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.