General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks Cetin. That worked kind of. It temporarily replaces the date in the contact table. But when I exit the contact form the date doesn't stay in the contacts table. It stays in the member table but I need it to save to both tables. How do I do that? Here is the code:
CASE m.paction = 'SAVE'
m.id = m.memid
INSERT INTO member FROM MEMVAR
replace duesdate with contact.memdate in "contact"
set filter to alltrim(member.id) = alltrim(m.id)
Thanks,
Tyler
Previous
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