Updating a SQL secondary datasource

Last post 08-21-2007 01:00 AM by Shiva. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

08-06-2007 05:53 PM

djay
Joined on 06-06-2006
Posts 35

Updating a SQL secondary datasource

Reply Contact

I have a SQL database setup as a secondary data source and I want to update it from InfoPath.

InfoPath doesn't support this since I don't have access to a web server so I can't make a web service.

So I am trying to do it manually using C#. I set the command like this:

Juris.Command = "UPDATE tbl_juri_checkoff SET inactive = '" + Inactive + "' WHERE uniqueID = '" + ID + "'";

and then I:

Juris.Query();

and the database is not updated. If I send this same query using something else it works fine. Juris.Query() works fine with a normal SELECT statement.

I don't get any errors or anything. It just doesn't work.

Anyone have any ideas?

Anyone tried to do something like this before?

Is InfoPath unable to handle UPDATE SQL commands?

Thanks,

-DJay

Filed under: C# SQL submit secondary.datasource

08-21-2007 01:00 AM In reply to

Shiva
Joined on 04-15-2005
India
Posts 694

Re: Updating a SQL secondary datasource

Mark as Not Answer Mark as Answer ...

Reply Contact

Hi DJay,

Can you check below the line is executed successfully in your database.

UPDATE tbl_juri_checkoff SET inactive = ‘Inactive’ WHERE uniqueID = ‘ID’;

If the above statement is executed correctly then your code is correct. Can you keep the query line in try and catch statement then let you know what type of error it is giving.

Hope this Help you.

Shiva / http://www.ggktech.com

Page 1 of 1 (2 items)

InfoPath Dev