Re: Developer 2000 Create_Group_From_Query

Build your SQL-statement like this:

Declare
  v_sql_statement Varchar(2000);

Begin
  v_sql_statement :=

  'Select f1,f2,f3,f4, date_field '||
  'From table '||
  'Where date_field Between '||
  'To_date('''||Name_in('block.daterange1')||''', ''DD-MON-YYYY'') and '||
  'To_date('''||Name_in('block.daterange2')||''', ''DD-MON-YYYY'');'

• Here goed your code

End;

Kind Regards,
Theo

>
> hello all;
> I am using developer 2000 with forms 4.5.7.1.6 and need some help with the
> Create_Group_From_Query function.
>
> I am trying to have Create_Group_From_Query parse a statement similar to
 this
> 'Select f1,f2,f3,f4, date_field from table where date_field between
> daterange1 and daterange2'
>
> daterange1 and daterange2 come from the user. I get them and concatenate
 them
> to the sql string using the ||. I have tried the dates with quotes and
 without
> quotes and in different formats.
> The sql statement works from within sqlplus however it does not work with
 the
> Create_Group_From_Query. If i take of the where clause it works or if i
 change
> the the date_field part of the where clause to something else it works.
>
> What i am asking in a round about way is has anyone encountered a problem
 like
> this with forms and if so what did you do ?
>
> thanx ahead of time
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Mar 26 1998 - 00:00:00 CST