Board index » off-topic » Local index
Denville Longhurst
Delphi Developer |
Denville Longhurst
Delphi Developer |
Local index2005-01-03 08:20:54 PM off-topic1 Is it possible to set up local indexing on a table so that different users can view different orders? In dBase one would write something like USE MYFILE then INDEX ON SOMETHING to C:\TEMP. This left the main table unchaged and gave everyone their favourite view. Thanks, Denville Leeds, England |
Steven Green
Delphi Developer |
2005-01-03 08:35:18 PM
Re:Local index
Denville Longhurst wrote:
QuoteIs it possible to set up local indexing on a table so that different users multiple secondary indexes, then have different users attach to different indexes.. and the indexes stay with the tables.. Diamond Software Group www.diamondsg.com/main.htm Paradox Support & Sales - Corel CTech Paradox --------------------------------------------------- Diamond Sports Gems www.diamondsg.com/gemsmain.htm Trading Cards and other Sports Memorabilia --------------------------------------------------- |
Bill Todd
Delphi Developer |
2005-01-03 10:09:08 PM
Re:Local index
You are usually wasting your time when you ask a database question and do
not tell us what database you are using. Another alternative is a SELECT query with an ORDER BY clause. -- Bill Todd (TeamB) TeamB cannot answer questions received via email {smallsort} |
Denville Longhurst
Delphi Developer |
2005-01-03 10:44:14 PM
Re:Local index
So sorry, I am using C++ Builder version 6 and the native dBase table type.
I access through a standard TTable/TDataSource/TDBGrid combination. Denville. "Denville Longhurst" < XXXX@XXXXX.COM >wrote in message QuoteIs it possible to set up local indexing on a table so that different users |
Bill Todd
Delphi Developer |
2005-01-03 11:35:18 PM
Re:Local index
I am not a dBase person but you should be able to use either multiple
indices as Steve suggested or a query with an ORDER BY clause. -- Bill Todd (TeamB) TeamB cannot answer questions received via email |
Rick Carter
Delphi Developer |
2005-01-04 01:17:53 AM
Re:Local index
"Denville Longhurst" < XXXX@XXXXX.COM >wrote:
QuoteSo sorry, I am using C++ Builder version 6 and the native dBase table type. My experience is with Delphi. Most of the Delphi users with dBASE expertise can be found at the *.database.desktop newsgroup. You may want to try posting at the equivalent newsgroup, borland.public.cppbuilder.database.desktop Rick Carter XXXX@XXXXX.COM Chair, Delphi/Paradox SIG, Cincinnati PC Users Group |
Denville Longhurst
Delphi Developer |
2005-01-04 04:23:17 AM
Re:Local index
Sincere thanks for all replies.
Denville. "Denville Longhurst" < XXXX@XXXXX.COM >wrote in message QuoteIs it possible to set up local indexing on a table so that different users |