Hi
I am currently trialing version 6.1 o ASP Runner
When I ran an application on 6.1 (which was running perfect in 5.2) I get the below error message on the page
Microsoft VBScript compilation error '800a03f7'
Expected 'Function'
/SOP/include/MainTableSOP_events.asp, line 163
exit sub
-----^
I have written a custom code below for that page.
I dont understand how its not working on version 6.1 but works perfect on 5.2
=============================================
strNo =" "
strSQLExists = "Select SOPNo from SOPNo "
set rsExists = CreateObject("ADODB.Recordset")
rsExists.Open strSQLExists, dbConnection
if not rsExists.eof then
strSQLExists = "Update SOPNo set SOPNo=SOPNo+1"
dbConnection.Execute strSQLExists
Session("SOPNo") = "SOP" & rsExists("SOPNo")
'Response.write "Item No. = " & Session("ItemNo")
strNo = Session("SOPNo")
strScript = "<script>document.forms.editform.value_SOPNo.value='" & strNo & "'; document.forms.editform.value_SOPNo.readOnly=true;</script>"
Response.write strScript
else
strScript = "<script>alert('SOP No. cannot be created. Contact Administrator!.'); window.location = 'MainTableSOP_list.asp'; </script>"
Response.write strScript
strNo="000"
exit sub
end if
rsExists.Close : set rsExists = Nothing
=================================================
Kind Regards
S Rajan
