sqldevrequiretektips
Programmer
Dim strSql As string
strSQL = "INSERT INTO tblWLActCat_WLDay ( CustLifeNo, WLActCatId, WLDayId, WeekNo )" & _
" Select A.Cust_Life_Num, A.WLActCatId, A.WLDayId, A.WeekNo" & _
" from WLActCat_WLDay A Inner Join" & _
" (select distinct (cust_life_num) from CUSTTB Where " & sqlDB & " ) B " & _
" On A.Cust_Life_Num = B.Cust_Life_num" & _
" And A.WeekNo In (1,2,3,4)"
scon.Execute strSQL, , adCmdText + adExecuteNoRecords
I am trying to run it from VB form command click event
I have error "Runtime error ! Join Expression Not Supported"
When Execute above query in SQL Server Query Analyzer..It's work fine...
Is anybody know what should i do, Is anybody know another way to execute query...to get same output..
Please help me out...
strSQL = "INSERT INTO tblWLActCat_WLDay ( CustLifeNo, WLActCatId, WLDayId, WeekNo )" & _
" Select A.Cust_Life_Num, A.WLActCatId, A.WLDayId, A.WeekNo" & _
" from WLActCat_WLDay A Inner Join" & _
" (select distinct (cust_life_num) from CUSTTB Where " & sqlDB & " ) B " & _
" On A.Cust_Life_Num = B.Cust_Life_num" & _
" And A.WeekNo In (1,2,3,4)"
scon.Execute strSQL, , adCmdText + adExecuteNoRecords
I am trying to run it from VB form command click event
I have error "Runtime error ! Join Expression Not Supported"
When Execute above query in SQL Server Query Analyzer..It's work fine...
Is anybody know what should i do, Is anybody know another way to execute query...to get same output..
Please help me out...