-
Using Stored Procs for Edit/Add with Oracle 8.x and ASPdb Enterprise
Can I use Oracle stored procedures in ASPdb with Add and Edit modes?
I am using Oracle 8.x, MS Data Access 2.1 (latest MS Oracle ODBC drivers), and ASPdb Enterprise 2.20.
Attached is my very simple ASPdb script. You can see I am able to toggle between commented SP calls and inline SQL statements. When I use the inline SQL, edit appears and works fine. When I use the SQL in a stored procedure, the edit button does not appear?
Nick Matteucci
---- Example ASPdb Script -------
<%
dim Name
dim strSQL
Dim X
Name = "'" & ucase(session.Contents("Name") & "%'"
strSQL = "(;~){call PkgPhone.FindByName(" & Name & ", {resultset 2000, o_Name, o_Department, o_Extension, o_MailRoute, o_WorkStation})}~1"
'strSQL = "Select Name, Department, Extension, MailRoute, WorkStation From
Phone Where Name like " + Name
'Set X=Server.CreateObject("AspDB.EP30"
Set X=Server.CreateObject("AspDB.EP"
X.dbUnit=1
X.dbDBType="ORACLE"
X.dbDSN = "DSN=ivrt; UID=vpmiplay; PWD=vpmiplay; "
X.dbStoredProc=strSQL
'X.dbSQL = strSQL
X.dbNameMap = "o_Name, Name;o_Extension, Extension;o_Department, Department;o_MailRoute, MailRoute;o_Workstation, WorkStation"
X.dbMode = "dual-horz"
X.dbGridTableTag = "Border = 1"
X.dbGridInc = 1
X.dbNavigation = "bottom"
X.dbNavigationItem = "Top, Bottom, Next, Prev, Gridrow, update, edit, add, delete"
X.dbEditFlds = "Name, Department, Extension, MailRoute, WorkStation"
X.dbButtonAnchor=false
Dim EP
EP="TableName=vpmiplay.Phone,BookmarkFlds=0,Cr iteriaSize=4x25,TableTag=Border=2"
'EP = + "EditBookmarkFlds=0,"
'Ep = + " CriteriaSize=4x25,"
'EP = + "TableTag=Border=2"
X.dbEditParams = EP
X.aspDBEP
%>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|