Results 1 to 2 of 2

Thread: Edit with SQL

  1. Jun 29th, 1999, 04:13 PM #1
    pedja
    pedja is offline

    Thread Starter
    New Member
    Join Date
    Jun 1999
    Location
    Podgorica, Montenegro, Jugoslavija
    Posts
    2

    Post

    How to edit all fields in a table.
    For exsample: I won to change all fields of prices and moltyply with 5.23



    ------------------
    Reply With Quote Reply With Quote
  2. Jun 29th, 1999, 05:20 PM #2
    Serge
    Serge is offline
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744

    Post

    I assume that you want to run this query directly in database:

    Update TableName Set FieldName = FieldName * 5.23

    ------------------

    Serge

    [email protected]
    [email protected]
    If you have any questions about AOL programming, e-mail me

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width