Newbie Help

Results 1 to 3 of 3

Thread: Newbie Help

  1. #1
    Leesy Guest

    Default Newbie Help

    Can somebody please tell me how I assign a variable to something from my database?<BR><BR>I need to take a number from the DB, add something to it, then update it into the DB. The update procedure just replaces all the figures.

  2. #2
    Join Date
    Dec 1969

    Default It will replace all the figures UNLESS

    you provide a WHERE clause in your query. Post your code here and tell us what you are looking for exactly, may be we can help.

  3. #3

    Default RE: Newbie Help

    e.g. in an open recordset scenario...<BR><BR>Dim intNumber, intAnotherNumber<BR>intAnotherNumber = 100<BR>intNumber = cint( RS("fieldnumber") )<BR>intNumber = intNumber + intAnotherNumber<BR>.<BR>.<BR>.<BR>UPDATE RECORDSET or DB record depending on your implementation

Posting Permissions

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