Adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;to the code. However when I add that line I get a syntax error when I run the method. The solution builds fine, the syntax passes through the complier so it is syntactly correct. Only when I run the method, it gives me the syntax error. And without that line everything works fine, except all my fields are memo fields
string query = "getValidProcesses"; SqlConnection dbConn = new SqlConnection(connStr); DataSet dbDataSet = new DataSet(); SqlDataAdapter dbAdapter = new SqlDataAdapter(); dbAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; dbAdapter.SelectCommand = new SqlCommand(query, dbConn); dbAdapter.Fill(dbDataSet, "processes"); return dbDataSet;Here is the code in VFP.
local something something = lowatcha.GetValidProcesses() *** Grab the XML - should be a dataset loDOM = something.item.parentNode lcXML = loDOM.Xml LOCAL oXA AS XMLADAPTER oXA = CREATEOBJECT("XMLAdapter") oXA.LOADXML(lcXML,.F.,.T.) && from string oXA.TABLES[1].TOCURSOR(.F.,"processes")Here is the error I am getting.
Line 1: Incorrect syntax near 'getValidProcesses'.Any help is appreciated.