Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving to two tables
Message
From
07/04/2000 12:38:52
 
 
To
07/04/2000 11:50:19
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00356928
Message ID:
00356957
Views:
9
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
Map
View

Click here to load this message in the networking platform