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
|
|
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]
