Results 1 to 2 of 2
  1. #1

    Default simple update using SQL. need help


    mga masters tabang lang gamay beh. mo ungot mn ko sa :
    Update = " update from charge set dsl = + dslVal + where chargeId = 1 ;"
    ang data type nko sa dsl sa tabale nko kay Double.. tabang lng gamay, although mra dale ra ni pra ninyo
    pro ng libog nko.. e set unta nko ang value sa dsl to dslVal..
    tabang doh! salamat lng daan mga Istoryans!


    still working on it right now...

    Private Sub Command1_Click()
    dim dslVal as Double

    If dslCK.Value = 1 Then
    dslVal = 1500
    select3 = " select * from charge ; "
    Set rscharge = db.OpenRecordset(select3)

    Update = " update from charge set dsl = + dslVal + where chargeId = 1 ;"
    Set rscharge = db.OpenRecordset(Update)

    End If

    by the way, i'm USING DAO 3.6

  2. #2

    Default Re: simple update using SQL. need help

    ay ok na.. ayaw nlng paeta sangit rko gamay "update from table" ako gmit.. "update table" rman d.i..
    my mistake

  3.    Advertisement

Similar Threads

 
  1. NEED HELP: where can i loan using ATM CARD as collateral?
    By +art+ in forum Business, Finance & Economics Discussions
    Replies: 50
    Last Post: 11-18-2017, 08:11 AM
  2. n95 8gb memory full/carosuel in use prob. ==> need help!
    By kenny_tiu7 in forum Gizmos & Gadgets (Old)
    Replies: 4
    Last Post: 02-02-2011, 11:01 AM
  3. Need help with which virus scanner is best and also free with updates
    By Maverick007 in forum Software & Games (Old)
    Replies: 18
    Last Post: 09-27-2007, 04:24 PM
  4. NEED HELP: How do I use two DSL connections in a single network?
    By batang^yagit in forum Networking & Internet
    Replies: 3
    Last Post: 09-22-2007, 02:45 PM
  5. Wrong email used (Premium Member)!!! Need Help Pepol
    By chek2chek in forum Support Center
    Replies: 2
    Last Post: 10-20-2006, 11:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
about us
We are the first Cebu Online Media.

iSTORYA.NET is Cebu's Biggest, Southern Philippines' Most Active, and the Philippines' Strongest Online Community!
follow us
#top