Solved

serch in database which have numeric column

Posted on 2011-02-24
3
274 Views
Last Modified: 2012-05-11
in my tabe i have numeric  column type    it is number
when i use sql  Qerny
  sqlstr = "SELECT * FROM tbl WHERE  num  ='" & TextBox7.Text & "'"

Open in new window

when i click button give my msg problem ("deffrent type)
it can complet serch

i use visal basic 2005  and accssess
"
0
Comment
Question by:ziayd2009
3 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 34975615
sqlstr = "SELECT * FROM tbl WHERE  num  ='" & CInt(TextBox7.Text) & "'"
0
 
LVL 23

Accepted Solution

by:
wdosanjos earned 50 total points
ID: 34976874
Try:

sqlstr = "SELECT * FROM tbl WHERE  num  =" & TextBox7.Text

Open in new window

0
 
LVL 9

Expert Comment

by:mayank_joshi
ID: 34978765
try:-
sqlstr = "SELECT * FROM tbl WHERE  num  =" & Val(TextBox7.Text)

Open in new window


0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now