Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update a table in a database with a view
Message
From
05/06/2007 07:37:45
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
05/06/2007 07:34:31
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01230467
Message ID:
01230504
Views:
23
>Hi,
>
>The code comes from a program in which people can open any table. Then I put that table in a database and create a view of the fields they want to see. Then show the view in a grid and let the people change the data (or even delete a record in the grid) then I want to update the chosen table with the changes and pack it to delete records if needed. In the end get the table out of the database and delete the database.
>
>So everything is variable. That's why the code looks so strange. (And maybe that's why it doesn't work properly.
>
>Any more ideas to make this one good?
>
>Greetings,
>Ron

Many really. First and simpliest, I think, why there is a need for a view in between at all.
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