Subject:
|
Re: Cool new features at Brickbay
|
Newsgroups:
|
lugnet.market.theory
|
Date:
|
Wed, 29 Nov 2000 03:39:25 GMT
|
Viewed:
|
533 times
|
| |
|
|
In lugnet.market.theory, Kevin Wilson writes:
> when listing items-
> I also
> get strange results sometimes for the low, average, high previous sale
> prices: quite often the average is higher than the highest price!
I suspect that SQL treats data type currency as a character and not a
number. MS Access doesn't. Everything works fine on my test system (MS
access). To make a long story short, character data will always be higher
than a number. So "0.75" (character) will be higher than 1.00 (number) and
that's what's been happening --> when doing a check if item price > max
price the item was sold for, it will always replace the max price with the
item price. I put in a fix a week ago to convert everything to numbers
before doing a comparison but didn't have time to reupload a correct backup
of the price guide.
|
|
Message is in Reply To:
 | | Re: Cool new features at Brickbay
|
| D. Jezek wrote in message ... (...) But Dan, that still requires you to know what the part is called. Searching by part number is great when you have this weird doohickey, you don't know what it's called, but it has the number on it, so you can (...) (24 years ago, 28-Nov-00, to lugnet.market.theory)
|
24 Messages in This Thread:
 
 
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
