Paul Hall | 2008-09-02 11:03:15.0 | |
| 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 | ||
HXTT Support | 2008-09-12 06:15:33.0 | |
| You have to use LIKE 'ES%' or ILIKE 'ES%' since this was standarad sql syntax. | ||