Arnon,

I discovered this method just before I read you message. I have successfully created an out-of-process server (.dll) with an OLE public class which has methods to do some of these things. I have never programmed in XBase before, and I am finding it a bit exasperating.
I will be purchasing some books on the subject; can you recommend any books which cover using Visual FoxPro 5.0 as an automation server?

I have created very simple methods such as LockRecord:

PARAMETERS strTable

fStatus = LOCK(strTable)

RETURN fStatus

and UnlockRecord:

PARAMETERS strTable

UNLOCK IN strTable

I receive an error message telling me that "Alias STRTABLE not found" when I call these from vb with the name of a table (ex: objMyObject.LockRecord("tblcpar") ). Am I supposed to pass the parameters differently?

Thanks for your time.

Brian Hartin
MCI Telecommunications
Brian.Hartin@MCI.Com



>you can always create a VFP automation server instantiate it in VB and
>perform the tasks mentioned below
>
>Arnon
>
>
>>
>>I am trying to access Visual FoxPro 5.0 tables from a VB 5.0 application
>>and I have three questions:
>>
>>1. Can I reindex the database from VB?
>>2. Can I pack and remove records marked for deletion from VB?
>>3. I have written a stored procedure to generate an incremental index
>>for new records in my tables. This procedure
>>works well in VFP, but when I add records from VB it doesn't work at all.
>>Why is this? I thought stored procedures were supported for external
>>access as long as they didn't contain unsupported XBase commands, as
>>specified in the VFP ODBC driver help file?
>>
>>Thanks,
>>
>>Brian Hartin
>>MCI Telecommunications
>>Brian.Hartin@MCI.Com
>>