Select Formula

[2005 IR Help]

By: roberto71 - roberto71

Select Formula

2004-11-24 23:30

It's possible to set a select formula at runtime ?

I can use parameter in where condition or order by.

 

i would like to set directly where condition and order by.

 

Is it possible ?

 

Thank You

 

 

 

 

By: Teodor Danciu - teodord

RE: Select Formula

2004-11-25 02:36

 

Hi,

 

Check the "query" sample provided.

 

Thank you,

Teodor

 

 

 

 

 

By: roberto71 - roberto71

RE: Select Formula

2004-11-25 03:34

Ty Teodor,

i have check the "query" sample.

But this use Parameter Field to customize the select.

I need to do it without using parameter fields.

 

 

 

 

 

 

By: roberto71 - roberto71

RE: Select Formula

2004-11-25 23:13

I have resolve my problem:

 

in the query string i have set:

 

SELECT * FROM MYTABLE $P!{MYPARAMFIELD}

 

at runtime i set the value of MYPARAMFIELD to:

 

where MYTABLE.MYFIELD is not null ORDER BY MYTABLE.MYFIELD

and so on..

 

now it works!