Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Definition Changed for date=
Message
 
 
À
15/04/2002 20:27:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00643906
Message ID:
00645257
Vues:
52
I can only repeat what I sad in my previous message.

>Hi Sergey,
>That appears to be my problem.
>
>But that raises a question.
>If I set my parameters to {4/4/2}-{4/4/2} it crashes on REQUERY() also crashes with my parameters set to {4/5/2}-{4/5/2}, but DOESN'T crash if I set my parameters to {4/4/2}-{4/5/2}.
>
>Why doesn't it crash when my date range is 2 days, since it crashes on each individual day range? It seems to me that it has to use the same record to compare in the 2 day range as it does in the one of the 1 day ranges.
>
>
>
>>"USE [ViewName]" opens a View. When you do REQUERY() VFP compares record structure with previous and generate error "View definition changed" if they don't match. That's why error is generated only in the second case. You can find out which view fields cause the problem by
>>1. Set parameter values to ones that don't cause an error
>> USE [ViewName]"
>> LIST STRUCTURE TO PRINTER or FILE
>>2. Do the same for parameters values that cause an error
>>3. Compare structure of both views as reported by LIST STRUCTURE command.
>>
>>>Hi Sergey,
>>>I've verified that there is data for the dates involved. I've also verified that the view works if there is no data for the dates involved.
>>>
>>>The view is very long, 117 fields including , 6 udfs() that do there own Select(), 4 tables involved (only 1 updatable).
>>>
>>>I have discovered something else. And I'm pretty sure that it's not the data involved.
>>>
>>>It only happens on REQUERY(). If I "USE [ViewName]", it works fine, but if I then REQUERY() it crashes. Naturally it crashes in my form, because I always start with NODATA then REQUERY() when I need it. If I can't figure out what is happening, I'll change my REQUERY() to USE in my grid (can't say I like that idea).
>>>
>>< snip >
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform