General information
Category:
Forms & Form designer
Title:
Programatic table update not updating
I have a function run from a button, that for some reason does not do the sole table update called psuedo code:
select messages
scatter memvar
&& a bunch of processing to send an email
&& including two select statements
&& Now tell the database this message has gone bye bye
&& This appears to work in debugger
select messages
m.sent = .T.
gather memvar like sent
&& But browse the table after, and Sent = .F.
I've tried UPDATE messages set sent = .T. where msgkey = lmsgkey
same no result.
While in the form, table messages has filter = sent = .f.
While the form is open, sent does = .T. when I update it in the form, but once the form closes, it goes back to .F.
Any suggestions or possible resolutions will be appreciated.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only