Hello everybody,
I'm also about to embark on a project that duplicates some of the
functionality of a FileMaker database. I've already tacked together
a rough prototype of the project, but I thought I'd ask for some
ideas and suggestions before going too far.
The project, which is really a user interface to a large membership
directory, will contain approx. 4000 records. I'll want to sort by
any of the 20-some-odd fields, as well as search for keywords in
those fields. Finally, I'll want to print at least two different
types of reports of the data.
At present, I'm sorting the list in this way:
sort lines of gText by item tWhichColumn of each
and I'm finding matches for keywords by using a repeat loop:
repeat for each line i in tVar
if tSearchItem is in item tWhichColumn of i then
put x & cr after tAnotherVar
end if
end repeat
But I'm wondering if there's a better (faster?) way to do this. Would
an associative array be useful? Is there a better way to do searches
through the data? I know there's a matchText and matchChunk
function, but don't know if it's appropriate here. I'd sure
appreciate any suggestions from those who have already been down this
road.
Thanks very much,
Craig
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
Craig Spooner
Instructional Multimedia Specialist
Office of Instructional Services
Colorado State University
(970) 491-2516
This is the MetaCard mailing list.
Archives: http://www.mail-archive.com/metacard%40lists.best.com/
Info: http://www.xworlds.com/metacard/mailinglist.htm