Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a problem with views and files at eof()
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01208548
Message ID:
01208554
Views:
18
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform