WHen you add a table to the data environment of a form, does it automatically
add any associated Index files? How do I set the controlling index?

I have a table that when added to the data environment, I cannot figure out
the syntax and where do I need to put it to set the controlling Index. And
since this is the case it prevents me from using any 'Seek' function..

Any suggestions....?

When you are using CDX 'Compound index' files,
Vfp will use them with your table automatically.


hth
-Stefan

"ShahJagat" <shahjagat (AT) aol (DOT) com> schrieb im Newsbeitrag
news:20031111175054.20279.00000026 (AT) mb-m04 (DOT) aol.com...

In article <20031111175054.20279.00000026 (AT) mb-m04 (DOT) aol.com>,
ShahJagat <shahjagat (AT) aol (DOT) com> wrote:
As was pointed out elsewhere, with CDXs, you don't have to worry
about this. If you're using IDXs, I don't know if you can get it to
work quite right. You may need to open the tables manually to get the
correct effect. You can do this by setting the DataEnvironment's
AutoOpenTables event to .F., and then USE the tables with the INDEX
clause.

But CDXs are definitely the way to go here, if you can.