Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving to two tables
Message
From
07/04/2000 11:50:19
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
07/04/2000 11:42:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00356928
Message ID:
00356934
Views:
11
>I want to save a date to two tables. Here is my code for saving to the new table. It will be a new record in the members table and a replacement of the date in the contact table.
>
>CASE m.paction = 'SAVE'
> m.id = m.memid
> INSERT INTO member FROM MEMVAR
> set filter to alltrim(member.id) = alltrim(m.id)
>
>I then want to replace the duesdate from the record saved in member to the duesdate in the contact table. How would I do that?
>
>Thanks,
>Tyler


What the filter is for ?

replace duesdate with member.duesdate in "contact"

Could you elaborate this more.
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