Execute SELECT @@Action after MS-SQL edit action.

Product Version

Property Value

Keyword1 | keyword2...

QuickProp Keyword Abbreviation

Remarks

User specify the keyword(s) and SELECT @@keyword as 'dummy' will be executed after the edit action (like INSERT / UPDATE). User is responsible whether this action retrieval is appropriate by specifying this option. To retrieve the variable, use Tornado.Getdata.Get_SELECT_ATAT(Unit). If more than one items are returned then it'll be separated by a [CR] to be parsed.

Example

<script language="vb" runat="server">;
  Sub Page_Load(Source as Object, E as EventArgs)
    Dim GD as New Tornado.Getdata()
    Dim ATAT As New Tornado.Z
    Dim GD As New Tornado.GetData
    With ATAT
     .dbQP = "U=99|dt=SQL|Pv=OLEDB|bm=jobs;0|eaf=1,2,3|gdf=0,1,2,3|ni=b5,Add"
        .dbDSN = "fujitsu;pubs;sa;sa"
        .dbEditSelectATAT = "identity"
        .dbSQL = "SELECT * FROM jobs"
        .ASPdbNET()
        Response.Write("SELECT @@IDENTITY=" &amp; GD.Get_SELECT_ATAT(99))
       End With
</script>

See Also

z Class | Tornado Namespace | Get_SELECT_ATAT | Special Topic - Edit

---