How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask LogicPro Your Own Question
LogicPro
LogicPro, Computer Software Engineer
Category: Programming
Satisfied Customers: 12935
Experience:  Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
29751445
Type Your Programming Question Here...
LogicPro is online now
A new question is answered every 9 seconds

I wrote a query to update a field. The data changed in the

Customer Question

I wrote a query to update a field. The data changed in the table but not in my client. what did I do wrong?
Submitted: 6 months ago.
Category: Programming
Expert:  LogicPro replied 6 months ago.

Hi

welcome

Hope you are doing well

Follow these steps.

1. Execute update query on database

2. Execute commit statememt

3. Close your client

4. If you are using any server to connect to dtabase, close the server

5. Reatart the client and check. It should work

If still does not work, please let me know

You can leave arating on the answer if it worked

Have a good time

Expert:  LogicPro replied 6 months ago.

Got it my friend?

Customer: replied 6 months ago.
will not let me respond with my query but it did not work.
Expert:  LogicPro replied 6 months ago.

Which database you are using?

Customer: replied 6 months ago.
it wants me to enter credit card again. i'm not doing that.
Expert:  LogicPro replied 6 months ago.

Np. Let me know the database you are using?

Expert:  LogicPro replied 6 months ago.

And provide the query

Customer: replied 6 months ago.
it will not let me paste my query.
My database is Viewpoint. One of my tables is POIT. The where statement is Job = '16-060028.'
So I did not specify the database in my state. I just wrote it to Update POIT where the job = above and SET field RecvYN to 'Y'
Expert:  LogicPro replied 6 months ago.

After runnig this query, execute commit statement.

just write commit and execute it like you execute query

check in your client if new value is reflected

Customer: replied 6 months ago.
is there any way I could email you the complete statement. for some reason it will not let me copy it here
Expert:  LogicPro replied 6 months ago.

I am sorry friend, I cannot share my email address here.

If you want, I can provide the remote help but that would be for additional cost. Let me know

Customer: replied 6 months ago.
they already charged my card $5, then $49, then $39 - that needs to stop. It looks like they've already charged me for remote help.
Expert:  LogicPro replied 6 months ago.

Not yet charged for remote help. I will send for minimum like 8

let me know.

Related Programming Questions