Update data from Collection into SQL Server

[plzampieri]

Hello,

I'm using a Collection to store data locally in mobile phone. What I do is I pull this data to a collection, make changes and want to send back to the SQL Server.

I'm using ForAll but this is not working. The collection name is 'clcDadosOffline'. The code is below:

  ForAll(clcDadosOffLine;
  Patch ('[dbo].[TropicalChamber]'; First(Filter('[dbo].[TropicalChamber]';identification=clcDadosOffLine.identification));{Week1_Carnal:    31; Week1_Flor: 41}))

What I'd like is: Get each line of the Collection, looking at the SQL Server (The field is 'identification'). Once I find this row, I'd update with new values.

Does anyone has a clue on how to make this work?

Thanks.

Paulo Zampieri

[timl · Accepted solution]

Hi Paulo,

Assuming that both '[dbo].[TropicalChamber]' and clcDadosOffLine contain a field called identification, the error might be due to incorrect disambiguation syntax.

I would try the following to see if that makes any difference.

 ForAll(clcDadosOffLine;
        Patch ('[dbo].[TropicalChamber]'; 
               First(Filter('[dbo].[TropicalChamber]';identification=clcDadosOffLine[@identification]));
               {Week1_Carnal: 31; Week1_Flor: 41}
        )
)

[plzampieri]

Hello, Timl

That worked pretty well.

thank you so much.

Paulo.

[leonardodcbv]

Does this solution really works? I used the same formula and works with a Collection, but it does NOT work with a SQL Server table.

Someone has a clue about how to make it work?

[leonardodcbv]

Forget it. I solved it adding a Primary key constraint to my SQL Server Table source.