Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View error after updating a table structure
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01153469
Message ID:
01153481
Views:
31
Hi... um... the View Script? You mean by clicking on the view in the Project manager, and then selecting Run Query from the menu?
What if I wanted to do this programatically? For example, one of my views is a parameterized view. If I look at the automated SQL for the view generated there is the following:
SELECT *;
 FROM ;
     APPDATA!SERVICE;
 WHERE  Service.person_id == ( ?PERSON.PERSON_ID );
 ORDER BY Service.date
Then a loooonnng list of DBSETPROPS for each field in the result.

I guess I'm just not sure how much happens automatically, and how much you have to do manually.

-- L


>>Hi,
>>
>>I'm getting the following message when opening a new table:
>>
>>
>>The file "Vservice (vservice)" is damaged. - (#1542) Base table fields have been changed and no longer match view fields.View field properties cannot be set.
>>
>>
>>This occurs after changing the base table with an ALTER TABLE command, (to add a new field).
>>
>>I thought the view structure were supposed to reflect the table structure Is there a way to force a refresh of the view structure?
>>
>>TIA,
>>
>>--- Larry
>
>No, it's not done automatically. You have to re-run View script.
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform