Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Definition Changed for date=
Message
From
11/04/2002 15:09:00
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View Definition Changed for date=
Miscellaneous
Thread ID:
00643906
Message ID:
00643906
Views:
50
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
Bill Morris
Next
Reply
Map
View

Click here to load this message in the networking platform