Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Definition Changed for date=
Message
 
 
To
11/04/2002 15:09:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00643906
Message ID:
00643920
Views:
21
Do you have any data for the dates that generate error? Can you post View's SQL?

>I'm simplifying this untill someone asks for details.
>
>I have a parametized view that I've been using for 1 1/2 years with no problem. All of a sudden I'm getting "view definition has changed" SOMETIMES when I try to open it.
>
>One of the parameters is "cs_Date>=?pdBegin and cs_Date<=?pdEnd".
>I've discoverd these results:
>
>pdBegin    pdEnd     Results
>Single Date Range
>{4/3/2}    {4/3/2}   Opens
>{4/4/2}    {4/4/2}    Error
>{4/5/2}    {4/5/2}    Error
>{4/6/2}    {4/6/2}    Error
>{4/7/2}    {4/7/2}   Opens
>Multi Date Range
>{4/4/2}    {4/10/2}  Opens
>{4/4/2}    {4/5/2}   Opens
>{4/5/2}    {4/6/2}   Opens
>
>
>I've tried reindexing the table.
>I orginally guessed that I had corrupted data, but couldn't see it. But no other form or report or browse has a problem with the data. I haven't started trying to track down a particular record that might be causing this, but after those last two results, I'm wondering if it's even worth trying.
>
>TIA
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform