Let
use in select( 'crime' )
precede your code.
But your code is dangerous, of course. How do you ascertain that the field crimedate exists in the table? If you don't do that, the index line will cause an error.
>I am trying to catch the choice of the wrong table name. If a user picks the wrong table, I want to display a messagebox that tells them to choose another file, then on clicking OK the user is returned to the getfile() routine. However, I am getting table is already open errors and must be opened exclusively. I have tried quite a few ideas but the errors persist. There must be a way of doing this. Do you know how?
>
>Here is the main bit of code that I am using to open a table.
>
>
>pcFileName = ""
>pcFileName = Getfile('DBF')
>
>Select 0
>Use (pcFileName) Alias crime Exclusive
>Select crime
>
>Index On crimedate Tag crimedate
>* Set order to that TAG
>Set Order To crimedate
>
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.