VFP ODBC driver -- turn off SET ANSI default??

[kakmouth]

using a VFP ODBC driver with SQL server, i realized that the SET ANSI option is defaulted to ON which causes the shorter of 2 comparison strings to be padded, as to create 2 strings of equal length. is there any way to turn this option off, either within the SELECT statement or elsewhere??? any help would be appreciated...

 

[foxdev]

You might try issuing [tt]SQLExec(nHandle, "set ansi off&quot[/tt] after issuing the SQLConnect()/SQLStringConnect(). I've not had much luck doing this with Sybase, but in theory it is a persistent connection to the database, so any SET settings should "stick" while that connection is active. -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com