Hello, You would have to have some kind of limit to the number of variables set up as your input parameter, maybe the number of select fields in the table if you have to. Then when you read them in, you would set them up as a variable. If any of the total are blank you need to set them to null. For example, say your table has the ability to select 9 fields. You would have 9 variables for the select fields, say $dummy1, $dummy2, $dummy3. let $dummy1 = '' let $dummy2 = '' etc. then in your begin-select, you would have: begin-select [$dummy1] &dummy1=char [$dummy2] &dummy2=char from .. where... There are a few constraints doing it this way, but it does allow it to be dynamic. hope that helps. Rachael > -----Original Message----- > From: "Sangameswaran Subathra (KAWP 12)" > <subathra.sangameswaran@CSFS.COM>@INTERNET > Sent: Tuesday, January 15, 2002 7:06 AM > To: SQR-USERS@list.iex.net > Subject: Dynamic query > > > Hi, > > I want to input as parameter, all the 'select-fields' for my query. > The no. of fields I want to select each time is also uncertain. > I plan to get all the fields as separated by commas which I can parse and > count. > But how do I use the same in the 'begin-select' clause? > The resultset I require is just a csv file. Therefore I think I will not > encounter any problem in writing the results. > If anybody have done this before, or has any idea as to how this can be > done, could you please help me? > > Thanks and best regards, > Subha. > (See attached file: C.DTF)
Attachment:
C.DTF
Description: Binary data