> >
> > The code ran as you posted it. What was the table name and alias you tried?
> > You could do...
> >
> >
select (m.lcmyTable)
> > Use (m.lcmyTable) Exclusive
> >
> > Should be LPARAMETERS.
> >
> > Should remember and reset the current alias. It's been said the reindex is less safe than doing a full script of new indexes. If you used gendbcx to get the indexing code, you could call that from this program.
> >
>
> Mike,
>
> Grr, it must have been the time of the day, last night. You are correct, not a function but a procedure!
> Now it runs like a charm.
> Thanks for correcting me.
>
> Regards,
> Koen
Truth be told, FoxPro does not care if you declare it a function or a procedure. It is only how you call it that matters. This penchant everyone has for putting things in a single file is a big waste of time. If you made that reindexer.prg you would simply drop it in a folder and it's ready to go. If two programmers were to try to edit the procedure library at the same time, without source control, they could not. That argues against the procedure library concept, which by the way, is only needed way back when we did not have long file names!
Mike Yearwood
Microsoft MVP Visual FoxPro 2008, 2009
We have enough youth. We need a fountain of smart!
There may be many ways to skin a cat, but there are very few right ways to do it.
You can't teach an old dog new tricks. Heaven forbid I become a dog or old.