what does NOUP do? 1

[whyfoxpro77]

Im working with foxpro for the first time every. going over legacy code for a transition

example:
USE &pathlive.columnname ORDER code NOUP

what is NOUP doing in this case? I was looking online and I found something similar on the SnowSQL site saying its a boolean to check if the file Its pulling is updated?

 

[Chris Miller]

Legacy code often abbreviates names of commands, functions and options.

NOUP extends to NOUPDATE.

https://vfphelp.com/vfp9/_5wn12pfut.htm

Says "Prevents changes to the table and its structure"

It effectively opens the dbf readonly. If you do it in the IDE, even when exclusivve is set on or you use a dbf EXCLUSIVE NOUPDATE, then do MODIFY STRUCUTRE, the table designer comes up and has [READ ONLY] in its titlebar. You can read all structure information but not change the DBF.

But you also won't be able to APPEND BLANK, REPLACE or anything else modifying the data.

Chriss

 

[whyfoxpro77]

Thanks for the help & link.