Hello Jeena, how are you?
So, only checking if I understood. You want to make insertion in
table from a SELECT query, right?
If, that what I says was right... here a suggestion:
Dim strSql As String = " Insert into Mess
(UserName,Number,Title,Lan,Txt,Status) " +
" (Select
UserName,NNub,Title,Lan,Txt,Status "
" From Group Where GroupName='" &
dllgroup.SelectedItem.Text & "' and UserName='" & strUserName & "')"
I use this to populate a table in SQL SERVER from MS. Maybe the
others database have the same feature, but in diferent sintax.
Try to execute this without any change, If do not work, try to make
the replaces in the SQL query and execute again.
PS: The SELECT query MUST be between parenthesis.
Any question...
[email protected] - GTalk
[email protected] - MSN
Huges,
Leandro Amorim
