Projects
Cursor Types Comparison Table
Submitted by loloyd on Thu, 2007/12/20 - 10:22am.| Attribute/Property | Cursor | ||||
| Enumeration Constant | adOpenUnspecified | adOpenForwardOnly | adOpenKeyset | adOpenDynamic | adOpenStatic |
| Value | -1 | 0 | 1 | 2 | 3 |
| Description | Cursor type not specified. | Default, a forward scrolling only, static cursor where changes made by other users are not visible. | A keyset cursor allows you to see dynamic changes to a specific group of records but you cannot see new records added by other users. | A dynamic cursor with both forward and backward scrolling where additions, deletions, insertions, and updates made by other users are visible. | A static cursor allowing forward and backward scrolling of a fixed, unchangeable set of records. |
| Theoretical Opening Speed | Dependent on provider's default setting | Faster | Slow | Slower | Fast |
| Observable Opening Speed (based on a populated 90-column, 1000-row table) | Data Pending | Data Pending | Data Pending | Data Pending | Data Pending |
| Updateable Recordset | Yes | Yes | Yes | Yes | No |
| Theoretical Update Speed | Dependent on provider's default setting | Faster | Slow | Slower | Fast |
| Theoretical Closing and Releasing Speed | Dependent on provider's default setting | Faster | Slow | Slower | Fast |
| Observable Memory Consumption (parameters to be configured) | Data Pending | Data Pending | Data Pending | Data Pending | Data Pending |
Find anything wrong with the information posted here? Shoot me a feedback!
»
- Login to post comments
- 1568 reads
Database References
Submitted by loloyd on Thu, 2007/12/20 - 10:01am.I intend to post my database realizations in this section. This will be/is like a knowledge-base of some sorts of all database-related material.
»
- Login to post comments
- 1601 reads
Projects
Submitted by loloyd on Fri, 2007/04/13 - 10:01am.Listed below are my featured personal projects.
»
- Login to post comments
- 2390 reads
Project Internet
Submitted by loloyd on Fri, 2007/03/02 - 12:55am.Project Internet is composed of documents, resources and system development concepts that I authored/co-authored/assist in propaganda/brazenly plagiarized involving the Internet in general or its science or its study. It is my hope that this endeavor will ultimately benefit the Internet community as I am only in the pursuit of the advancement of the Internet's best interest. Yeah, right.
»
- Login to post comments
- 1202 reads
