> another point that I did not make clear. The accounting programs are not > associated with the technical programs, different people, different security > access. The tech databases and programs are in portable computers that go out > in the field, but not the accounting, etc. There indexes would have to be > updated when the computers are back at the office.
I have a feeling that what the OP is calling an index isn’t really. I think what he is talking about is the list of customer IDs. So customer data can get updated “back at the office” and when the portable computers get back they need to be updated with the changes. In sqlite terms, an index is a sorted list of the data in one or more columns of a table to help speed up access to the data in that table. Once defined, the index is automatically updated by sqlite as the data in the table is changed. Perhaps we could get some clarification from the OP about what is actually wanted. Regards Andy Ling ********************************************************************** DISCLAIMER: Privileged and/or Confidential information may be contained in this message. If you are not the addressee of this message, you may not copy, use or deliver this message to anyone. In such event, you should destroy the message and kindly notify the sender by reply e-mail. It is understood that opinions or conclusions that do not relate to the official business of the company are neither given nor endorsed by the company. Thank You. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
