Is there possibly some other method … a trigger perhaps … that’s resetting the
t_6 field to some other value, or clearing it?
I’d try the following:
1) Do a Find in Design looking for “[Extra 3]t_6:=”. That should identify any
code you have that touches that field. See if one of your methods may be
running when you save that record.
2) Also, check that one record that you’re marking “Paid” to see what value is
in that field later on… a blank, or some other text. Your search is showing
that the field doesn’t contain “Paid”, but not showing what it does contain.
That could give you a clue as to where it’s getting changed.
3) Finally, include a trace above the line:
If (Records in selection([EXTRA 3])>0)` 4D found 1 record
Check to see if it’s only one record found, or multiple records. You may have
multiple records with Li_1=250, when your intention is for that to be a unique
key. That could leave you changing one record but not the other.
Ron Rosell
> On Mar 29, 2021, at 1:13 PM, Dave Slayton via 4D_Tech <[email protected]>
> 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:[email protected]
> **********************************************************************
**********************************************************************
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:[email protected]
**********************************************************************
