* this code will get all columns from a SQL Server - handy when * there are more than 255 columns. SQLEXEC(dsn,[exec sp_columns 'incident_name'],'c_columns')
JH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Ellenoff Sent: Sunday, August 26, 2007 11:28 PM To: [email protected] Subject: Workaround for Error 1872 - Too many columns from SQL Server? 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- Steve [excessive quoting removed by server] _______________________________________________ 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]@shelbynet.com ** 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.
