Hi,

We had a similar problem with one of our applications (Delphi 3) with the
TUpdateSQL component. We found that after installing the TUpdateSQLProvider
component (..\delphi3\demos\midas\usqlprov\*.pas) that the problem
disappeared.

We haven't needed to do this for Delphi 4 and 5.

A possible reason for the *.lck files is that if you're using cached updates
the updates are cached in a paradox table until they are committed (so
something along those lines).

Cheers
Andrew.



-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Mark Derricutt
Sent: Friday, 6 April 2001 10:40 a.m.
To: Multiple recipients of list delphi
Subject: [DUG]: TUpdateSQL and Paradox Lock Files....


Hi guys, odd problem, one that's baffeling me....

Yesterday I put two TUpdateSQL components in my datamodule to solve a
problem I was having, however, now I find that my application is creating
pdoxusers.lck and paradox.lck files in my application directory, which is
bad...   firstly it highlighted that all machines on the LAN here have the
BDE NetDir set to the local HDD (we're now getting lock file errors all
over the place... eeep).

Why would I be getting these lock files? Is there a setting in the
TUpdateSQL that's causing it?   Or is there a better way than using
TUpdateSQL to provide an updatable result set?


--
There are exceptions, I'm sure, but the Windows 2000 on-line community
seems to have, in general, the moral and spiritual qualities of your
average porn site. (c) Bryan Pfaffenberger, Linux Journal, Jan 2001.
---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"


---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"

Reply via email to