I see,so when ever the COM executes an SQL. I should send the SET ENGINEBEHAVIOR statment before I send the SQL command. Correct?
>Hi Bret,
>
>I guess I wasn't clear. The SET ENGINEBEHAVIOR in the VFP code has no effect on the VFP OLE DB provider. You'll have to send SET ENGINEBEHAVIOR 70 to the provider.
>
>>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.
>>
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope