>I am using INDEXSEEK in the stored proc. of my DB to check on the validity of the primary key that I am about to assign. The call is as follows:
>
> IF INDEXSEEK(m.cKey, .f., m.cTable, "PKey")
>
>Works great on my machine, whether from within VFP6 or via the EXE file of the app. On site, however, whenever it is invoked, the error message "Cannot find file INDEXSEEK.PRG" (or words to that effect) pops up. I had the client check the \WINDOWS\SYSTEM folder--the VFP6 DLL's are in place. Any ideas out there as to what might be going on??
>
>TIA.
>John
You should not have to check the PK. By definition, it is unique for every record and is NOT user generated. Define a field as the PK and have a stored procedure generate the PK using the default value defined in the DBC. If you need more information, see the article on my web site.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer