|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Rs.MoveLast doesn’ go to last record
Hello, have the following code
-------------------------------------------- SQLstm = “select xpto from table” rs.Open SQLstm,1,1 rs.MoveLast ---------------------------------------------- the sqlServer table has 50 records and my rs.MoveLast doesn’t put the cursor in last record. Most times goes to 49 or 48 position. Until 45 records it went ok Please, Anyone
__________________
atferraz |
|
#2
|
||||
|
||||
|
Are you sure there are 50 records with valid "xpto" fields?
What do you mean that it goes to 48th or 49th position? Are you sure it isn't just using a different order than what you are expecting? If there is a "counter" field which gets incremented in every insertion, try "SELECT ID, xpto from table" and see if it were in the order you are expecting. |
|
#3
|
|||
|
|||
|
Thanks OldJacques. Problem soved with order by clause
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Rs.MoveLast doesn’ go to last record |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|