November 14th, 2003, 07:43 PM
|
|
Contributing User
|
|
Join Date: Sep 2003
Posts: 67
Time spent in forums: 1 h 57 m 17 sec
Reputation Power: 5
|
|
|
appending list in table
i'm designing a table which has several fields...
I would like to insert records into the tables, for i.e. stock quotes, every minute or so.... however,
the following is my criteria:-
1)I would like to limit the tables to hold only 20 records.
2)every new record inserted, will append to the last line of the table, and the first record in the table will be erased,
secord record becomes first record, third record become secord record..... etc
I'm thinking of remove the first records and follow by insert
new records to the table. that would keep only 20 records in that table.
any suggestion for minimum overhead?
Last edited by alam : November 14th, 2003 at 09:04 PM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
