Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a problem with views and files at eof()
Message
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 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01208548
Message ID:
01208554
Vues:
17
>I have a view that when I do a tableupdate sometimes fails but doesn't show it.
>i.e.
>
>l=tableupdate(.t.,.t.)
>if l=.f.
>  failed
>else
>   good
>endif
>What is happening, is I replace data into the view, i.e.
>replace invno with nInvNo ;
> invdate with dDate ;
>invcust with nCustNo
>
>I then call the tableupdate() after this and check as above.
>I get no errors, however if I look at the underlying table, the last record has empty fields for the above.
>
>This apparently only happens when the underlying table is at eof()
>
>Does this make any sense to anyone?
>Mike

Did you verify that you correctly made a replace in a view? Is it local view or remote?
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