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


Tyler,
I still cannot understand what the filter is for. IMHO you should avoid using filters as much as possible. Nearly always there is another better way to accomplish what's needed.
Contact seems to be buffered and no tableupdate occurred. Add a tableupdate() :

tableupdate(2,.f.,"contact") && Check help for parameter explanations

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform