Hi Chip,
In the current mode of use, is not possible that another user deletes
one record (I'm reading into the log) and there are only two users.
Consider that if one record is deleted, even the record that contains
your record number is deleted. In normal work, only one user can create
the record, and the other user works with different records.
Strange, i have other installations that work in the same mode without
problems...
Thanks
Ferdinando
Il 03/07/2019 21:49, Chip Scheide ha scritto:
in a multi user system it could be that a different user deleted the
record
In your logs, a record number is not necessarily enough to ID the
trouble record.
In your log - write some data specific information - UUID, or some
other info that is unique to the record, as 4D can/does reuse record
numbers.
so you can have the situation:
User A loads a selection of records (Including Record 1)
User B deletes record 1
User A does their Selection to Array - the error occurs as Record 1
does not exist.
User C adds a record to the table - 4D reuses Record 1
you look into your log file and find that Record 1 was the trouble
record
you look at the data and find that there is a record 1.
Chip
On Wed, 3 Jul 2019 21:06:54 +0200, stardata.info via 4D_Tech wrote:
No transaction, seems that there is a record not accessible with GOTO
RECORD command. Now I trap this error with ON ERR CALL and after I
write in the application logs the record numbers contained into the
array. So I can see the record number that gives a problem...
Is strange that after restarting the client, all work normally. If
there are a strange record number, he must remain even after the
restart of client.
Il 03/07/2019 21:00, [email protected] ha scritto:
Message: 2
Date: Wed, 03 Jul 2019 16:14:45 +0100
From: Narinder Chandi<[email protected]>
To: 4D Tech Mailing List<[email protected]>
Subject: Re: OUT OF RANGE
Message-ID:<[email protected]>
Content-Type: text/plain; charset="UTF-8"
>From memory, this error is usually triggered because a record you
are trying to access doesn't exist. You need to look at the context
in which you are trying to create the selection to figure this error
out. Perhaps you are in a transaction?
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
-- -----Original Message----- From: 4D_Tech
<[email protected]> on behalf of 4D Tech Mailing List
<[email protected]> Reply-To: 4D Tech Mailing List
<[email protected]> Date: Wednesday, 3 July 2019 at 16:05 To: 4D
Tech Mailing List <[email protected]>,
<[email protected]> Cc: "stardata.info"
<[email protected]> Subject: OUT OF RANGE Hi All, I use 4D V13
on windows in one client server application. In the command CREATE
SELECTION FROM ARRAY sometimes i have one error: The cannot be used
to build the selection Record # is out of range during GOTO
RECORD.... The customer restart the application and this segnalation
disappares. Someone can explain the reason? Now i trap the
segnalation using ON ERR CALL but i need to understand the reasons.
Thanks /Ferdinando/
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
---------------
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
