Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with a view - urgent
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00634511
Message ID:
00634542
Vues:
21
>Hi!
>
>Did you tried a GenDBC tool to copy that view's properties, and then extract the code part from generated PRG and run for new database to copy that view into new database?

No, I haven't. This is the same database. I had a view. I wanted to copy table's field properties into view field's properties. I first tried it with EView, and as a result I got this error. I then deleted this view from database, cleaned the database, re-created the view, then again tried to use EView to copy properties and boom, again the same story. So, I'm going to delete this view again, re-create it again, but this time I'm afraid to use EView. So, how else I can copy properties from table's fields to view fields? Is there an option in VFP View Designer to do so?

Thanks a lot in advance.

>>>>Hi everybody,
>>>>
>>>>I opened view in EView and copied all properties from database to the view. The view is based on just one table. Now I get this error each time, I'm trying to open it:
>>>>Error reading a property from the database. The property is ignored (Error 1584)
>>>>An error occurred while loading rule or trigger code from the database container. The rule or trigger will be ignored.
>>>>
>>>>Try running VALIDATE DATABASE before reopening this table

>>>>
>>>>I've already validated database, but it didn't help. Should I re-create this view again or there is an option to fix it?
>>>>
>>>>Thanks in advance.
>>>>
>>>>===============
>>>>URGENT!
>>>
>>>Nadya,
>>>Try with 'recover' clause first.
>>>Cetin
>>
>>
>>I did, it didn't help. Anyway, I've re-created the view, but I don't remember, how I set it up originally, so it now returns 0 records instead of one...
>>
>>I then opened this view in EView, hit Copy Properties. It gave me an error "You specified more than one key" (though I specified only one key - FunctionID) and now it again gives me the same error, as before. Damn it! Should I re-create this view again? How can I easily copy underlaying table properties without problems? Should I use another view editor? I probably download it already, but I forgot the name of it. Could you please give me the link?
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform