Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: NAEEM UDDIN
  Where is NAEEM UDDIN?
 SARGODHA
 Pakistan
 NAEEM UDDIN
 Tags
Subject: RE: Is there any api delete rec without pack
Thread ID: 171151 Message ID: 171380 # Views: 60 # Ratings: 1
Version: Visual FoxPro 5 Category: Win32API programming
Date: Sunday, May 04, 2008 3:58:29 PM         
   


> 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!

COMPLETE THREAD

Is there any api delete rec without pack Posted by NAEEM UDDIN @ 5/3/2008 12:15:54 AM
RE: Is there any api delete rec without pack Posted by Cetin Basoz @ 5/3/2008 12:21:12 AM
RE: Is there any api delete rec without pack Posted by NAEEM UDDIN @ 5/3/2008 1:26:06 AM
RE: Is there any api delete rec without pack Posted by Mike Yearwood @ 5/3/2008 2:03:58 AM
RE: Is there any api delete rec without pack Posted by Cetin Basoz @ 5/3/2008 11:24:44 AM
RE: Is there any api delete rec without pack Posted by NAEEM UDDIN @ 5/4/2008 2:54:46 PM
RE: Is there any api delete rec without pack Posted by Zaheer Ahmed @ 5/3/2008 6:50:36 AM
RE: Is there any api delete rec without pack Posted by Boudewijn Lutgerink @ 5/4/2008 3:28:43 PM
RE: Is there any api delete rec without pack Posted by Boudewijn Lutgerink @ 5/4/2008 3:58:29 PM
RE: Is there any api delete rec without pack Posted by NAEEM UDDIN @ 5/4/2008 9:41:13 PM
RE: Is there any api delete rec without pack Posted by Boudewijn Lutgerink @ 5/5/2008 10:54:48 AM
RE: Is there any api delete rec without pack Posted by tushar @ 5/5/2008 2:32:05 PM
RE: Is there any api delete rec without pack Posted by Boudewijn Lutgerink @ 5/7/2008 7:22:34 AM
RE: Is there any api delete rec without pack Posted by Tariq mehmood @ 5/5/2008 2:15:21 PM
RE: Is there any api delete rec without pack Posted by NAEEM UDDIN @ 5/5/2008 10:10:18 PM