Solved

Query Syntax

Posted on 2011-03-18
8
407 Views
Last Modified: 2012-05-11
okay someone wake me up here

I am making a simple query  VB.NET access DB  

SELECT ID, LN, FN,  Date_active FROM Clients
WHERE Date_active >=   ?
ORDER BY  LN


in my VB code i am biding it to a datetimepicker

 Private Sub DateTimePicker1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DateTimePicker1.ValueChanged
       
Dim Date_active As Date = DateTimePicker1.Value

        MembersTableAdapter.Fill(DsDataset.Clients, _
                                 Date_Active)
End Sub

When I run it its showing all the records   > ?          but NOT records  = ?  

much appreciated easy 2000 pts  

0
Comment
Question by:plusone3055
8 Comments
 
LVL 18

Accepted Solution

by:
Jerry Miller earned 500 total points
ID: 35169857
Are you sure that you have equal records? I mean down to the seconds? You could be comparing March 18, 2011 10:00:00 to March 18, 2011 10:00:01 and all you are seeing is March 18, 2011.
0
 
LVL 22

Author Comment

by:plusone3055
ID: 35169883
no the dates in the table are like 2/14/2011 not time
so I put  2/14/2011  in my datetimepicker (which is set to short)
and as stated before it display all records  > 2/14/2011   but not = 2/14/2011  

0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35169903
i suggest you to put a format to the date in your sql statement
different database handles date format differently.

for Sql Server it will look like this:
SELECT ID, LN, FN,  Date_active FROM Clients where Convert(varchar,Date_Active,103) >= ?

'103' is DD/MM/YYYY format, you can use other date formatting that you desired.
0
 
LVL 22

Author Comment

by:plusone3055
ID: 35169924
figured it out time format was wrong in the database
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35169933
its the default date format that the database handles which you can change the default date setting based on what database you are using. another solution is to set a date format in your sql query as I suggested.
0
 
LVL 22

Author Comment

by:plusone3055
ID: 35169957
sorry i thought i could reopen to give out poitns and its giving me **** about that really sorry ive never had a problem aewarding points to anyone :(
0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35170083
i think my suggestion works for the author problems.
0
 
LVL 40

Expert Comment

by:Sharath
ID: 35174101
try DATEVALUE to truncate the time part.
SELECT ID, LN, FN,  Date_active FROM Clients
WHERE DATEVALUE(Date_active) >=   ?
ORDER BY  LN

Open in new window

0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

21 Experts available now in Live!

Get 1:1 Help Now