SQLSelect.GoBottom Method |  |
Position the data server on the last row.
Namespace: VO
Assembly: VOSQLClasses (in VOSQLClasses.dll) Version: 2.21
SyntaxRemarks
Sends a NotifyGoBottom message, if successful.
 Tip |
|---|
| If the database supports scrollable cursors (see SQLConnection:ScrollCsr), then record numbers will be negative relative to the bottom (see SQLSelect:RecNo). If not, all records will be buffered, to simulate positioning. Use with caution, since large result sets may degrade performance. You can disable the buffering with the SQLSelect:BufferData() method. |
Examples
The following example demonstrates the value that SQLSelect:RecNo returns after the SQLSelect:GoBottom() method is called:
X#
1oCust := SQLSelect{"SELECT * FROM customer"} 2oCust:GoTop() 3? oCust:RECNO // Prints 1 4oCust:Skip() 5? oCust:RECNO // Prints 2 6oCust:GoBottom() 7? oCust:RECNO // Prints -1 8oCust:Skip(-1) 9? oCust:RECNO // Prints -2 10oCust:GoTop() 11? oCust:RECNO // Prints 1 12oCust:Skip() 13? oCust:RECNO // Prints 2
See Also