Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why my view won't save?
Message
De
19/08/2002 23:26:09
Wally Noll
Double Aa Builders
Mesa, Arizona, États-Unis
 
 
À
19/08/2002 19:10:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00691260
Message ID:
00691322
Vues:
11
Roman,

You saw in the help section that Error 1491 says the 'Table' property of the View is not set.

=DBSETPROP('myView','VIEW','Tables','myDBC!myTable')

But if that's not it, then I'd try defining the field property for UpdateName with the DBC syntax included, - 'myDBC!myTable.myfield' instead of leaving off the DBC.

Wally

>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform