> Hi Experts!
> Please help me,
> Is there any API low level function that I should be able to delete marked record(s),permanently, without using PACK command?

Why would that be? What is the underlying requirement.

> Another question is:
> I want to use multi instances .exe file on the LAN,but I want that I should not share my source folder on the network, but my user should be able to use tables etc via my software.
>

Why on earth should you distribute your sources when you have an exe. I don't quite understand that.
What you DO need, of course, are the runtime files along with your xecutable.
When you create a setup with the express version of InstallShield that ships with VFP on the CD you can distribute these files (and others) semi-automatically (you have to tell the script once that these files are to be included in the setup.)
There is a walk-trough on disk if I am not mistaken.
Another option is to take a look at Innosetup.

Another point that brings question marks flying 'round my head like buzzing flies is why you need multiple executables on the lan.
What you can do, and in terms of maintenance that is the easiest solution, is to install the exe, the data etc on the server and install the runtimes and any activeX file on the workstations. That way when you have a newer version of the exe all you have to do is install the new exe to the server, eventually adjust the database and tables and you are set.

> Is there any way that I can use VFP as a Server just like SQL server.

Not by nature. VFP is fileserver based and not C/S ready.
One product you can take a look at is VFPSERVER. (www.vfpserver.com)
However, AFAIK, it restricts the number of users per server.

Another take is a look a west-wind WebConnect. (www.west-wind.com)

basically what you can do is this.
You create a page that performs a SQL command on a table.
It puts the resulting cursor into a XML.
The XML is send back over the wire to a form of a desktop executable.

That form reverses the XML into a table and displays the data in the controls.

You make a change to the data in the form.
When saving you convert the cursor into an XML.
Make a call to a page at the webserver with as parameter the XML

The page has a script that allows the record(s) in the table to be updated.

Another option is to take a look at the (free) eeva server. (http://www.eetasoft.ee/ewebserv.htm)
The cute thing there is that you can create VFP scripts in an HTML file.

This means that the things I described above should also be possible there.
Never tried it though. (Simply not enough time!)

From the three options above, IMHO, WebConnect is the stables of all.
I did play with eeva servver for a while, made it even host multiple sites, but occasionally I ran into the memoleak of the MSWinsock hanging my machine. So I stopped working with that tool for now. (untill I have a better Socket control.)

Boudewijn Lutge®ink
http://www.vfpdevelopers-online.com
The truth will set you free, Ken knew the truth!