Bob:
I just run
into the same problem when using a formatted Choose command where blank lines
started to show up. I have not had the time to investigate further but I will
report the result once I find a cause/answer.
Javier,
Javier Valencia, PE
President
Valencia
Technology Group, L.L.C.
14315 S.
Twilight Ln, Suite #14
Olathe, Kansas
66062-4578
Office
(913)829-0888
Fax (913)649-2904
Cell
(913)915-3137
================================================
Attention:
The information
contained in this message and or attachments is intended
only for the
person or entity to which it is addressed and may contain
confidential
and/or privileged material. Any
review, retransmission,
dissemination or
other use of, or taking of any action in reliance upon,
this information
by persons or entities other than the intended recipient
is prohibited.
If you received this in error, please contact the sender and
delete the
material from all system and destroy all copies.
======================================================
-----Original
Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED]On Behalf Of Bob
Castanaro
Sent: Saturday, June 25, 2005
10:50 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: What form
object to use?
Albert,
I actually am getting this data from
a view. I just want to load specific rows into a cobo box or list box or
some sort of object in a form where I can control the location. I looked
at the example Razzak directed me to but I couldn't make it work with my
database. So basically I am stuck using a choose from an eep in a form,
which is OK for now. Now I have a bigger problem. The selection
from that choose then triggers a temporary view. This view is pretty
exotic and contains some slick union operator and works well in DOS. BUT......
Now I find when I write a choose for it and have the _expression_ with
multiple LJS functions, It stars skipping lines in between data rows. Grrrr. That
darn Windows... I have spent 3 hours on one choose command to no avail. I'm
going to have to send this toi RBTI for advice.
thanks for responding
BobC
|
Albert
Berry <[EMAIL PROTECTED]>
Sent by:
[email protected]
06/25/2005 02:23 PM
|
|
To
|
[email protected]
(RBG7-L Mailing List)
|
|
cc
|
|
|
Subject
|
[RBG7-L] - Re:
What form object to use?
|
|
Bob, have you
tried creating a view for this? I use views for choose commands all the time,
with
the view containing exactly two columns. A view for employees for example
would be used as
follows:
SET VAR vCount INTEGER
SET VAR vChoice TEXT
SET VAR vEmpNo INTEGER
SELECT COUNT(*) INTO vCount +
FROM sys_tables +
WHERE sys_table_name = 'vwmEmployees'
IF vCount > 0 THEN
DROP VIEW vwmEmployees
ENDIF
CREATE TEMP VIEW vwmEmployees (Choice,EmpNo) AS +
SELECT (LJS.......),EmpNo FROM Employees +
WHERE someCol = someVar
-- then the choose box reduces to this:
CHOOSE vChoice FROM #VALUES FOR Choice,EmpNo FROM vwmEmployees
--- Bob Castanaro <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I am trying some experimenting with forms to take the place of a long
pile
> of code that executes in a specific sequence.
>
> I have an extravagant choose command that has a few fields and a few
> calculations that is based on a view.
> I can easily run this in an eep, but I want to display this in a box
on
> the form, that can change based on the value of a variable.
Tried some of
> the variable list boxes and even a variable edit with _expression_.
Nothing
> seems to give me the desired result.
> Here is the spaghetti....
>
> IF .VPROCTYPE = "PAIN MANAGEMENT" OR .VPROCTYPE =
"WOUND MANAGEMENT" THEN
> CHOOSE VPROCDATE2 FROM #VALUES FOR +
> ((LJS(DOCTOR,16))+(LJS(OFFDAY,12))+(CTXT(PROCDATE))+"
> "+(CTXT(PROCOUNT))),PROCDATE +
> FROM COFFVIEW WHERE PROCTYPE = .VPROCTYPE AND DOCTOR = .VDOCTOR
+
> ORDER BY DOCTOR PROCDATE +
> TITLE "Choose Schedule Date, [ESC] for New Date" +
> CAPTION "Scheduled days" +
> LINES 20 FORMATTED OPTION TITLE_FONT_COLOR BLUE|TITLE_BOLD ON
>
> Any suggetions for the experts out ther???
>
> TIA
> Bob C.
>
> BTW, I see Razzak is busy tonight with RC2. Heck of a way to
spend Friday
> night!
>
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
