Results 1 to 5 of 5

Thread: Can anyone help : How to concatenate old values + new values using same column

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2010
    Posts
    4

    Can anyone help : How to concatenate old values + new values using same column

    Hi Friends .
    Plz help me .

    Dim New_Entries As String = ""
    Dim Old_Entries As String = ""

    If (dStyle_Updated <> "") And (dStyle_Updated <> dStyle) Then
    New_Entries = "Style(" & dStyle_Updated & ")"
    Old_Entries = "Style(" & dStyle & ")"
    End If
    If (dExteriorWalls_Updated <> "") And (dExteriorWalls_Updated.ToLower <> dExteriorWalls.ToLower) Then
    New_Entries = New_Entries & "," & "ExteriorWalls(" & dExteriorWalls_Updated & ")"
    Old_Entries = Old_Entries & "," & "ExteriorWalls(" & dExteriorWalls & ")"
    End If



    If (dExtrasComment_Updated <> "") And (dExtrasComment_Updated.ToLower <> dExtrasComment.ToLower)
    Then
    New_Entries = New_Entries & "," & "ExtrasComment(" & dExtrasComment_Updated & ")"
    Old_Entries = Old_Entries & "," & "ExtrasComment(" & dExtrasComment & ")"
    End If
    If New_Entries.StartsWith(",") Then
    New_Entries = New_Entries.Remove(0, 1)
    End If
    If Old_Entries.StartsWith(",") Then
    Old_Entries = Old_Entries.Remove(0, 1)
    End If
    If New_Entries <> "" Then
    AddColumns()
    SetEXLValue(cNo_NewEntries, New_Entries)
    SetEXLValue(cNo_OldEntries, Old_Entries)
    SetEXLValue(cNo_DataSource, DataSource)
    End If



    plz tell me how i can concatenate new value with old value

  2. #2

    Thread Starter
    New Member
    Join Date
    Mar 2010
    Posts
    4

    Re: Can anyone help : How to concatenate old values + new values using same column

    there is no one who can help me

  3. #3
    Addicted Member Smartacus's Avatar
    Join Date
    Oct 2009
    Location
    Deep South, USA
    Posts
    196

    Re: Can anyone help : How to concatenate old values + new values using same column

    New_Entries = New_Entries & " " & Old_Entries
    ***************************************************
    Smartacus comes packaged "As Is With No Warranty"

    ************* Useful Links ******************
    FAQs: Index / Database Development / .NET CodeBank /
    Before Posting Here...MSDN

    MZTools (I love this tool when using VB6 - Free) /

  4. #4

    Thread Starter
    New Member
    Join Date
    Mar 2010
    Posts
    4

    Re: Can anyone help : How to concatenate old values + new values using same column

    thnx brother .... it did work bcoz , my old values is updated by the new values . m try to store the oldvalues + new values ......

  5. #5

    Thread Starter
    New Member
    Join Date
    Mar 2010
    Posts
    4

    Re: Can anyone help : How to concatenate old values + new values using same column

    Quote Originally Posted by Smartacus View Post
    New_Entries = New_Entries & " " & Old_Entries



    hi there ... can u tell me how can i store my oldvalues & also to store the new values in othre column while my old values is updated to new values

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