SQL Database Integration

Re: Access Database Field in JScript

AliMalek — Mon, 24 Nov 2008 21:49:17 GMT

Thanks. That did it.

Sorry one more question:

After clicking on insert item in repeating section, how do I actually save new values in SQL Server? How do I access data fields entered by user?

Re: Access Database Field in JScript

Hilary Stoupa — Mon, 24 Nov 2008 21:18:08 GMT

Sorry -- source is capitalized: eventObj.Source

Re: Access Database Field in JScript

AliMalek — Mon, 24 Nov 2008 21:09:37 GMT

I am getting 'source' is null or not an object.

Here is my code:

function btnItemDelete::OnClick(eventObj) {

var AppContactID = eventObj.source.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SQLComplexDBList/@AppContactID").text;

Any idea why?

Thanks

Re: Access Database Field in JScript

Hilary Stoupa — Sat, 22 Nov 2008 00:04:01 GMT

Use eventObj.source instead. I believe in C# the variable is e.

Re: Access Database Field in JScript

AliMalek — Fri, 21 Nov 2008 19:04:27 GMT

Thanks Swathip.

What is e (e.source.selectSingleNode) in your code? I am getting 'e' is undefined when I preview the form.

Re: Access Database Field in JScript

swathip — Fri, 21 Nov 2008 06:02:01 GMT

Hi,

In the above code, every time you are getting the first ‘AppContactID'. Instead of that get the current row AppContactID. For that use the following code line.

var AppContactID = e.source.selectSingleNode("@AppContactID").text;

You can add confirm messages using the following code.

var answer = confirm ("Write the confirm message here")
if (answer)
//Continue with your code else
return

Re: Access Database Field in JScript

AliMalek — Thu, 20 Nov 2008 15:46:46 GMT

Sorry more questions:

As you can see in attached screenshot, I have a repeating table that lists contacts for each database I manage. For each row of the table, I put a Delete button for users to remove the contact. In preview form, when I click on Delete button, I always see the first row being deleted even when I click on Delete button in 2nd and third rows. Here is the code I use to delete. What am I doing wrong?

function btnDeleteAppContact::OnClick(eventObj)

{ var AppContactID = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SQLComplexDBList/@AppContactID").text;

if(AppContactID != null) {

XDocument.QueryAdapter.Command = "delete dbo.AppContact where AppContactID = " + AppContactID;

XDocument.Query(); } }

--------------------

How can I add a Confirm Delete popup window before actually deleting a row? I am new to JScript?

Thanks

Ali

Re: Access Database Field in JScript

AliMalek — Thu, 20 Nov 2008 14:48:36 GMT

Thanks. It worked.

Re: Access Database Field in JScript

swathip — Thu, 20 Nov 2008 05:29:42 GMT

Hi,

Do you want to get the ‘SQLComplexDBID' value then the xpath you are using is not correct. Use the following xpath to get the SQLComplexDBID value.

function btnDelete::OnClick(eventObj)

{

var SQLComplexDBID = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SQLComplexDBList/@SQLComplexDBID").text;

if(SQLComplexDBID != null)

{

XDocument.QueryAdapter.Command = "delete dbo.SQLComplexDB where SQLComplexDBID = " + SQLComplexDBID;

XDocument.Query();

}

Access Database Field in JScript

AliMalek — Wed, 19 Nov 2008 21:11:55 GMT

Hi,

I am new to Infopath. So far, I designed a form to list contacts and it works. Now, I need to be able to delete a table row using the follwoing code. SQLComplexDBID is the primary key but probably I have wrong syntax here because I am getting error after clicking on delete button. I checked the query in SQL profiler and it is delete dbo.SQLComplexDB where SQLComplexDBID = . Meaning that the primary key is not added to the query and executed.

Can you please help? I attached my form.

function btnDelete::OnClick(eventObj)

{ var SQLComplexDBID = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SQLComplexDBList[@SQLComplexDBID]").text;

XDocument.QueryAdapter.Command = "delete dbo.SQLComplexDB where SQLComplexDBID = " + SQLComplexDBID;

XDocument.Query(); }

Thanks

Ali