DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Automatic Counters Fields

  1. #1
    Sylvain Forget Guest

    Automatic Counters Fields


    15 days ago I sent a message requesting help on getting the value of an automatic
    counter field. I got some answers back but I don't think I made my request
    clear enough. So I'll try again.

    I'm using Visual Basic 6.0 SP3, ADO Data Access Object Library 2.1 through
    the Data Environment and the data is on an Microsoft SQL Server 7.0.

    A good fellow replied to me to use something like this

    Set rst - db.OpenRecordset("Select * from tblTest")

    With rst
    .AddNew
    .Move 0, .LastModified
    lngAutoNumber = !ID
    End With

    This sounded very promissing, but there was only one thing, my Recodset Object
    does not have a .LastModified propertie what do I do now?

    Thanks in advance

  2. #2
    Paul Little Guest

    Re: Automatic Counters Fields

    As you've discovered, ADO's Recordset object doesn't have the LastModified
    property like DAO did. For a solution to your problem, have a look at:

    http://www.able-consulting.com/ADO_Faq.htm#Q9

    HTH, Paul
    --
    Paul Little, Senior Programmer/Analyst
    SVi Retail Systems
    San Diego, CA

    "Sylvain Forget" <sforget@hotmail.com> wrote in message
    news:39381758$1@news.devx.com...
    >
    > 15 days ago I sent a message requesting help on getting the value of an

    automatic
    > counter field. I got some answers back but I don't think I made my request
    > clear enough. So I'll try again.
    >
    > I'm using Visual Basic 6.0 SP3, ADO Data Access Object Library 2.1 through
    > the Data Environment and the data is on an Microsoft SQL Server 7.0.
    >
    > A good fellow replied to me to use something like this
    >
    > Set rst - db.OpenRecordset("Select * from tblTest")
    >
    > With rst
    > .AddNew
    > .Move 0, .LastModified
    > lngAutoNumber = !ID
    > End With
    >
    > This sounded very promissing, but there was only one thing, my Recodset

    Object
    > does not have a .LastModified propertie what do I do now?
    >
    > Thanks in advance




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