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.
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)
Shanmugapriy...
Member
213 Points
328 Posts
Query
Dec 24, 2012 04:40 PM|LINK
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.
Lannie
Contributor
3840 Points
749 Posts
Re: Query
Dec 25, 2012 02:02 AM|LINK
And your database is??
Shanmugapriy...
Member
213 Points
328 Posts
Re: Query
Dec 25, 2012 03:49 AM|LINK
sql database.
nikunjnandan...
Participant
882 Points
223 Posts
Re: Query
Dec 27, 2012 05:21 AM|LINK
Hii,
As i understand from your description you shold try this way if anything else then please let me know.
Nikunj Nandaniya
My Blog