>> Ansi Warnings is off on the database which should stop this error, but reading Help! "By default, ODBC and OLE DB clients issue a connection-level SET statement setting ANSI_WARNINGS to ON for the session when connecting to SQL Server."<<
Check out the SQLSETPROP() function in VFP. There is a property for DispWarning you can set. I am not sure how this works with CursorAdapters though. I have not tested this, but you should be able to use CURSORGETPROP() to get the value of the ConnectHandle, then use this connection handle to set the DispWarning using SQLSETPROP(). Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
