Subject Re: reindex From Cornelius <jcmsoftware@gmIL.COM> Date Tue, 02 Jun 2020 04:29:25 -0400 Newsgroups dbase.getting-started Mervyn Bick Wrote: > On 01/06/2020 15:18, Cornelius wrote: > > Hi there, > > > > In dbase12 I have a database called SYSTEM12 and a table HPCUS wit a few indexes. > > In coding if I run SYSTEM12.reindex(hpcus) will it reindex or not. > > > > Thanks > > > > Cornelius. > > > > Depends.  If you are referring to a database alias defined in the BDE or > defined as a User BDE alias then no, it won't work. > > If SYSTEM12 is a active database object in a form or program then yes, > it will work. > > SYSTEM12 = new database() > SYSTEM12.databasename = 'SYSTEM12' //i.e your database alias > SYSTEM12.active = true > SYSTEM12.reindex('hpcus') > SYSTEM12.active = false > > > Mervyn. Morning Mervyn. Thanks for info. Happy now it will work. Nice day and thank you. Cornelius