Code

Re: SQL Query

rpowell4600 — Tue, 06 Feb 2007 21:52:51 GMT

Thanks I will give that a try.

Re: SQL Query

nukkumatti — Tue, 06 Feb 2007 13:29:48 GMT

Hi rpowell4600,

not 100% if that is what you are looking for but i usually use this little trick.

Put an Expression Box to your form, click the fx button, select Insert Field or Group, select your secondary datasource and select the field or group you want to know the xpath for. then in the insert formula widnow check the box "edit xpaht (advanced)". There you go.

Hope it helps

SQL Query

rpowell4600 — Fri, 02 Feb 2007 22:51:48 GMT

I am trying to perform a query against a SQL database. I have established a good data connection to the table. I want to query the table for "EmplID", then return the First, Last & M.I. back to the appropriate textbox fields. But when I run the query I get the following msg "Object Required". I know this is telling me I do not have the table name in my namespace path. If I wanted to verify my namespace, how can I find the fully qualified namespace path and will my code return the desired information.

{
var currentElementID = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:ADVHR-EMPL/@EmplID").text;
myDataAdapter = XDocument.DataAdapters("ADVHR-EMPL");
myDataAdapter.Command = "select EMPL_LAST_NM, EMPL_FIRST_NM from ADVHR-EMPL WHERE EMPLOYEE_ID = '" + currentElementID + "'";
myDataAdapter.Query();
}