Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set Exact On or Off
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01517890
Message ID:
01517906
Vues:
40
>>>>That said, SET EXACT is scoped to a datasession. So, if your form uses its own datasession, when you close it the SET EXACT no longer has any effect. If it's OK for SET EXACT to be ON for the duration of the form, it might be OK to leave it in the .Load.
>>>
>>>Thank you. Everything you stated makes sense. The only place, I can think of, that I would need to SET EXACT ON is where I need to use SEEK() on exact value.
>>
>>SEEK doesn't search for a partial match, you're getting confused. May be you're thinking about SET ANSI ON and SQL.
>>
>>See also String comparison in VFP
>
>After I changed the code from SET EXACT ON to OFF the code that didn't work started working. Here is an example:
>
>I have an index key:
>
>REC_ID + PART_NO + DTOS( SOMEDATE )
>
>When I was using
>
>SEEK '1' + cVariable && the cVariable had a value of valid entry in the cursor
>
>The pointer was going to EOF().
>
>Once I changed to SET EXACT OFF the above SEEK started working.
>
>Does it make sense?

Yes.
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