Results 1 to 4 of 4
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: count record in field (6.0)

    RSD1.Open "SELECT Count(MATR) AS Cnt FROM STAFF , CNSQL2, adOpenStatic, adLockReadOnly"

    You have forgotten the closing " at the end of the SQL string, so VB has placed it at the end of the line...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: count record in field (6.0)

    By the way, is that really your password?
    And is the IP address of the server real?

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: count record in field (6.0)

    you have 1.000.000 of eyes <img src=/S/artist.gif border=0 alt=artist width=34 height=29>

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    count record in field (6.0)

    Edited by HansV to mask username, password and IP address

    Have error 3709 when the code count records ion filed MATR of tabel STAFF

    CNSQL2.CursorLocation = adUseServer
    CNSQL2.CommandTimeout = 120
    CNSQL2.Open "Provider=SQLOLEDB.1;Password=***;Persist Security Info=True;User ID=***;Initial Catalog=DB_PAST_DUE;Data Source=***SQLEXPRESS"
    'error here
    RSD1.Open "SELECT Count(MATR) AS Cnt FROM STAFF , CNSQL2, adOpenStatic, adLockReadOnly"
    'error here
    CONTA_REC = RSD1.Fields("Cnt")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •