Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 27, 2012 05:21 AM by nikunjnandaniya
Dec 24, 2012 04:40 PM|LINK
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.
Dec 25, 2012 02:02 AM|LINK
And your database is??
Dec 25, 2012 03:49 AM|LINK
Dec 27, 2012 05:21 AM|LINK
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)