Same Error, different statement - Error 3146 running SQL statement in VB6
Posted on 2002-06-24
My setup is identical to the previous question I asked, and the situation is almost identical. The only difference is that I now need to run a select statement that queries on 2 fields and I'm still getting the 3146 error. Can I get one of you guys to look at this again and see if you can see what I'm doing wrong. I made the changes you suggested in previous question, and it worked great. I am using VB6 connecting to Oracle 8.0.5 database via DAO trying to select data that will be inserted into local database (oracle lite), but keep getting an error 3146: ODBC Call--Failed when trying to select the data.
I have 2 variables set via dialog box where user selects a value from drop down.
The SQL statement is as follows;
strSQL = "SELECT status, " & _
"projectNumber, " & _
"customerNumber, " & _
"customer, " & _
"Office, " & _
"CheckOutBy " & _
"FROM Project " & _
"WHERE Status='" & strFiltName1 & "' " & _
"AND WHERE Customer='" & strFiltName2 & "' " & _
"ORDER BY projectNumber"
strSQLCnt = "SELECT COUNT(*) as TotalProject " & _
"FROM Project WHERE Status='" & strFiltName1 & "' " & _
"AND WHERE Customer='" & strFiltName2 & "' "
The strsql statement is the one that sends program into error handler.
Let me know if I need to provide any further information.
Thanks for the help!!