SPONSORS:






User Tag List

Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Sep 2001
    Location
    Albany, NY
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Update Statement (Help?)

    I have an UPDATE statement returning a large amount of data to an Access database. I ran out of room and had to make an additional UPDATE statement. This caused an error. Is there anyway to continue a sentence without receiving a syntax or is there another way to add a second UPDATE statement? Thanks!

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

  2. #2
    Senior Member
    Join Date
    Jun 1999
    Location
    Fremont, CA, USA
    Posts
    355
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SQL Update Statement (Help?)

    Not quite sure what you mean by "ran out of room"

    Can you post what your current UPDATE statement is and what is is your trying to get?



    ------------------
    David Genrich
    david@e2Open.com
    david_kim@usa.net

  3. #3
    Junior Member
    Join Date
    Sep 2001
    Location
    Albany, NY
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SQL Update Statement (Help?)

    [ ] hstmnt2 = DB_ExecuteSql
    (hdbc, "UPDATE Cash_Refund_Data_VUL_092501 set Policy_Status ='{sChanged}', Family_Term_Rider1 = '{sFamilyRider1}', Family_Term_Rider2 = '{sFamilyRider2}', Business_Term_Rider1 = '{sBusinessRider1}', Business_Term_Rider2 = '{sBusinessRider2}', Term_Insurance_Rider1 = '{sInsuranceRider1}', Death_Benefit_Option = '{sDeathBenefitOption}', Servicing_Agent_Name = '{sAgentName}', Agency_Number = '{sAgentNumber}', AsOfDate = '{sDate1}', Insureds_Name = '{sNewName}', Owners_Name = '{sAddress1}', Address1 = '{sAddress1}', Address2 = '{sAddress2}', Address3 = '{sAddress3}', Address4 = '{sAddress4}', Address5 = '{sAddress5}', Before_Cash_Value = '{sNetSurrenderValue1}', Before_Death_Benefit1 = '{sNetDeathBenefit2}',Before_Death_Benefit2 = '{sNetDeathBenefit2B}', Loan_Balance = '{sLoanBalance}', Accrued_Loan_Interest = '{sAccruedLoanInterest}', Test_LDB = '{sFinalTestLDB}', Term_Insurance_Rider2 = '{sInsuranceRider2}', Estate_Term_Rider1 = '{sEstateRider1}' where Policy_number = '{sPolicyNumber}'")


    When I goto add another (set =) I get a beeping noise notifying me that I can not add another record. I need to add at least 5 more to this update statement for this project. Like I said, I error out when adding a second SQL statement.

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

  4. #4
    Senior Member
    Join Date
    Jun 1999
    Location
    Fremont, CA, USA
    Posts
    355
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SQL Update Statement (Help?)

    That is a very long line. Try this:

    ------------------
    David Genrich
    david@e2Open.com
    david_kim@usa.net

 

 

Posting Permissions

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

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 07:14 PM.

Copyright BetaSoft Inc.