AppendSequence.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 10 Jul 2008 at 1:54am |
This sample demonstrates appending of sequential values in continuation to those existing in the target table (Reference ADO 2.1). Following situations are covered (separately for batch mode as well as data entry mode- (a) Straight primary sequence of numbers. (b) Parallel sequences of strings - datewise. (c) Parallel sequences of strings - yearwise. (d) Parallel sequences of strings - yearmonthwise In addition, data entry mode is demonstrated for (i) Alphanumeric sequential values (multiple parallel series) (ii) Linked sub-sequential values (iii Formatted sequential numbers In Batch Mode, the above objectives are achieved through append queries (marked by faster execution as compared to stepping through recordset loops). Caution - The append queries make use of global variables through user defined functions. While such an approach works nicely for single pass action queries (as in current case), it is not recommended for display oriented queries (e.g. select query etc.) as the calculated values are highly volatile (mere navigation through the column will keep disturbing the values).
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |