Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to detect if a field is used in a remote view
Message
From
07/05/2005 05:56:30
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
06/05/2005 21:04:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01010684
Message ID:
01011888
Views:
16
>Hi Cetin,
>
>Thanks again for the reply.
>
>I tried what you suggested and it works. There is a slight problem though.
>The remote view was created but the update properties were not set.
>
>Did I miss something?
>
>Thanks in advance...

Mike,
That single command doesn't update view properties like keyfiledlist,updatenames etc. First get your original dbc's programmatic version using gendbc. Then it'd be easier for you to find the places in code for changes. Edit code and run (only views if your prefer with a "drop view..." followed by "create sql view...."). It'd create your views afresh.
If you only edit and run sections for views your data would stay put. Views are just definitions. However after running it don't forget to pack your dbc or it'd get fatter.
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