Fwd: command line process

[Walter Vaughan Jr]

Nancy is right. This was the hardest thing to accept when moving to SQL was that I could do things that give me a very queasy feeling if I tried to do in Filepro.
In SQL you can update stuff like

Update testdatabase
Set testfield = '1000-1000-10'
Where testfield = '1000-1000'

Which you can because SQL is handling the data as a collection wrapped in a transaction with record locks, yet in filePro you are handling a row at a time, once the row is written it has to update the index, and if you are processing based upon an index, you basically need to start over because you have changed the index that you are standing in.

filePro rule#1: Nancy is right.

-----Original Message-----
From: Filepro-list <filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com> On Behalf Of Nancy Palmquist via Filepro-list
Sent: Wednesday, March 31, 2021 11:17 AM
To: filepro-list at lists.celestial.com
Subject: Re: Fwd: command line process


What I think could cause an issue is that you should never select using an index that is built on something you plan to change.