single value from multivalue list

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   We use the FTD all the time to move data to excel. We have a front end to help our users select information.

One problem that we have ever gotten to work right is exploding a specific value from a multivalued list. For instance:

sselect p.checks by-exp ded.code = "13"

If we list this at TCL, we get only the deduction code (and amounts) for this code.

Normally, we would execute this statement (or some variant) and type type FTD

we get either

1) all deduction codes in the same cell with "value marks" between the data

or 

2) we do the "explode multivalues" and we get each multivalue on a separate row. however, we get all multivalues, not the one that we tried to select

Anyone solved this issue in some fashion. 

Right now we write custom programs, put the specific data into a tmp file and download that. It would be nice to skip some of these routines and just use FTD.

Thanks.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jtillia Members Profile Find Members Posts Beta Tester Joined: August 03 2004 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote jtillia Report Post Thanks(0) Quote Reply Topic: single value from multivalue list Posted: October 02 2007 at 3:18am
	We use the FTD all the time to move data to excel. We have a front end to help our users select information. One problem that we have ever gotten to work right is exploding a specific value from a multivalued list. For instance: sselect p.checks by-exp ded.code = "13" If we list this at TCL, we get only the deduction code (and amounts) for this code. Normally, we would execute this statement (or some variant) and type type FTD we get either 1) all deduction codes in the same cell with "value marks" between the data or 2) we do the "explode multivalues" and we get each multivalue on a separate row. however, we get all multivalues, not the one that we tried to select Anyone solved this issue in some fashion. Right now we write custom programs, put the specific data into a tmp file and download that. It would be nice to skip some of these routines and just use FTD. Thanks.