> -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Kurt Wendt > Sent: Friday, May 07, 2010 2:25 PM > To: [email protected] > Subject: RE: Query Fails Under VFP9... > > Matthew - thanks - that WAS What was causing my problems! Once I set it > to the 7.0 version of the Behavious - it worked fine! > > Have a good weekend!
I think that over the years this way of writing SQL made a lot of us (okay - ME) lazy over time... when I saw SET ENGINEBEHAVIOR come out I knew the time had come to start doing it right, and as it happens that's when I started using PostgreSQL where I HAD to do it the correct way... I think this is one of the top three things that non-VFP folks would criticize about the VFP language: 1) untyped variables 2) non-standard SQL (as you've just seen) and 3) config parameters (SET things ON/OFF and such in the config.fp) would drive these people nuts.... Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -------------------------------------------------------------------------- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. _______________________________________________ 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/69f310c05dd83c48a84ba3769ce1ecf8032b2...@tntriexevs02.triadhospitals.net ** 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.
