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.