Simple. Do a SQL Count first, using the same qualification as your
statement but written as:
SELECT COUNT(*) FROM ..
Then have an Active Link trigger if this number is greater that 1.
On the Open Window, use the qualification statement and have the
Window Type set to Modify and the Display
Many thanks to you and Joe for your inputs.
My problem was the following:
- people would like to make a insensitive search in some fields. Not all
the fields.
- the Sybase server is case sensitive. And I am not allowed to change
this because I share the development server with other
The Display a List displays the fields specified in the SQL
i.e. You can do the SQL like...
Select Field1, Field2, Field3
From SomeTable
Where Field5 = 'x' and Upper(Field6) like Upper('ABC%')
The Display will show Fields 1, 2, and 3 while you are selecting against
fields 5 and 6
dear all,
I have a set field action built with a direct SQL.
The query returns several rows.
So I have set the If Multiple Requests Match to Display a List.
What I would like to achieve is to have the Result list open instead of
the SelectionPopup window.
Is that possible?
If not, then how can
4 matches
Mail list logo
