General

Re: Problem changing a value from secondary data source

adamrharding — Thu, 11 Oct 2007 11:29:04 GMT

Patricjk

No problems, my misunderstanding

Cheers

Re: Problem changing a value from secondary data source

Patrick Halstead — Thu, 11 Oct 2007 10:17:32 GMT

Hi Gorka,

I replied separately in e-mail.

Cheers!

Re: Problem changing a value from secondary data source

GLazkano — Thu, 11 Oct 2007 09:13:12 GMT

Hi Patrick!

When you say purchase, I understand pay for that help (maybe because my english is bad). But if you mean that: how many costes that help and who must I talk with?

Thanks.

Re: Problem changing a value from secondary data source

Patrick Halstead — Thu, 11 Oct 2007 08:54:57 GMT

Hi Glazkano,

I think this is an xpath issue which is good news because it should be a relatively simple fix, but xpath can be tricky. Greg might be best person to ask. If you need some help this week, please purchase some support credits and we'll allocate some time Friday to debug this with you in real time.

Hi Adam,

Thanks for the creative imagination,but I don't think DBXL would be required for Glazkano's scenario. The main value prop of DBXL is to help people integrate InfoPath with their SQL database (without writing code). Glazkano's form just has a problem with the secondary data source so should just be a straightforward xpath issue.

Cheers!

Re: Problem changing a value from secondary data source

adamrharding — Wed, 10 Oct 2007 18:40:29 GMT

Hi Matt My theory about DBXL (excuse me if my understanding is a little woolly) is that you could use the service to modify the data on route to the form. If I am in error I apologise profusely and will duly beg the forgiveness of Glazkano. Sorry if I have misunderstood

Re: Problem changing a value from secondary data source

GLazkano — Wed, 10 Oct 2007 14:40:47 GMT

Hi again!

Thanks Adam and Matt. I've downloaded that DBXL application but first I will try to explain you with an explicative picture and with my form what's happening.

In that picture there is 2 different squares: the red one is for search a product. Once that product is found, the blue one receives the value of 1, because by default that is the quantity of a product. That quantity must be substracted from a stock field in a secondary data source (that secondary data source is where the articles are stored). And if anyone changes that value (you can need 10 of the same product) that value must change on that field in the secondary data source .

I don't know if I'm explaining myself, but I think it's enough to understand my problem

PS: My form is too big for attaching it here, so I uploaded it to megaupload, here is the link http://www.megaupload.com/es/?d=PYDN3A7P

Re: Problem changing a value from secondary data source

Matt Faus — Wed, 10 Oct 2007 13:56:49 GMT

Hi GLazkano,

I think this is a simple XPath error, but it is hard to debug without your form. Is there anyway you could attach it to your next reply so that I can look at it more in-depth?

Adam, could you explain how DBXL would help in this scenario? I'm not seeing the connection.

Re: Problem changing a value from secondary data source

adamrharding — Wed, 10 Oct 2007 11:29:39 GMT

The only way to do this without a whole lot of coding is to look a Qdabras Database Accelerator that would allow you to update secondary data sources natively.

You are in some complicated code there and if you need a very quick result then the above is your best chance.

Cheers Adam

Re: Problem changing a value from secondary data source

GLazkano — Wed, 10 Oct 2007 08:18:48 GMT

Hi again!

I continue with the same problem and my project must be finished this next week.

Please, does anyone know how to solve it?

Re: Problem changing a value from secondary data source

GLazkano — Wed, 03 Oct 2007 16:13:08 GMT

Thanks but it does the same: An object is required.

If you need additional data: that secondary datasource is shared from a sharepoint library and in other part of the code, I queried the DS and I get the value, but that value wasn't linked to the DS, was only on a text box and if I change it's value it wasn't updated on his DS.

Re: Problem changing a value from secondary data source

Matt Faus — Wed, 03 Oct 2007 16:04:12 GMT

This is probably too generic and does not provide a precise enough address, but it's worth a shot. Maybe it will narrow down the problem.

var StockVirtual = DOM_Articulo.selectSingleNode("//Stock_virtual[../@ID = '" + ID_Articulo + "' ]").text;

Re: Problem changing a value from secondary data source

GLazkano — Wed, 03 Oct 2007 15:37:38 GMT

Well, I tried it (with a few changes, my XPath hasn't any 'd:' namespace) and now it says that an object is required. The sentence is now:

var StockVirtual = DOM_Articulo.selectSingleNode("/dfs:myFields/dfs:dataFields/dfs:Articulos/Stock_virtual[../@ID = '" + ID_Articulo + "' ]").text;

I can't understand why it isn't working!

Re: Problem changing a value from secondary data source

Matt Faus — Wed, 03 Oct 2007 15:28:56 GMT

Yup, it's in the details. Try this:

var StockVirtual = DOM_Articulo.selectSingleNode("/dfs:myFields/dfs:dataFields/d:Articulos/@d:Stock_virtual[../@d:ID = '" + ID_Articulo + "' ]").text;

Re: Problem changing a value from secondary data source

GLazkano — Wed, 03 Oct 2007 09:03:02 GMT

Hi Matt,

Thanks for your reply. I read that blog post and finally that 'dfs' namespace is not a problem. But now I have still a problem. I'm sure it may be some stupid detail or something. but I cant fix it.

Now the code looks like:

var DOM_Articulo = XDocument.GetDOM("Articulos");
var ID_Articulo = XDocument.DOM.selectSingleNode("/inv:invoice/my:Bloque/my:Pago/my:datos/my:ID_Articulo");
var StockVirtual = DOM_Articulo.selectSingleNode("/dfs:myFields/dfs:dataFields/dfs:Articulos/@Stock_virtual[../@ID = ID_Articulo]").text;

But in the preview it fails with message: An object is required. Fails on the 3rd row ( var StockVirtual = DOM_Articulo.selectSingleNode("/dfs:myFields/dfs:dataFields/dfs:Articulos/@Stock_virtual[../@ID = ID_Articulo]").text; -> this row).

I don't know what fails. Can anyone tell me what is the problem?

Re: Problem changing a value from secondary data source

Matt Faus — Wed, 03 Oct 2007 07:39:18 GMT

Hi GLazkano,

This is because you have not defined the namespaces that exist on your secondary DOM. I think this blog post should point you in the right direction: http://www.infopathdev.com/blogs/matt/archive/2006/02/02/Setup-Namespaces-for-a-Secondary-Data-Source.aspx