Results 1 to 6 of 6

Thread: SQL syntax [RESOLVED]

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Resolved SQL syntax [RESOLVED]

    just wondering..

    if i open table via recodset i can do something like this..
    VB Code:
    1. rs("qty") = rs("qty") - 1
    2. if rs("qty") <= 0 then rs.delete
    then what i ask is if i want to use UPDATE SQL..is there possible to do something like that?

    thx for the input..
    Last edited by erickwidya; Feb 20th, 2005 at 11:18 PM.

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -


    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes

Posting Permissions

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



Click Here to Expand Forum to Full Width