zen_mtn_climber

Death Match . . yes! Just don't forget to sell the rights to it . . this could be the next big reality show . . Divorce Death Match . . let's get ready to ruuummmbbblle . . On a serious note, good job (IMO) on not taking sides and telling them both strongly not to drag you into it. In such an emotional situation as a divorce, it can be really hard to stay level-headed. I'm sure one or both of them would later regret pulling you into their mess and making you take sides. But right now they're probably not capable of it and don't really see what they're doing. They're just hurting and angry and looking for support from friends. So its your 'job' as a good friend to be strong with each of them and steer them clear of situations like this until their pain is a little less immediate and they can think a bit more rationally again. In time they'll heal to the point of each having their own lives and you'll be able to be friends with each if you can steer through this dicey time now. ZMC "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

You sir get my nomination for post of the day. That just made my crappy day here at work . . ZMC "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Shah, Went through a brutal emotional divorce myself many years ago and then an ensuing ugly custody battle. No need for me to get into the ugly details as its all long since done but I too was very risk averse. As a result I became very clear with myself about what I wanted out any future relationship. I had my list too . . Certainly didn't want to repeat the mistakes of the past. Nothing wrong with having list list, just remember the list is for you to be clear to yourself, not for someone else to feel they have to hold themselves against. Currently I'm in a fantastic relationship which totally validated my being clear about what I wanted out of one. Some things I did, that I don't see you doing are (1) being willing to just be alone for awhile .. (2) being patient while you wait for the right person and (3) living your life to its fullest as independent person who would like a good relationship but doesnt 'need' one. Not trying to pat myself on the back or anything . . I'm a recovering social misfit and I spent lots of years alone . . well me and my son. I thought about lowering my standards many times but was able to remind myself how unhappy I'd been because I hadn't stayed true to myself in the past. The relationships that I've been in over the years after my divorce, including the current fantastic one, all happened when I basically stopped working so hard to 'find' a relationship and just lived my life and did the things I loved. In the course of that I'd meet women who liked the same things I did, we'd have fun together and by being patient, having fun and not trying to force a relationship, it would just naturally happen (if it was ever going to). You mention being handcuffed to the wheel . . you're handcuffing yourself. Its not black and white. Be happy with yourself, do things that make you happy, whether you meet someone or not. Then when you do meet the right person, you'll meet them doing something you both love (IE: you'll have something in common) and she'll more likely be attracted to you because you're happy, fun, self-assured and relaxed. So I've been meaning to write you for awhile . . I lurk on the list and its tough to listen to you make things so hard for yourself. For all the grief they all give you, sounds to me like you mean well and have a pretty good heart. Just try to relax and let life flow rather than fighting the current so much . . Cheers, ZMC "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Harsh but excellent . . Hope you don't mind if I lift your lines below . . I've got at least one email per day here at work where this is the absolutely perfect response! "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Congrats! You gonna start hanging with the crowd at Skydance now or still make the drive to Lodi? "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

+1 I live in South Lake Tahoe and jump at Skydance. When you travel to Tahoe are you going to North Lake Tahoe or South Lake? If you are heading to North Lake Tahoe both Skydance and Skydive Sacramento are a very short jaunt off the freeway. If you are heading to South Lake Tahoe, Skydive Sac is out of the way. "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Hey wait a minute . . I live close to Reno . . Lake Tahoe to be exact . . There's a few of us close to or in Reno "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

My dogs believe that dog food sucks . . but people food, any kind of people food, absolutely rocks. And they've got a point . . if the dog food was so good, how come I'm not eating it ZMC

+1 to all this. I just bought my first rig at the beginning of the summer and I followed the same path as DaVincisEnvy to the 't' Worked out wonderfully "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

[replyNice! Jack Frost/Big Boulder or Camelback. I'll go anywhere up there.... just as long as they have high speed lifts. High speed quads make SO much diffference . . I remember by about 11am there'd be huge long lines at Jack Frost. My Mom and Dad and my brother and his family still ski there and say the lines are still long but the wait isn't so crazy. Hope you guys see some snow soon. We just got pounded with a week long storm cycle here in Lake Tahoe. Its going to be a skiing Thanskgiviing for us! "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

So that's why they call it ski season "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Ah the Poconos . . learned to ski as a teen in the Poconos before I moved West for college and stayed. Where do you tend to go? Spent lots of time at Jack Frost and Elk Mtn growing up. "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Ski, ski and ski some more . . did I mention that I like to ski Course that would be why I live in Tahoe . . . "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

I was confused . . I kept waiting for the green light and never saw it . . so I never pushed jump "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Rainbow Triathlon here . . so no crap from me "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Do you still have the code to create the supplier table after the code which creates the item table? The create statement for the item table contains a foreign key constraint against the supplier table. So the supplier table has to be created before the the item table. I'm off to bed . . really early morning of sys admin work for me. If you still have problems getting things running PM me in the morning and if I get some time tomorrow I'll drop your SQL code into the SQL Server in my test environment and see if I can pick out the last prob. Hope it works out K "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Ahh . . think I see it . . in the department table, dept_no is the primary key but your foreign key constraint is with department name in the employee table. I dont play in Orcale . . MS SQL server and MySQL myself but IIRC, a foreign key contraint will try to cross-check the foreign key in the table you are creating (In this case employee table) with the primary key of the referenced table (department table). Try making the department name the key in department table and see if the first two tables will create without error. "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

What happens if you try just create the first two tables (department and employee)? "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Looks to me like this line below is your problem because it come before the creation of the the supplier table which is done with this snippet Try moving the creation of the supplier table above the creation of the item table and see if your problems go away . . Cheers, K "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Exactly . . who would they be calling? Cell phone is kinda useless if its 1924 and there are no towers in existence for the cell phone to connect to "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

All that glitters is gold . . . "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Rhonda, Re: Craig (topdocker)'s inability to read your attachment . . you attached a .docx file which is from Word 2007/2010 . . older versions of MS Word can not read .docx files without a converter. This most likely is why Craig couldn't open your attachment. You should probably either do a Save As and and change the file type to .doc so people with older versions of Word can read your letter. Better yet, MS has a free "Save As PDF" add-on for Word 2007. Go to their site and in the search box type Microsoft Save As PDF and it'll lead you to the link to down load it. PDFs are more universally readable for this type of thing. Just my $0.02 . . sorry for the thread drift. And congrats on your silver medal . . very impressive accomplishment! Cheers, Keith "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Hee hee . . so much dripping sarcasm I think I'll need to clean my keyboard The post that really put a lump my throat was jumpwally's post at the end of the no pull thread from last week http://www.dropzone.com/cgi-bin/forum/gforum.cgi?do=post_view_flat;post=3936777;page=3;sb=post_latest_reply;so=ASC;mh=25; Sure some of it is ridiculous with the old super8 camera and duct tape but talk about a gripping loss of altitude awareness . . Yikes! "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

No you don't. You hate it. Just like all Canadians hate their universal medical care. That's what all my conservative friends here in the US tell me and there's no way that they aren't right. Excellent! "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo

Inquisitive . . "Whatever the future holds down the road, being true to yourself is something you won't ever regret doing. " - airtwardo