Re: Urgent - very strange FoxPro 6 file corruption problem

All very nice ideas but the idea was for this to be a quick temporary app.
Then we get rid of FoxPro entirely. Thanks.

"swdev2" wrote:

Interrupted in 'this world of desktop apps'
Usually means:
1. network cable faulty
2. desktop machine powered off whilst having a set of tables open.
3. Power Outage .
4. Untrained Anti Virus Program keeping locks on files at the wrong time o
day.

If you want to do something else, and stick with VFP tables -
I suggest it's time to build a COM server in VFP that handles
all of the dbf IO at the SERVER MACHINE.

If you want to dump that Dot Something Stuff that you wrote,
suggest you switch over to a VFP-based web program like
West Wind Web Connection, or
Active FoxPro Pages.

Good Luck.

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"B. Chernick" <BChernick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8238CA4D-5ECD-407B-83FC-DB5D1DF03582@xxxxxxxxxxxxxxxx
'Recreate them'? Not to my knowledge. (But that's the first time I've
heard
that term. I'll have to look into it.)

Here's the problem. I had absolutely zero exposure to FoxPro until a few
weeks ago. Then I got this rush project to cobble up a temporary web app
(In
VB/Dot Net 2.0) . Given that very few people do this sort of thing, there
was a great deal of trial and error involved. I had already done a
project
using an XSD and Object Data Sources so I used the tools I was familiar
with.
So I don't know if it's a bug in my code, a bug in the Oledb driver, or
just
basic incompatibility between old and new technologies.

Here's another worry of mine. I've been told that it is easy to corrupt
DBFs if a program using them is interrupted. Given that the basic nature
of
a web app is to be constantly opening and closing connections to the
tables,
wouldn't that increase the chances of file corruption? (Or to put it more
bluntly, am I crazy to even try accessing DBFs from a web app?)

"Gene Wirchenko" wrote:

B. Chernick <BChernick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I'm having some very strange problems with FoxPro 6 dbf tables. I
suspect my
web app may be corrupting them (A Dot Net 2.0 web app accessing dbf
tables is
strange enough) but first I'd like to know if anyone can even put a
name to
this.

My application can read the files, no problem. It's someone else's
program
that started complaining. The only thing that seems to be different is
that
when I open this problem file, the Reindex option is missing from the
VFP6
Table menu. Has anyone ever seen anything like this?

Does one of the programs using the tables recreate them? If so,
it may be recreating them with the wrong version. Check the docs
under copy to for the type fox2x clause.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.




.

Relevant Pages

  • Re: Problem browsing large file
    ... I have another app that keeps this file open 24/7. ... open the file NOUPDATE with VFP7/8, it pauses for a minute, and then the ... Without the index Fox probably fetches all the records ... > issue of FoxPro Advisor magazine. ...
    (microsoft.public.fox.programmer.exchange)
  • RE: trying to run vfp3 under XP -- not working - Insufficient memory error
    ... Microsoft FoxPro Technical Support ... >runtime installed using Windows 2000 and below. ... >gets Insufficient memory when they try to run that same app. ...
    (microsoft.public.fox.helpwanted)
  • Re: FoxPro DOS 2.6 temp files
    ... It is nice to hear from a FoxPro support person even though this is for such an old product. ... I guess I wasn't totally clear about the client environment, they are all DOS 6.22 machines with the Novell client software drivers for DOS so running on a Windows machine is not going to tell us anything. ... > trapping routine returns>the user to the login for the main app. ... However I've looked at the settings for other ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: One instance only - VFP8/SP1
    ... WAIT 'The app is already running' WINDOW ... front" feature which didnīt work. ... > to www.universalthread.com, click on the Download icon, and choose Visual ... > Microsoft FoxPro Technical Support ...
    (microsoft.public.fox.programmer.exchange)