Search results for query: *

Let me start by saying, I am new to Webfocus. I have a launch form that has about 8 search fields on it from 2 different tables. I have a standard report being created from any type of search they kick off. I am trying to attempt to have a set of possibly radio buttons or something where they...

I need to pull check_numbers out of a table that have a fl_flag = '1' but to exclude them if there is a row in the same table with the same check_number but the fl_flag = '0'. How would I go about doing this in an efficient way??? I am trying to use the NOT EXIST but not sure if this is the...

I need to return two rows for every row from a table. For instance, the table layout could be: Cust_name Cust_Address Check_no John 123 Main St. 1234 Jane 456 Eve St. 5678 My results that I am attempting to get back need to be as such: John...

I am trying to creat a virtual table by using a dynamic sql. This sql needs to be reuseable on different applications. To make matters more simple to explain let's say my table is a 3 column table. The ID column is a process identifier. ID Integer NAME VARCHAR VALUE VARCHAR The data...

I have a GrossProfitAmt that I need to calculate the sum of this field YearToDate. The field is {AR_SalespersonHistory.GrossProfitAmt}. Is there any easy way to do this because the solutions that I have come up with seem too difficult and abstract. Any help???