Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    2

    Unanswered: converting Oracle SQL to UDB

    Hello,

    I am having trouble converting the below into UDB compatible format the below is sent from a VB front end down to the DB:

    NextRollOverDate = ADD_MONTHS(LastRollOverDate, " & Str$(intNextTerm) & "* 12)

    Could someone please help??? - I'm in big trouble here.........

  2. #2
    Join Date
    Jun 2003
    Posts
    2
    GOt IT!!!!!!!

    strSQL = strSQL & " NextRollOverDate = LastRollOverDate + " & Str$(intNextTerm * 12) & " MONTHS , "


    Sorry to bother everyone, just thought I should post the answer.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Sorry to bother everyone, just thought I should post the answer.

    That's kind of you ... Thanks for that ....

    Cheers

    Sathyaram

Posting Permissions

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