Log in to AnswerLog in to Follow
Jone Berti
11Views
6Comments
Solved
Alterar apenas o selecionado
Question
Aggregate
Database
Hello !!

I'm having a hard time making a change.

I'll try to explain

that I have 2 entities

would like to change a certain number save data belonging to another entity.

Be an Example of How YOU SHOULD.
example
example upgrad









Rel.
Client Nuber
Rel.
Client Nuber
2
C0
2
C0
2
C0
2
C0
4
B0
4
B0
4
B0
4
B0
4
B0
4
B0
4
B0
4
B0
5
C0
5
C0
5
C0
5
C0
5
C0
5
C0
5
C0
5
C0
2
B0
2
B1
2
B0
2
B1
2
B0
2
B1










0
0
on 17th Feb
Kadu Borges
Solution

Replying to Jone Berti's comment on 17 Feb 2021 21:24:16

Hi Jone,

You can use @input, like this: 

UPDATE {Scheduling}
SET {Scheduling}.[Reportid] = @NewReportid
FROM 
    {Scheduling} INNER JOIN {Report} ON {Scheduling}.[Reportid] = {Report}.[Reportid]
                 INNER JOIN {Client} ON {...}.[ClientId] = {Client}.[ClientId]
WHERE
    {Reports}.[...] = @inputReport AND {Client}.[...] = @inputClient

It is important to know that the syntax is database dependant. 

Hope it helps.

See solution in context
0
0
on 17th Feb
Daniël Kuhlmann
mvp_badge
MVP

2
0
on 17th Feb
Rui Barradas
mvp_badge
MVP

Hello Jone,

Hope you're doing well.


As far as I understood, you want to change the value for Nuber column in your entity for those specific records.

It seems that your entity has a composite key (Rel + Cliente attributes), so you need to filter by those 2 fields.


So you can use an SQL tool for that:

Something like this should do the trick:

UPDATE your_entity
SET nuber = 1
WHERE rel = 2 and Client = 'B'


Kind regards,

Rui Barradas

1
0
on 17th Feb
Thanks for the tip

how can I search for typed variables

UPDATE {Scheduling}. *
SET Reportid = ???
WHERE {Reports}. = ??? and {client}. = ???
0
0
on 17th Feb
Kadu Borges
Solution

Replying to Jone Berti's comment on 17 Feb 2021 21:24:16

Hi Jone,

You can use @input, like this: 

UPDATE {Scheduling}
SET {Scheduling}.[Reportid] = @NewReportid
FROM 
    {Scheduling} INNER JOIN {Report} ON {Scheduling}.[Reportid] = {Report}.[Reportid]
                 INNER JOIN {Client} ON {...}.[ClientId] = {Client}.[ClientId]
WHERE
    {Reports}.[...] = @inputReport AND {Client}.[...] = @inputClient

It is important to know that the syntax is database dependant. 

Hope it helps.

0
0
on 17th Feb
Rui Barradas
mvp_badge
MVP

Replying to Jone Berti's comment on 17 Feb 2021 21:24:16

Hello Jone,

Can you share your data model?

So we can check your entities, fields and foreign keys.


It would be also a good help for us if you can send us some insights of what you are trying to achieve.


Kind regards,

Rui Barradas

1
0
on 18th Feb
Good afternoon


entity (Programming)
Entity (Report)

the table where the programming entity appears is already stored the data

when i will save the report i have to assign the report number for each schedule that is already linked.

0
0
on 18th Feb
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.