Data Environment Designer (Updating)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Data Environment Designer (Updating)

  1. #1
    F. O. Greene Guest

    Data Environment Designer (Updating)


    I have used the Data Environment Designer for reporting from an ACCESS database
    using both code and the Data Report Designer with no problem.
    However, I am now attempting to update the database.

    The following is the basic setup:

    Provider is: Microsoft OLE DB Provider for ODBC Drivers

    The Connection is given Read/Write permision

    SOURCE of Data for Command1 is: SELECT * FROM Database

    Code extracted from the Form1 is as follows:

    DataEnvironment1.rsCommand1.Open
    DataEnvironment1.rsCommand1.MoveFirst
    DBData = DataEnvironment1.rsCommand1![Selected Data]
    '
    ' Intervening Code
    '
    DataEnvironment1.rsCommand1![Selected Data] = NewData ' Point of Error
    DataEnvironment1.rsCommand1.Update

    Error Message: Object or provider is not capable of performing requested
    operation

    Now, Is it true that changing data in the database cannot be done while using
    the data environment or have I failed to set some prameter or failed to provide
    some necessary code?

    Any assistance will be greatly appreciated.
    E-Mail to fgreene2@earthlink.net

    Thank You for Your Consideration





  2. #2
    marc Guest

    Re: Data Environment Designer (Updating)


    Try the following settings (Advanced tab of data envirnmoent properties):

    Cursor Location: 2 - use server
    Cursor Type: 1 - Keyset
    Lock Type: Anything but readonly

    This should work.

    Marc


    "F. O. Greene" <fgreene2@earthlink.net> wrote:
    >
    >I have used the Data Environment Designer for reporting from an ACCESS

    database
    >using both code and the Data Report Designer with no problem.
    >However, I am now attempting to update the database.
    >
    >The following is the basic setup:
    >
    >Provider is: Microsoft OLE DB Provider for ODBC Drivers
    >
    >The Connection is given Read/Write permision
    >
    >SOURCE of Data for Command1 is: SELECT * FROM Database
    >
    >Code extracted from the Form1 is as follows:
    >
    >DataEnvironment1.rsCommand1.Open
    >DataEnvironment1.rsCommand1.MoveFirst
    >DBData = DataEnvironment1.rsCommand1![Selected Data]
    >'
    >' Intervening Code
    >'
    >DataEnvironment1.rsCommand1![Selected Data] = NewData ' Point of Error
    >DataEnvironment1.rsCommand1.Update
    >
    >Error Message: Object or provider is not capable of performing requested
    >operation
    >
    >Now, Is it true that changing data in the database cannot be done while

    using
    >the data environment or have I failed to set some prameter or failed to

    provide
    >some necessary code?
    >
    >Any assistance will be greatly appreciated.
    >E-Mail to fgreene2@earthlink.net
    >
    >Thank You for Your Consideration
    >
    >
    >
    >



  3. #3
    fgreene Guest

    Re: Data Environment Designer (Updating)


    "marc" <whale@ultranet.com> wrote:
    >
    >Try the following settings (Advanced tab of data envirnmoent properties):
    >
    >Cursor Location: 2 - use server
    >Cursor Type: 1 - Keyset
    >Lock Type: Anything but readonly
    >
    >This should work.
    >
    >Marc
    >
    >
    >"F. O. Greene" <fgreene2@earthlink.net> wrote:
    >>
    >>I have used the Data Environment Designer for reporting from an ACCESS

    >database
    >>using both code and the Data Report Designer with no problem.
    >>However, I am now attempting to update the database.
    >>
    >>The following is the basic setup:
    >>
    >>Provider is: Microsoft OLE DB Provider for ODBC Drivers
    >>
    >>The Connection is given Read/Write permision
    >>
    >>SOURCE of Data for Command1 is: SELECT * FROM Database
    >>
    >>Code extracted from the Form1 is as follows:
    >>
    >>DataEnvironment1.rsCommand1.Open
    >>DataEnvironment1.rsCommand1.MoveFirst
    >>DBData = DataEnvironment1.rsCommand1![Selected Data]
    >>'
    >>' Intervening Code
    >>'
    >>DataEnvironment1.rsCommand1![Selected Data] = NewData ' Point of Error
    >>DataEnvironment1.rsCommand1.Update
    >>
    >>Error Message: Object or provider is not capable of performing requested
    >>operation
    >>
    >>Now, Is it true that changing data in the database cannot be done while

    >using
    >>the data environment or have I failed to set some prameter or failed to

    >provide
    >>some necessary code?
    >>
    >>Any assistance will be greatly appreciated.
    >>E-Mail to fgreene2@earthlink.net
    >>
    >>Thank You for Your Consideration
    >>
    >>
    >>
    >>

    >



  4. #4
    fgreene Guest

    Re: Data Environment Designer (Updating)


    Works great!
    Thank You.

    "marc" <whale@ultranet.com> wrote:
    >
    >Try the following settings (Advanced tab of data envirnmoent properties):
    >
    >Cursor Location: 2 - use server
    >Cursor Type: 1 - Keyset
    >Lock Type: Anything but readonly
    >
    >This should work.
    >
    >Marc
    >
    >
    >"F. O. Greene" <fgreene2@earthlink.net> wrote:
    >>
    >>I have used the Data Environment Designer for reporting from an ACCESS

    >database
    >>using both code and the Data Report Designer with no problem.
    >>However, I am now attempting to update the database.
    >>
    >>The following is the basic setup:
    >>
    >>Provider is: Microsoft OLE DB Provider for ODBC Drivers
    >>
    >>The Connection is given Read/Write permision
    >>
    >>SOURCE of Data for Command1 is: SELECT * FROM Database
    >>
    >>Code extracted from the Form1 is as follows:
    >>
    >>DataEnvironment1.rsCommand1.Open
    >>DataEnvironment1.rsCommand1.MoveFirst
    >>DBData = DataEnvironment1.rsCommand1![Selected Data]
    >>'
    >>' Intervening Code
    >>'
    >>DataEnvironment1.rsCommand1![Selected Data] = NewData ' Point of Error
    >>DataEnvironment1.rsCommand1.Update
    >>
    >>Error Message: Object or provider is not capable of performing requested
    >>operation
    >>
    >>Now, Is it true that changing data in the database cannot be done while

    >using
    >>the data environment or have I failed to set some prameter or failed to

    >provide
    >>some necessary code?
    >>
    >>Any assistance will be greatly appreciated.
    >>E-Mail to fgreene2@earthlink.net
    >>
    >>Thank You for Your Consideration
    >>
    >>
    >>
    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center