>>>Do you remember the other thread about the null problem? I was/am using the string as a parameter passed into a SP to overcome the nulls not allowed problem. I have not been able to get the SET NULL to work from within the connection string. :(
>>>Here's what was suggested but it doesn't work. Maybe I just didn't understand enough.
>>>
>>>
>>> <add name="TIPWebEdits" connectionString="Provider=VFPOLEDB.1;Data Source=C:\Inetpub\wwwroot\netTIP\App_Data\Tip_WebEdits\tip_webedits.dbc;NULL=No"
>>> providerName="System.Data.OleDb" />
>>>
>>>
>>Are you sure you want NULL=No, may be you want NULL=Yes ?
>>
>>See
http://www.connectionstrings.com/visual-foxpro>>
>>and it's referenced from
http://social.msdn.microsoft.com/Forums/en-US/visualfoxprogeneral/thread/2eeed0dc-9199-48cb-910c-c661e9096cfe>
>I've tried YES,NO,OFF,ON all with the same result. Any other ideas?
Not really, except for forgetting the INLINE Insert statement, move the logic to VFP/SP and have SET NULL OFF there.
If it's not broken, fix it until it is.
My Blog