Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Run-time error '3464' data type mismatch

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 07-09-2009
Member
 
Join Date: Jan 2009
Posts: 150
Run-time error '3464' data type mismatch
  

I am getting "Run-time error '3464': data type mismatch in criteria expression" error While trying to run below query.

Code:
SELECT table1.* FROM table1 WHERE
(table1.txt1='" & txt1 criteria & "') AND
(table1.longfield='" & longfield criteria & "')
What is wrong with my code? I am using the above SQL query with my VB6.

Reply With Quote
  #2  
Old 08-09-2009
Member
 
Join Date: May 2008
Posts: 2,382
Re: Run-time error '3464' data type mismatch

Your mistake lies in the last part.
Quote:
(table1.longfield='" & longfield criteria & "')
You have unnecessarily used "' in the last part, simply remove it and everything will be OK.
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
  #3  
Old 08-09-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: Run-time error '3464' data type mismatch

Well this depends on your code, if you don't need to add more statements then remove the last quotes before parenthesis but if you have any further statements then it is difficult to identify what is the problem. I need some more snapshot of your codes to identify the problem.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Run-time error '3464' data type mismatch"
Thread Thread Starter Forum Replies Last Post
Start tag/end tag mismatch error raeballi Windows Software 1 25-03-2012 01:13 PM
machine type mismatch error in Just Cause 2 Dhananjay Video Games 6 10-04-2010 08:28 AM
Error: "Arithmetic overflow error converting numeric to data type numeric." Nthing Software Development 3 11-06-2009 10:23 AM
Type mismatch in JOIN expression. (Error 3615) !const Software Development 3 19-05-2009 05:38 PM


All times are GMT +5.5. The time now is 02:58 PM.