|
It is to be hoped that you are storing dates as DATE or DATETIME, not as strings, so that should not be a problem.
If you are storing dates as string, I strongly reccommend you refactor and do it the right way.
|
|
|
|
|
Thanks for the reply.
Yes I am storing data as DATE.
|
|
|
|
|
The at some point your a converting your test data from string to date and falling in a hole. That is where you need to deal with the format. Collation is not going to help you.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
As stated collation is not the problem. Look at SET DATEFORMAT and see if it will help. Hint you can set it for the process.
|
|
|
|
|
I have rechecked and have realised that problem emanate from crystal report.
I have crystal report based report that uses Store Procedure with parameters(that includes date) as its datasource.
I realised that when computer is on US culture , the report displays but when I try to display the report in UK culture it raises exception.
I used the same Store Procedure for DataGridView in both cultures (ie US and UK) and it worked with same parameters that did not work in crystal report.
|
|
|
|
|
You might have to ask in a Crystal Reports forum.
|
|
|
|
|
thanks for suggestion djj55. I appreciate your assistance
|
|
|
|
|
Sorry I could not be of more help.
|
|
|
|
|
noblepaulaziz wrote: but when I try to display the report in UK culture it raises exception.
What's that? You most of people don't include that in your question, don't know why? 
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
What is the difference between LEFT JOIN and LEFT OUTER JOIN?? i.e. what is the difference between INNER JOIN and OUTER JOIN??
I was confused with these two joins..
|
|
|
|
|
I got the answer friends. Both are same. Then why the concept of outer join came??
|
|
|
|
|
When writing a query, I like to be explicit about what is intended to do.
If I want only records with a match, they I say 'INNER JOIN'.
If I want partial matches, I say 'LEFT OUTER JOIN' or 'RIGHT OUTER JOIN' based on how I feel like writing the query, but it is usually 'RIGHT OUTER JOIN'.
Tim
|
|
|
|
|
Why cant we use left join instead of left outer join??
|
|
|
|
|
I did not write the design for whatever version of SQL is in use.
My personal preference it to be explicit in what I am doing.
If the version supports 'LEFT JOIN' and 'LEFT OUTER JOIN' and treats them the same, then use either one.
Some SQL instances use different syntax; I just like the use to be obvious to the reader.
|
|
|
|
|
|
Left Join and Left Outer Join is the same thing. It's just a matter of verbosity in the syntax
Politicians are always realistically manoeuvering for the next election. They are obsolete as fundamental problem-solvers.
Buckminster Fuller
|
|
|
|
|
ok . thanks for your reply.
|
|
|
|
|
|
Hi,
i'm implementing that using the method exposed in VB DataGridView Automatically Saving Updates to a Bound Database[^] but
how to handle exception thrown when DataAdapter.Update is called in RowValidated?
I can catch the exception with a Try but how to cancel the move to a new row and to force user to correct the edited row?
What i would obtain is a "SQL Server Management Studio-style". When you edit a row and move to another, if an exception is detected (duplicate key for example), a message is shown, the edit glyph is mantained in the edited row and cursor remain on the edited row.
Thanks
|
|
|
|
|
Before it's validated, it will be validating[^].
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Does anybody know if there is a performance difference between these two example queries:
SELECT * FROM tblFox WHERE stringFieldValue IN ('Ring-ding-ding-ding-dingeringeding!', 'Wa-pa-pa-pa-pa-pa-pow!')
SELECT * FROM tblFox WHERE stringFieldValue='Ring-ding-ding-ding-dingeringeding!' OR stringFieldValue= 'Wa-pa-pa-pa-pa-pa-pow!'
????
I would Google it if I knew what to enter to get a relevant answer... 
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-----
I'd just like a chance to prove that money can't make me happy.
Me, all the time
|
|
|
|
|
I did not know exactly that there is performance difference. But query using IN will reduce your typing and looks good. If there are few more data to search in OR condition, You type field name again and again??
|
|
|
|
|
Depends on what database you're using and what indexes you have in place, but normally the query optimizer would realize that they are the same thing.
Politicians are always realistically manoeuvering for the next election. They are obsolete as fundamental problem-solvers.
Buckminster Fuller
|
|
|
|
|
Johnny J. wrote: Does anybody know if there is a performance difference between these two example queries:
Not so much difference I think. But I prefer IN instead of OR in this case. Using IN you could write cleaner query. What would you do if there're 10+ OR conditions in your query?
Johnny J. wrote: I would Google it if I knew what to enter to get a relevant answer...
I tried http://www.google.com/search?q=SQL+IN+vs+OR[^] & got this one
SQL Speed Test: IN vs OR[^]
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|
If you are using SQL Server, you could use "Show Execution Plan" and see if there is a difference.
If you are using Oracle, I believe there is a 1000 element limit to the "IN" clause. At a previous company I worked for we got bit by this. (This was a while ago, maybe Oracle 9, it may not be an issue now)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
