@Whoa314 said:
Ok, I give up, I haven't had my coffee yet. How'd you get 17?
0xa = 10
"A"c - "0"c = 17
"a"c - "0"c = 49
@Whoa314 said:
Ok, I give up, I haven't had my coffee yet. How'd you get 17?
0xa = 10
"A"c - "0"c = 17
"a"c - "0"c = 49
I have to give props to that boss. Yes it's extremely arrogant, but what did he have to lose? If his intimidation worked he'd get an extra week out of you; if it didn't, well, you're gonna be gone anyway, and he'd already decided not to give you a reference.
How the heck do you do quoting with this editor?
<font face="Courier New" size="2"><font face="Courier New" size="2">
[code language="c#"]... AND NOT EXISTS (SELECT 1 FROM ...[/code]</font></font>
Damn straight. Anything Intuit gets its fingers into will turn to unusable money-sucking garbage, given a year or two. Intuit just bought my favorite bill-paying service (Paytrust). I am going to buy stamps.
<FONT size=2>Hope there's a check that nofc > 0 somewhere before this...</FONT>
[code language="vb"]if nofc > 0
avgwgt = round(pounds / nofc,0)
if pounds % nofc > 0
left = .t.
avgwgt = avgwgt + 1
remain = pounds
for x = 1 to nofc - 1
remain = remain - avgwgt
next
else
left = .f.
endif
select a
for x = 1 to b->nofc
append blank
replace package_id with key
replace serv_type with 4
replace cust_no with substr(b->clubno,1,5)+"-"+substr(b->clubno,6,3)
replace dest_code with d->zip
replace resident with "N"
if b->sendcode = "U"
replace pickup with 1
else
replace pickup with 2
endif
replace reference with h_jobno
replace zone with z
replace weight with avgwgt
replace filler with "000000000"
replace dimwgt with " "
replace oversize with "N"
replace addhandchr with " "
replace value with 0
replace confirmtyp with "0"
replace handling with 0
replace cod_amt with 0
replace cash_only with "N"
replace name with d->name
replace atten with d->address1
replace street with d->address2
replace city with d->city
replace state with d->state
replace phone with transform(d->phone,"(999) 999-9999")
replace zip with d->zip
key = key + 1
next
if left
replace weight with remain
endif
endif[/code]</FONT>
I'll have to take issue with your use of "relational" there. Relational theory doesn't have NULLs, because NULL is a non-value indicating a missing relation. SQL includes NULLs as a kluge to allow incompletely normalised data, and I agree that that results in a need for three-valued logic (among many other unpleasant complications).
Whoops -- typo in the original post. replace AND with OR.
But still, it's pretty stupid that you need to put that clause in anyway. Any value that is not 'XYZ' should include values that are NULL as well.
<FONT size=+0><FONT style="BACKGROUND-COLOR: #d3d3d3"> avgwgt = round(pounds / nofc,0)
if pounds % nofc > 0
left = .t.
avgwgt = avgwgt + 1
remain = pounds
for x = 1 to nofc - 1
remain = remain - avgwgt
next
else
left = .f.
endif</FONT>
</FONT>
Calling them "columns" is not even close to being unique to Oracle folk. It is SQL standard practice. Joe CELKO is constantly harping on this in comp.databases.ms-sqlserver.