Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why my view won't save?
Message
De
19/08/2002 19:10:12
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Why my view won't save?
Divers
Thread ID:
00691260
Message ID:
00691260
Vues:
54
Hi

My problem is that my view won't save changes, despite I think that have
taken all the required steps to do it. First, no one is using the DBC and its
tables (which is not necessary), all the fields of my view are updateable,
table buffering =5. This is the first it happens to me, the only slight
doubt I have is that I set updatetype=1 (u can't find much info about it
in the documentation), which I believe is not the problem.
The only solution I can think of is to reinstall VFP, but maybe you
could help me to solve this before I do something unnecessary and not learn
something new.

Here is more or less How I've created the main view:

CREATE SQL VIEW 'MainView' AS SELECT cursor.ID, cursor.padre,;
view.descripcion FROM DBC!view INNER JOIN;
Cursor ON view.tipo+view.cod+view.ID=cursor.tipo+;
cursor.cod+cursor.ID


and the select of secondary view was defined thus:

SELECT table.id, table.tipo, table2.descripcion;
FROM DBC!table2 INNER JOIN DBC!table ;
ON table2.tipo+table2.cod = table.tipo+table.cod

The error number I get from aerror() is 1491, could be that using
a cursor created at runtime and establish it as table source of the
view be causing this problem?
The properties of the fields of the cursor are defined like the fields of the
secondary view, except that in the propertie updatename I just use the name of cursor without defining a DBC for it.

The view works just fine, it reverts changes too!, it's just won't save.

TIA
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform