Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exact and deleted recs - did everybody know this but me?
Message
De
24/07/2006 13:44:03
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01139176
Message ID:
01139306
Vues:
16
>>>>
>>>>SET DELETED OFF
>>>>
>>>
>>>You have turned off the DELETED filter. That is why you are getting deleted records. Change this to SET DELETED ON.
>>
>>I think I'm not making myself clear. I WANT deleted records returned, but I want them returned with the deleted flag set as it is set in the table itself. This only happens if DELETED, ANSI, and EXACT are all set off. If I set either ANSI or EXACT to ON, the deleted flag is wiped out and the record is returned as non-deleted. I can't find any documentation that says why ANSI or EXACT should cause such behaviour.
>
>The flag in never returned. What is your select statement?
>
>For single table in FROM you can do
>
>select field1, field2, deleted() as lDeleted from myTable where ...
>
>You can not use this idea for multiple tables in FROM and there is no way to return deleted status. Or at least I don't know a way <g>

I included some example code in my first message, but I guess it's been snipped by now. Anyway, if you do a select while DELETED, EXACT, and ANSI are all set to off (and you don't include NOFILTER), the deleted flag will stay set on deleted records. Whether or not this is something that can be counted on as staying that way is a separate and equally important issue.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform