Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error message in view
Message
De
21/12/2011 22:09:51
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Divers
Thread ID:
01531530
Message ID:
01531547
Vues:
25
>>>What is the syntax for the view ?
>>
>>The view was created interactively. It is a very simple view, based on a single table. The SQL it generates is:
>>
>>
>>SELECT *;
>> FROM database!plandet;
>> WHERE Plandet.plan = ?tnPlan
>>
>>
>>In addition, one of the fields (under "Properties") has a default value that calls a UDF: serialnumber("plandet")
>>
>>In Update Criteria, all fields are updateable, one field is defined as the primary key.
>>
>>That's about it. The view used to work. I suspect it has simply been corrupted, and suggested my contact to re-create it from scratch. I haven't heard back from him about that yet.
>
>I think it may be the SerialNumber function causing the problems. Is it referenced in the whole view code by any chance? Can you remove it and see, if the error will be gone?

This is used in many different views. Anyway, I'll suggest seeing what happens when it is taken away.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform