Speaking of forgetting flowers, I would like to share how I wrapped a Valentine's Day present for my wife in 4 sheets of laser printer paper, using lots of clear shipping tape, just to be a Geek Ball Buster for her. But sharing that would mean going [OT], which I don't want to do, so I won't tell y'all about it for fear of being accused of abusing ProFox. Unless I can find a loophole...
Loophole Alert! >>> I did learn something from Ed the other year (I've actually learned lot from Ed over the past 8 years I have known him, also). Perhaps it would be of value to share it, so I can legitimately post this eMail and tell y'all about how Lynda called me from her office upon opening her Valentine Day present in front of her staff with all the layers of laser paper and shipping tape! Her folks were laughing their asses off! Not only are there going to be lots of boyfriends and husbands getting their arses chewed for forgetting Valentine's Day, they are going to get their arses ate for not being somewhat clever <g>... Okay, here is the VFP related deal. When I was using a SQL-SELECT statement to build a cursor via "SELECT * FROM Customer INTO CURSOR k_KursorName" (not a table specified within the SQL-SELECT command), then would use that cursor within a subsequent SQL-SELECT command, I would get an error message saying the command could not execute because "'k_KursorName' must be created with SELECT...INTO TABLE.". Well, I did not want to select the cursor into a table, as that meant I would have to later clean it up by deleting it. So, Ed enlightened me as to why that was happening, and how to overcome it. When doing a simple SQL-SELECT without any conditions VFP will (at times?) create a cursor in memory, not needing to write it to a temporary table. If I later try to use that "in memory only" cursor for a subsequent SQL-SELECT command, that subsequent command will fail because the cursor was not written to a temporary table internally by VFP. To get around that problem I merely have to use a condition with the previous non-conditional SQL-SELECT command, even if it is as simple as SELECT Customer.cCustNum FROM Customer WHERE .T. INTO CURSOR k_KursorName. Okay, guys, do not blow Valentine's Day. Go out and get your sweetie a card and gift, then wrapp the gift with laser paper and lots of tape. She will never forget it <g>... Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Paul Newton > Sent: Thursday, February 14, 2008 7:31 AM > To: [EMAIL PROTECTED] > Subject: Re: Inspiration Required > > > Dave Crozier wrote: > > I don't know about inspiration, Dave, but if you have set your calendar > back 10 days so that you have an excuse for forgetting to buy your wife > flowers today - well, it's not going to wash ... > > Paul Newton > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
