Updating data using a query

Karen

Delphi Developer

Thu, 16 May 2002 03:00:00 GMT

Updating data using a query

How do I use a Query to change the data in a table. Do I have to use
"Request Live". Can someone please walk me through a very short, simple,
example. Thanks, Karen

Sundial Service

Delphi Developer

Fri, 17 May 2002 03:00:00 GMT

Re:Updating data using a query

This is called a "CHANGETO" query, or in SQL, an "UPDATE" query. It
does not return any results, so "Request Live" does not apply.

Quote

>Karen wrote:

> How do I use a Query to change the data in a table. Do I have to use
> "Request Live". Can someone please walk me through a very short,
> simple, example. Thanks, Karen

--
----------------------------------------------------------------------
Sundial Services :: Scottsdale, AZ (USA) :: (480) 946-8259
mailto:i...@sundialservices.com (PGP public key available.)

Quote

> High-speed, script-driven, table repair/support for Paradox/BDE...
> ChimneySweep{tm}: "Click click, it's fixed!" {tm}
> http://www.sundialservices.com/cs3web.htm

Other Threads

1. Update query using data from another table

2. How to do an Update query or a Delete Query or an Insert Query using D3

3. Saving TMemo field data to a Blob field (Interbase Table) via SQL Update Query

4. updating record in a join query using ADO and Midas Component

5. How can we update or insert dataset with using Joined Query

6. Doing an update using an aggregate sub-query

7. Updating several tables from a query using UpdateSQL Components

8. Using parameters with an update query

9. How To update Memo fieds using query ?

10. Using Cached Update, the last Data is not deleted