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:
00634534
Vues:
15
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?

>>>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?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform