Hi All
I have a database of MapInfo tables including paths. I also have a
database of all our workspaces. I have produced a script to count the
number of times each table is opened in these workspaces. This takes
each Open Table statement and loops through the tables database
searching for each value in the database against it i.e.
pos = InStr(1, LCase$(opentablestatement), mapinfotablename)
If pos > 0 Then
increment count
etc.
But I'm not happy. I've done it this way because I couldn't find a way
to extract the table path & name from an open table statement. MapInfo
doesn't, for instance, allow you to define custom delimiters (") and get
the String between. If I were able to I could query the tables database
for the for the table path & name. This would be very much quicker. (We
have a lot of tables and workspaces!). And my life would be improved no
end.
I also considered that I might Run each Open Table statement and then
obtain the table path and name from the last table opened and then use
this to search the database. Still can't do.
Can anyone help with this?
In anticipation, thank-you.
Simon Allen, Senior GIS Officer
[EMAIL PROTECTED]
South Gloucestershire Council
Council Offices
Castle Street
Thornbury
South Gloucestershire
BS35 1HF
phone: 01454 863655 (direct)
fax: 01454 863855
http://www.southglos.gov.uk
**********************************************************************
This email and any files transmitted with it from South
Gloucestershire Council are confidential and intended
solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error
please notify the South Gloucestershire Council
Postmaster at the address below.
This footnote also confirms that this email message has
been swept for the presence of computer viruses.
[EMAIL PROTECTED]
**********************************************************************
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
