Thanks Sergey. Now I just need to place the statement into a set of COM Dll's and test if that works. I have ran a couple of tests where it indicates to me that EngineBehavior is set to 70, but the OleDb cll to execute an SQL seems to have a problem. I figured I would set engine behavior right before the call to OleDb, but that did not seem to work. That is what made me ask if OleDb undertands that I set EngineBehavior.
>>I know that SET ENGINEBEHAVIOR has an effect on an SQL I am running from withing VFP 9. But I am running an SQL command using VFP OLEDB. Does set Enginebehavior have any effect on how VfpOleDb runs the SQL command.
>
>The SET ENGINEBEHAVIOR affects the VFP OLE DB provider the same way as VFP.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope