Dan The data in this free table, "comanda", will be saved into my data structure already in place. This will happen when the customer pays and is using a card. If I delete the record, i can use an autoinc primary key and search for the card #( regular index), no need for a composite key. Then every time the program is run i check if i have exclusive
access to the table and do the packing. E. > Yeah, I guess that would work. But I don't like "manual". In the past i have > used the >> windows schedule thing to start a program to clean up things. Didn't work >> very >> well, sometimes would skip a day. I would need something in the program. >> >> >> I could have some kind of garbage collection to reuse records. Will that be >> faster ? >> > >Eurico > >I don't see wasting much time/effort worrying about packing the deletes >out - disk is cheap and computers are fast. I agree that the detail >transaction data should be in a free table. You can timestamp each >swipe, thus creating a transaction history that you can analyze if needed. > >You do need to be sure that each _issuance_ of the card has a unique ID >- in otherwords, when the card is turned in and cleared, the previous >transaction is closed out and the next swipe of the card generates a >whole new sequence. If the cards are pre-printed, then if a card is >swiped that does NOT have an open transaction, you generate a new >transaction sequence #. The card # plus the transaction # identify the >customer/instance, no matter how many times he swipes the card. > >Anyway, it matters little whether you clear/pack the table daily or >weekly (or whenever). > >Dan Covill > > > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
