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; >>
>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") >>
Line 1: Incorrect syntax near 'getValidProcesses'.>