Subject variable indexing problem.
From Charlie <tm@tc.com>
Date Mon, 30 May 2022 15:55:49 -0400
Newsgroups dbase.getting-started

Trying to set up user defined which will be consistent even when the programmed is closed then open again.  Tried everything in the book and I am close but need help.

Storing the active index name in a memory table like this:  im.fields["idx"].value = "recno"

Recalling the index on-open like this:  idxname = im.fields["idx"].value

Afterward in on-open trying to set the index like this:
msgbox( '"'+trim(idxname)+'"' )
is.indexname = ('"'+trim(&idxname)+'"')

Message box is for seeing what it looks like.  And it looks exactly as if I used the hard index.

This example gets variable undefined but I have had index doesn't exist with other variations.  Can anyone suggest code that will work?  Really appreciate any help!!