2. ASPRunner.NET General questions
  3. On Load Event
This topic is locked

On Load Event

 		5/2/2007 8:29:42 AM
ASPRunner.NET General questions
D
 dcrera author

Hi,
On the Edit form I want to do the following query and have the field _displayed_on the form :
select substr(rtrim(town_city)||' '||rtrim(suburb)||' '||rtrim(STREET_NO)||' '||rtrim(STREET_NAME)||' '||

rtrim(table_desc)||' '||rtrim(SHORT_DESC_2),1,200) Address,

decode(work_req_type,'DC','Credit','DP','Prepaid','ChangeOver') Method

from msf541 a, msf011 b, msf010 c

where a.request_id,' ') = da_number

and a.location = b.location(+)

and c.table_type = 'SLOC'

and c.table_Code = rtrim(street_position,' ');
How can I do this using the On event trigger ?
Thanks
Eugene 5/2/2007

You should edit generated file manually. Please, open and edit *_edit.aspx file. You should find control SqlDataSource and edit its properties: SelectCommand and UpdateCommand.

If necessary, edit SelectParameters and UpdateParameters as well.
D
 		dcrera author 5/2/2007

Oops, I posted this in AspRunner, should have been PhpRunner

You should edit generated file manually. Please, open and edit *_edit.aspx file. You should find control SqlDataSource and edit its properties: SelectCommand and UpdateCommand.

If necessary, edit SelectParameters and UpdateParameters as well.