We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

TUPDATESQL - SOMEBODY HAVE EXAMPLE HOW TO USE THAT COMPONENT.

rafaelrgl
rafaelrgl asked
on
Medium Priority
1,205 Views
Last Modified: 2008-01-09
I´m building a program using TUPDATESQL, but I don´t know how make anyupdate on bd by this component.

here is the sentence sql build by the component TUPDATESQL.
//////////////////////////////////////////////
update TB_USER
set
  ID = :ID,
  USER= :USER,
  PASSWORD = :PASSWORD,
  NAME = :NAME,
  PHOTO = :PHOTO
where
  ID = :OLD_ID
/////////////////////////////////////////////

How this code is going to work if I have dbfields on the form1, like DBUSER OR DBPASSWORD AND IN OTHER DIFERENT FORM (Costumer Data Module) I have TQuery, TDataSourc, TUpdateSQL and Database1 Components.

If you have any example how to use TUpdateSQL, Plese Send me in my e-mail: <<email removed

kretzeschmar
Page Editor
>> or put the link here.

Thanks so Much for help me.
Comment
Watch Question

Top Expert 2004

Commented:
usual the TUpdateSQL is linked as an updateobject to a TQuery,
where its cachedupdates are set to true

digging for a sample . . .

meikl ;-)

Top Expert 2004
Commented:
phew, i shall do what i provide ;-)

visit this link
http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_11297937.html

there is a good description from workshop_alex

meikl ;-)

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.