Ken,
I was actually trying to add the customers main Phone number and heading
above the Choose box with a description. IE:
Main Phone: (custPhone) 800-565-8941
With a Union similar to this:
choose vContactn from #values for +
'<NEW>', 0 from custcontacts where count = 1 +
union all sel '<VIEW OR EDIT ALL>', -1 from custcontacts where count
= 1 +
union all sel +
( +
(LJS(CUSTNUB2, 10)) & (LJS(CC_contact, 20)) & (LJS(CC_OfficeExt,
3)) & (RJS(CC_Mobile1, 12)) +
& (RJS(CC_HomePhone, 14)) & ' ' & (CC_ActiveStatus) & ' ' &
(CTXT(CC_CallOrder)) +
), CC_ID from CustContacts where CustNub2 = .this_Custnub2 +
at 1 1 foot title .vmsg
I have no more room in my Title area and I was not sure if I coould
include a footer bar.
I was not really looking for a choose but to get the additional info to
the user. Do not want to include the main phone number on every line
item displayed. Not really needed.
I am looking for this;
Main Phone: 800-565-8945
'Contact Office Ext Mobile# Home#'
Tom Smith 2 574-271-5645 574-456-8974
Currently getting all but main phone with the following:
choose vcustcont from #values for +
( (LJS(CC_contact, 20)) +
& (lJS(CC_OfficeExt, 5)) & (RJS(CC_Mobile1, 12)) +
& (RJS(CC_HomePhone, 14)) ) from CustContacts +
where custnub2 = .This_Custnub2 and CC_ActiveStatus = 'Y' +
ORDER BY CC_CallOrder AT 2 1 TITLE 'Contact Office Ext
Mobile# Home#'
Steve
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2008 10:37 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Union Select Question
Steve, This is my interpetation of what you are trying to accomplish.
This is based on the syntax of the latest version of 7.6. vtesttest1 is
the variable containing the customer number selected by user. The syntax
is listed in the ancillary document entitled: "All About The Choose
Command" installed with R:BASE updates.
There are many other possibilities regarding how to restrict and narrow
down the search for your users, for a particular customer.
Regards, Ken
choose vtesttest1 from #values for distinct + ( (LJS(CC_contact, 20)) +
& (lJS(CC_OfficeExt, 5)) & (RJS(CC_Mobile1, 12)) + & (RJS(CC_HomePhone,
14)) ), custnub2 from CustContacts + where CC_ActiveStatus = 'Y' +
ORDER BY CC_CallOrder TITLE 'Contact Office Ext Mobile#
Home#' FORMATTED
----- Original Message -----
From: Steve Breen
Date: Wednesday, November 12, 2008 9:37 pm
Subject: [RBASE-L] - Union Select Question
To: [email protected] (RBASE-L Mailing List)
> I know I am not close.
>
> Any ideas or help would be appreciated.
>
> Clear var vTestTest1
>
> Set var vTestTest1 = 'test test'
>
> choose vcustcont from #values for +
> '.vTestTest1', 0 from custcontacts where count = 1 + union all sel + (
> (LJS(CC_contact, 20)) + & (lJS(CC_OfficeExt, 5)) & (RJS(CC_Mobile1,
> 12)) + & (RJS(CC_HomePhone, 14)) ) from CustContacts + where custnub2
> = .This_Custnub2 and CC_ActiveStatus = 'Y' + ORDER BY CC_CallOrder AT
> 2 1 TITLE 'Contact Office Ext Mobile# Home#'
>
>
>
> Steve
>
>
>
>
>
>
>
>
