locked
Query RRS feed

  • Question

  • User-286235245 posted

    Hi friends,

                  I want to store a character in table like the followed details,

    In my table am having three columns. and am giving the input like "Shanmuga Priya Nadimuthu" means it will store in that table at first column "Shanmuga" should save, and in second column "Priya" sholud enter, and in third column "Nadimuthu" should enter. I dono how to write query for that. Can any please help me to resolve this problem. It is an immediate issue.

    Thanks in advance.

    Monday, December 24, 2012 12:40 PM

Answers

  • User221175343 posted

    Hii,

    As i understand from your description you shold try this way if anything else then please let me know.

    Dim strFirstName AS String
    Dim strMiddleName AS String
    Dim strLastName AS String
    
    --Shanmuga Priya Nadimuthu
    --ON FirstName enter
    strFirstName = "Shanmuga"
    
    --On MiddleName enter 
    strMiddleName = "Priya"
    
    --On Last Name enter
    strLastName = "Nadimuthu"
    
    --ON LastName enter make query or make stored procedure and pass these 3 parameter.
    INSERT INTO TABLE (FirstName,MiddleName,LastName) VALUES (strFirstName,strMiddleName,strLastName)
    
    



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 27, 2012 1:21 AM

All replies

  • User269602965 posted

    And your database is??

    Monday, December 24, 2012 10:02 PM
  • User-286235245 posted

    sql database.

    Monday, December 24, 2012 11:49 PM
  • User221175343 posted

    Hii,

    As i understand from your description you shold try this way if anything else then please let me know.

    Dim strFirstName AS String
    Dim strMiddleName AS String
    Dim strLastName AS String
    
    --Shanmuga Priya Nadimuthu
    --ON FirstName enter
    strFirstName = "Shanmuga"
    
    --On MiddleName enter 
    strMiddleName = "Priya"
    
    --On Last Name enter
    strLastName = "Nadimuthu"
    
    --ON LastName enter make query or make stored procedure and pass these 3 parameter.
    INSERT INTO TABLE (FirstName,MiddleName,LastName) VALUES (strFirstName,strMiddleName,strLastName)
    
    



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 27, 2012 1:21 AM