>>>Geeeeee...
>>>When i first got the error i immediately changed to single quote, but it still failed...browsing through the history in my command window, i saw why...i used "sele " instead of "select " when i tried the single quote :-)
>>>Thanks!!
>>>If you have an idea for my main issue here, i'll be glad to have it...
>>
>>If you're using ODBC, then the indexes *should* be updated correctly. Are these separate .IDX files? If they are, I don't know what the syntax is for SQLEXEC to be able to use those.
>
>The indexes are separate .ndx files. According to Doug, they should be updated, but i am sure there is something i need to pass through in sqlexec , i just don't know what :-)
>
>Jaime

I don't think .NDX files are opened automatically. There must be some way to open them via ODBC, but I don't know what that would be. I don't see it in the current message, but weren't you using dBaseIII? I don't remember there being a concept of the .CDX like file being opened automatically until dBaseIV, which I had never gotten to use. Discovered the Fox and never looked back at dBase after III+.