Hi Steve Simple actually. Do multiple queries each with the PK and multiple updates. Examine using a stored procedure too.
> Message: 8 > Date: Mon, 27 Aug 2007 00:27:55 -0400 > From: Steve Ellenoff <[EMAIL PROTECTED]> > Subject: Workaround for Error 1872 - Too many columns from SQL > Server? > To: [EMAIL PROTECTED] > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="us-ascii" > > One of the apps I'm assisting a company with has an SQL Server table > with more than 255 columns. Is there anyway to read it in Fox? I am > getting the dreaded 1872 error when I try to. Of course, the obvious > answer is, don't bring down more than 255 columns, but I need to > update every field back to the server, so any suggestions are greatly > appreciated- Mike Yearwood _______________________________________________ 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.
