Of course I had SET STATICDB ON, also MULTI is set on. Yes, they were set
before connecting to the database. All I do for this test is to specify the
desired STATICDB & FASTLOCK settings, CONN to the database and then run the
CMD file that does the simple insert command that I specified. It always
seems to initially produce correct results until about 100 rows are
inserted, then about 100 rows of garbage, etc.
If FASTLOCK is set OFF and STATICDB is set ON, then CONN & run the CMD file
(containing the insert command), it works fine for all 1002 rows.
-----Original Message-----
From: A. Razzak Memon [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 6:02 AM
To: [EMAIL PROTECTED]
Subject: Re: Fastlock - Razzak's Reply
At 08:57 PM 6/7/01 -0700, Frank Radice wrote:
Frank,
When using FASTLOCK ON, what is the STATICDB Setting?
Are you running as stand-alone or Multi-User?
In a Multi-User environment, FASTLOCK can only be
set on when STATICDB is set ON, and both FASTLOCK
and STATICDB must be set ON before the database is
CONNected.
Like other R:BASE database modes (SET MULTI and
SET STATICDB), FASTLOCK requires ALL users to be
connected with the same setting.
The following command lines set STATICDB and
FASTLOCK correctly.
SET STATICDB ON
SET FASTLOCK ON
CONNECT dbname
Have Fun!
Very Best Regards,
Razzak.
>Does anyone use SET FASTLOCK ON?
>Have you had any problems with it?
>
>Am running DOS 6.5+ and I get a lot of garbage rows
>when I insert into a table using the following with
>FASTLOCK ON
===================================-============================
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
