|
Since we can't see the code, we're just guessing.
There are other ways to do what you want in SQL without using "SELECT *". ID'ing the database before hand and having the data layer switch queries based on that would be a better route to go, though it adds complexity.
|
|
|
|
|
Hi Dave, I just finished re-writing the code to remove any 4 column support completely and using strings to access the columns as it should be and drawing down the column names rather than using *
It causes me a slight problem when going back a couple of rows but I have a work around now.
I shall send this out to New Zealand now and wait an see what the result is!
I will let you know - either way.
Thanks. David
|
|
|
|
|
I finally got a reply from New Zealand.
On his Vista machine he has .NET 2.0.50727.4016 and mine is .NET 2.0.50727.3053
He only has the one database, which is the new 5 column one and he has run the latest version of the code which has no SELECT * and all data row elements are explicitly referred to by name.
When it runs it just errors its way through the file so basically it is not seeing this 5th field. Would the difference in ,NET numbers be significant?
|
|
|
|
|
Nope. You've both got .NET 2.0 SP2.
The problem seems to be that you're assuming the database has this 5th column, when it doesn't. Or, the code is looking at a different database than you think it is.
|
|
|
|
|
Thanks Dave
Yes I am beginning to wonder. I have to go on what he tells me, but of course I cannot confirm. I will call this a day here as I am sure the problem lies with the user.
Many thank for your assistance.
|
|
|
|
|
Hi,
What do I need to do display on a form my
1..My default printer
2..List of all my printers
Basically what reference do I need to import to get my printer properties.
P.S. Any sample code would be greatly appreciated.
|
|
|
|
|
An explicit list of printers is available through PrinterSettings.InstalledPrinters
.NET has some classes that help you with most aspects of printing. One often only needs PrintDialog and PrintDocument. If that is not sufficient, get ready for quite some complexity (maybe caused by how it all grew over time.
|
|
|
|
|
See here[^].
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
|
|
|
|
|
|
Say goodbye to your spam post...
|
|
|
|
|
Voted to remove becouse advertising is not allowed in these forums.
|
|
|
|
|
You tell him, Tiger!
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
|
ANd this has WHAT to do with VB.NET??
|
|
|
|
|
Hi,
How can I search for codes represent data type decimal(18,2)?
Have a code_textbox and search_button on a form.
have a query to seach code:
select * from commune_table
where (code=@code)
when I put value such as 2.02 no result yet the record is in the table correctly.
Thanks a lot!
|
|
|
|
|
You need to know that most real numbers (float, double) cannot be represented exactly using binary representations. So what is present in the database might well be 2.0199999976 which may be shown by some software as 2.02 but does not exactly equal 2.02
One way of getting around that problem is by not looking for an exact value, look for a range instead (say anything between 2.019 and 2.021). Another way, which I do not recommend, is by converting to string and chopping/rounding, then comparing.
|
|
|
|
|
Hi,
In the table code column shows values as 2.01,2.02 etc..
but if I pass a query for 2.01, I get no returned value.
again code data type as decimal(18,2)
thanks again..
|
|
|
|
|
and how do you pass your value (2.01 or 2.02) so that it ends up in @code?
is everything on its way a decimal, or are some non-exact floats/singles/doubles/reals used in the process?
|
|
|
|
|
Hi,
from a form in a textbox..you can simply in the value, it gets to table as you enter it
thanks
|
|
|
|
|
that is not answering my question.
without getting detailed answers or seeing all the relevant actual code I can't help you.
I repeat: reals/floats/singles/doubles anywhere in your path will cause inexact values in binary.
|
|
|
|
|
|
You should try reading his answer, before you post a new "hint" with a thankyou and hoping that Luc will post the correct code.
You're welcome
I are Troll
|
|
|
|
|
Now that you had a day's worth of time, try the statement below;
declare @code float
set @code = 2.435
declare @upperBound float
declare @lowerBound float
set @upperBound = @code + .01
set @lowerBound = @code - .01
select *
from commune_table
where code between @lowerBound and @upperBound
The database doesn't store the number "2.1", it stores a number that matches it very closely. That means that if you want to search for such a value, that you'd have to take a margin in account. No, this is not a simple solution to your problem, as you simply cannot search for a fractional number in the database the way you'd search for a string.
I are Troll
|
|
|
|
|
Hi,
In this case, what can I do?
the code list shows as 2.01,2.02
the end user needs to simply search for code from the list.
How can I achieve that..
Or if code represents as 2.0, 2.1,2.2,...2.10, 2.11, etc..what data type to use and would that aid my situation?
thanks..
|
|
|
|
|
I had about a year to find a way to disable ctrl + alt + del in windows vista & 7 in google, but until now I have not got it. Does anyone here know the code? Any help greatly appreciated. Thank you!
modified on Wednesday, January 5, 2011 6:26 AM
|
|
|
|