Dave
First -
v18 is NOT certified for 10.13.6
https://us.4d.com/product-download/4D-v18-LTS
says v18 is 10.14.6 as a MINIMUM
if you have had 4D v18 running and functioning on 10.13, then try the some of
the below options, otherwise....
use v17, or update to 10.14
(sorry I hate the update cycle, not only for 4D..)
- (already mentioned) the record is locked. Some other process has the record
and has it locked.
You can check for this by adding this test after the query
if (is locked([extra 3]))
Alert("Record is locked")
// you can also use the locked record properties command to determine
what process/user has hold of the record
else
// do work
end if
Also -- if the below code is copy pasted from your program...
the save record command is missing a closing parenthesis
> SAVE RECORD([EXTRA 3]
Save Record([Extra 3])
One other thing...
I do not know how much v18 likes spaces in table names.
You might want to try renaming the table to
[EXTRA_3]
Chip
> On Mar 29, 2021, at 4:13 PM, Dave Slayton via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> Mac....OS 10.13.6
> 4D 18.3 build 18.258288
> The next 4D build requires that I upgrade my OS.....
> I've repaired the data file as well as the structure file..twice
> I replaced the date file with a backup....
> restarted the mac....
> I can't figure out why this doesn't work....
> anyone have any ideas?
>
> read write([EXTRA 3]
> QUERY([EXTRA 3];[EXTRA 3]Li_1=250)
> If (Records in selection([EXTRA 3])>0)` 4D found 1 record
> [EXTRA 3]t_6:="Paid" ` text field
> SAVE RECORD([EXTRA 3]
> UNLOAD RECORD([EXTRA 3])` after unload, 4D still shows one record loaded in
> [EXTRA 3]
> `however the field values are cleared
> FLUSH CACHE` grasping at straws?
> QUERY([EXTRA 3];[EXTRA 3]t_6="Paid")` NO records found
> End if
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive: http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
> **********************************************************************
**********************************************************************
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
