Results 1 to 2 of 2

Thread: can't display edit button with X.dbRecordset ?

  1. 09-15-2000, 11:13 AM #1
    Pierre Carbonnelle Guest

    can't display edit button with X.dbRecordset ?

    It looks like it's not possible to display the add, edit, update, delete buttons when passing an ADO recordset to Aspdb. Is there a work-around ? Is it that I open the recordset in the wrong way ?

    The page works OK, except that the button does not appear. When I use X.dbMdb instead, it works fine.

    The code is as follows:

    <html><body>
    <%@ Language=VBScript%>
    <% Dim conn, rs, x

    Set conn = server.createObject(&#34;adodb.connection&#34
    conn.Provider = &#34;Microsoft.Jet.OLEDB.4.0&#34;
    conn.Properties(&#34;Data Source&#34.Value = &#34;d:BizBuildSamplesOrder Entry (tour).mdb&#34;
    conn.Open

    Set rs = server.createobject (&#34;adodb.recordset&#34
    strRs = &#34;select ezDeleted, orderNum, num, quantity, productcode, productDescription, unitprice, amount, ezCreationDate from orderLine&#34;
    rs.Open strRS, conn, 1, 2 &#39;keyset, adlockpessimistic

    Set X=Server.CreateObject(&#34;AspDB.Pro&#34
    X.dbRecordSet = rs &#39;can&#39;t have add, update, edit and delete button ??

    X.dbUnit = 101
    X.dbMode = &#34;Dual&#34;
    X.dbImageDir=&#34;../images/&#34;
    X.dbNavigationItem=&#34;top, bottom, next, prev, gridrow, color, filter, download, add, update, edit, delete&#34;
    X.dbNavigationIcon=&#34;std&#34;

    X.dbEditParams=&#34;TableName=orderLine,BookMarkFl ds=ezCreationDate&#34;
    X.dbEditFlds=&#34;1,3,4&#34;

    X.ASPdbpro

    rs.Close: Set rs = Nothing
    conn.Close: Set conn = Nothing
    %>
    </body>
    </html>

    Thanks in advance.
    Pierre C.
    Reply With Quote Reply With Quote
  2. 09-15-2000, 11:17 AM #2
    Pierre Carbonnelle Guest

    can't display edit button with X.dbRecordset ? (reply)

    OK I found it. I need to specify the cursorlocation= adUseClient.


    ------------
    Pierre Carbonnelle at 9/15/00 12:13:12 PM

    It looks like it&#39;s not possible to display the add, edit, update, delete buttons when passing an ADO recordset to Aspdb. Is there a work-around ? Is it that I open the recordset in the wrong way ?

    The page works OK, except that the button does not appear. When I use X.dbMdb instead, it works fine.

    The code is as follows:

    <html><body>
    <%@ Language=VBScript%>
    <% Dim conn, rs, x

    Set conn = server.createObject(&#34;adodb.connection&#34
    conn.Provider = &#34;Microsoft.Jet.OLEDB.4.0&#34;
    conn.Properties(&#34;Data Source&#34.Value = &#34;d:BizBuildSamplesOrder Entry (tour).mdb&#34;
    conn.Open

    Set rs = server.createobject (&#34;adodb.recordset&#34
    strRs = &#34;select ezDeleted, orderNum, num, quantity, productcode, productDescription, unitprice, amount, ezCreationDate from orderLine&#34;
    rs.Open strRS, conn, 1, 2 &#39;keyset, adlockpessimistic

    Set X=Server.CreateObject(&#34;AspDB.Pro&#34
    X.dbRecordSet = rs &#39;can&#39;t have add, update, edit and delete button ??

    X.dbUnit = 101
    X.dbMode = &#34;Dual&#34;
    X.dbImageDir=&#34;../images/&#34;
    X.dbNavigationItem=&#34;top, bottom, next, prev, gridrow, color, filter, download, add, update, edit, delete&#34;
    X.dbNavigationIcon=&#34;std&#34;

    X.dbEditParams=&#34;TableName=orderLine,BookMarkFl ds=ezCreationDate&#34;
    X.dbEditFlds=&#34;1,3,4&#34;

    X.ASPdbpro

    rs.Close: Set rs = Nothing
    conn.Close: Set conn = Nothing
    %>
    </body>
    </html>

    Thanks in advance.
    Pierre C.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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