In VFP there is a setting called EXACT. When EXACT is ON, if the SQL says WHERE Agent = "ES" you only get records that have an Agent field exactly equal to "ES". When EXACT is OFF, if the SQL says Agent = "ES", you get records where the agent field contains a value that begins with "ES", including "ES", "ES1588", "ES41", etc.
How can I set this property with the HXTT DBF driver? It appears that by default, HXTT DBF driver EXACT property is set to be ON.
Thanks!
Paul Hall
|
You have to use LIKE 'ES%' or ILIKE 'ES%' since this was standarad sql syntax.
|