Toad World® Forums

unable to update in query Builder.


#1

I am joining two tables in Query builder and then trying to update . But the update statement is disable… I am using Oracle Database. Could any one pls help me out.


#2

can you provide more details and maybe a screen shot? What are you trying to update, the query or data or? What steps are you taking?


#3
            Hi Mark,



            Thanks for the reply . will provide the details with screenshot. Apart from that, I have few basics doubts in Query builder.

It will be great if we can schedule a Meeting. This will really help us to clear our doubts and will able to work in more efficient with Toad data point.

Kindly let me know your suitable timing.

Regards,

Somu

From: Mark Kurtz [mailto:bounce-Mark_Kurtz@toadworld.com]

Sent: Wednesday, May 23, 2018 5:38 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] unable to update in query Builder.

RE: unable to update in query Builder.

Reply by Mark Kurtz

can you provide more details and maybe a screen shot? What are you trying to update, the query or data or? What steps are you taking?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point Forum
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.


#4

have you viewed any of these free training videos? community.toadworld.com/…/writing_queries


#5
            Hi Mark,



            I have already viewed the training videos. But I was not able to get the details.



             I have joined two tables based up on the team ID and want to update the EMP NM. Attached the screenshot of the same. The update statement is disabled .





            Kindly let me know how to proceed further.



            Regards,

            Somu

From: Mark Kurtz [mailto:bounce-Mark_Kurtz@toadworld.com]

Sent: Wednesday, May 23, 2018 6:53 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] unable to update in query Builder.

RE: unable to update in query Builder.

Reply by Mark Kurtz

have you viewed any of these free training videos? community.toadworld.com/…/writing_queries

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point Forum
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.


#6

The JOIN to Team is unnecessary if you are just trying to adjust an Employee Name. If you remove the join and just update the Employee Name for Employee ID 8001, you will be fine.

John Mc Graw
Data and Reporting Specialist

P 303-866-6974

1575 Sherman Street, Denver CO 80203

john.mcgraw@state.co.us I www.colorado.gov/cdhs

On Wed, May 23, 2018 at 11:09 AM, somu02 bounce-somu02@toadworld.com wrote:

RE: unable to update in query Builder.

Reply by somu02
Hi Mark,

            I have already viewed the training videos. But I was not able to get the details.
             I have joined two tables based up on the team ID and want to update the EMP NM. Attached the screenshot of the same. The update statement is disabled .

            Kindly let me know how to proceed further.
            Regards,
            Somu

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad Data Point Forum notifications altogether.

Toad Data Point - Discussion Forum

Flag this post as spam/abuse.


#7

Yes, for this query we can update with the Employee ID … My question was… when we have such kind of scenario like we are joining multiple tables and want to update on one of the table, so how to update the tables in Toad data Point.

Fox example: We are having 2 tables employee and employee Profile. The relationship is showed below. I need to update both the tables based up on the join condition.

The query used in sql editor:

  1. UPDATE employee
  2. INNER JOIN
  3. employee_profile ON (employee_id = employee_profile_employee_id )
  4. SET
  5. employee_details = ‘New Value’,
  6. employee_profile_first_name = ‘Bob’
  7. where employee_id = 1;
    I would like the same to be done in Query builder. But in the Query builder when I tried , the update statement was disabled.EMP_DETAILS.jpeg

#8

We will never be able to update two tables from QB. Leave as is.