Ubound på ADODB.Recorset's

what do you mean by elements? Records or columns?

Jeg mener man kan bruge:

  rst.MoveLast
  msgbox rst.RecordCount

Det bedste vil dog være at lave et ekstra kald: SELECT COUNT(*) FROM ... WHERE ...

Jeg mener hvor mange records der er! Forstår du?

Ja, men det var ikke lige det der var meningen! ...og rs.MoveLast kan man ikke bruge!! Ellers tak!

.recordcount

Use the MoveLast method to move the current record position to the last record in the Recordset. The Recordset object must support bookmarks or backward cursor movement; otherwise, the method call will generate an error.

A call to either MoveFirst or MoveLast when the Recordset is empty (both BOF and EOF are True) generates an error.

RecordCount Property
Indicates the number of records in a Recordset object.

Return Value
Returns a Long value that indicates the number of records in the Recordset.

Remarks
Use the RecordCount property to find out how many records are in a Recordset object. The property returns -1 when ADO cannot determine the number of records or if the provider or cursor type does not support RecordCount. Reading the RecordCount property on a closed Recordset causes an error.

Ja, men den viser altid -1

Så kig på mit andet forslag...

SELECT COUNT(*) FROM ... WHERE ...

Hvor FROM og WHERE er de samme, som i dit oprindelige kald...

dimle> What shows -1?
Are you sure that you actualy have any errors?

IF YourRs.EOF and YourRs.BOF then YOU HAVE NO RECORDS

You should REJECT answers without making sure that your problem isnt at your end!

You should REJECT = You should NOT REJECT

Ja det ved jeg godt man kan men jeg vil ha VB til det!!!

Terry - det ved jeg! Det er rs.recordcount der altid er -1, fordi det ikke understøttes af provideren!

dimle> put this in your code and replace YorRs with the correct name of the recordset

IF YourRs.EOF and YourRs.BOF then MSGBOx "I have an error!"

Jeg er ikke nybegynder så jeg ved at mange af foreslagene ikke virker!

Så må du:

  DIM tæller AS Long
  WHILE NOT rst.EOF
    tæller=tæller+1
    rst.MoveNext
  WEND
  MsgBox tæller

and .movelast doesnt either?

So you will have to make a recordset containing a select as proaccess shows.

Ja det er en fin sikker metode, men tidslompleksiten for den er O(antal records) så den er langsom!!

Ja det er en fin sikker metode, men tidslompleksiten for den er O(antal records) så den er for langsom!!

dimle
Make a recordset just like when you make one for your table.

SELECT COUNT(*) As RECORDNUMBER FROM ... WHERE ...

Then
rs!RECORDNUMBER will give you the count

WHAT IS WRONG WITH SELECT COUNT(*) ?

dimle>what is your provider?

Det er en simpel 4.0 Microsoft.Jet provider!

Access? Sounds VERY strange that you cant use use .recordcount and .Movelast !

Do you have a primary key on the table? If not then I would suggest that you have one

again, why cant you use SELECT count(*)

Når jeg bruger rs.MoveLast kommer den med fejlen: The rowset does not support fetching backwards!

dimle>You arent helping very much! If you answer the comments then we have some idea as to where to look instead of just rejecting!

why cant you use SELECT count(*)

dimle>read my comment 12:36! It states that you will get -1 if ADO cannot determine the number of records or if the provider or cursor type does not support RecordCount!
WHY DOES an Access dB NOT support this?
WHY CAN YOU NOT USE SELECT COUNT (*)
DO YOU HAVE A PRIMARY KEY

CAN YOU ANSWER THESE QUESTIONS OR CLOSE IT?

Det har jeg allerede besvaret - fordi jeg ville have VB til det!
...men... Jeg er ikke ret god til SQL Kan man ikke lave et kald hvor man får alle felter i en tabel sammen med den du foreslog: COUNT(*) As RECORDNUMBER sådan her, eller hvordan gør man??

SQL = "SELECT *, COUNT(*) As RECORDNUMBER FROM Bandene"

dimle>If we can find out WHY .recordcount is not supported then you may not need to do it any other way!

WHY DOES an Access dB NOT support this? (.movelast .recordcount) is it becuase ther is no primary key, or maybe your code is selecting the wrong way?

Den har primary-key og den udvælgen virker fint! Jeg ved ikke hvorfor Access ikke understøtter (.movelast .recordcount)!

Hvis du kan svare på spørgsmålet fra kl.: 14:17:23 med:
SQL = "SELECT *, COUNT(*) As RECORDNUMBER FROM Bandene"
...så får du pointerne for dette spørgsmål!!!

SELECT *, DCount("*", "Bandene") AS Antal FROM Bandene"

Giver dårlig performance, da der tælles en total for hver record i dit recordsæt...

Hvis du kørte det i 2 forespørgelser ville det være MEGET bedre... Som jeg fortalte for l-a-n-g tid siden...

Nej det ville ikke give bedre performance - Det er undersøgt! SELECT *, DCount("*", "Bandene") AS Antal FROM Bandene" er ca. 1/3 hurtigere end din metode!!!!!

tak :o)

Whatever you say... bare DU er tilfreds...

SELECT *, DCount("*", "Bandene") AS Antal FROM Bandene" virker da ikke???

og

SELECT *, Count("*", "Bandene") AS Antal FROM Bandene" virker heller ikke! Der er et forkert antal argumenter!

SELECT *, DCount("*"; "Bandene") AS Antal FROM Bandene"

SELECT *, DCount("*"; "Bandene") AS Antal FROM Bandene" virker heller ikke! Den siger at der er syntaksfejl i udtrykket???

Prøv med et feltnavn i stedet for *...

SELECT *, DCount("[ID]", "Bandene") AS Antal FROM Bandene

Nu siger den at der er en ikke-defineret funktion "DCount" i udtrykket!???

Prøv så med:

SELECT *, (SELECT COUNT(*) FROM Bandene) AS Antal FROM Bandene

Det virker!!!!!! Mange tak!!