Results 1 to 2 of 2

Thread: recordcount

  1. #1
    Join Date
    Dec 1969

    Default recordcount

    created database in sql server and to display the no of records for a particular field. have used the code as<BR>rsuser.Open "Select * from PRUSER where User_name= &#039;" & Trim(txtUserName) & "&#039;", db, adOpenStatic, adLockOptimistic<BR><BR>msgbox rs.recordcount<BR>it is displaying -1 when there is match also.........<BR><BR>pls help me in setting the recordcount in sql server<BR><BR>reply soon<BR><BR>thanks in advance<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: recordcount

    There is a detailed FAQ on this -- have you read it? <BR><BR>Hmmm obviously not <BR><BR>

Posting Permissions

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