Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Saving to two tables
Message
De
07/04/2000 12:43:50
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
07/04/2000 12:38:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00356928
Message ID:
00356960
Vues:
16
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform