Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Definition Changed for date=
Message
De
11/04/2002 15:09:00
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
View Definition Changed for date=
Divers
Thread ID:
00643906
Message ID:
00643906
Vues:
52
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform