Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View getting deleted records
Message
From
27/10/2006 13:47:02
 
 
To
27/10/2006 13:34:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01165104
Message ID:
01165119
Views:
20
Exact and deleted recs - did everybody know this but me? Thread #1139176 Message #1139176

>As i wrote before: Set deleted is on. What am i missing?
>
>>Hi all, i have this problem, the view is accessing 2 tables, select t1.*,t2.* from t1,t2 where t1.f1=t2.f2 and it's returning all files even the deleted ones. Set deleted is on. What am i missing?
>>TIA.
>
>check the help for these two commands:
>
>SET DELETED ON
>SET DELETED OFF
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Reply
Map
View

Click here to load this message in the networking platform