2. ASPRunnerPro General questions
  3. Find ID Value of a record
This topic is locked

Find ID Value of a record

 		8/22/2011 11:29:06 AM
ASPRunnerPro General questions
Y
 yairilan author

Hi,

I need to find the value of the ID field when I edit a record.

The problem is that this field isn't shown in edit mode ( Int Key value )

I know I can;t use Dict("ID"), so what parameter will give me the record ID value, in order to use this syntax:



sql = "select email from Tbl_Connectors where ID = ?????????

set rstmp = CustomQuery(sql)


Thanks

Yair
Sergey Kornilov admin 8/22/2011

Which event we talking about and what's the version of ASPRunnerPro?
Y
 		yairilan author 8/22/2011

Hi,

Since today, it's going to be ASPRunner 6.3.

As for the event, I'm almost sure it's before update.
What I need is to check if a dropdown box has been change in the edit event, and send an Email to the relevant person

If it did change.

I don't know if there is a way to do it, so I thought about checking if the DICT value in the dropdown is equal to the value in the table.
Thanks

Yair
Sergey Kornilov admin 8/22/2011

As a first step you need to check ASPRunnerPro manual section that applies to the event you use or plan to use. Manual will show you what parameters are available in each event.
Usually you can use values("FieldName") to access the value of any non-key field and keys("KeyFieldName") to access values of key columns.